20100366段卫军Assignment 2.docVIP

School of Economics Business Administration Chongqing University Assignment #02 Course Name Database Principle and Application Name of Student 段卫军 Student ID Class 信息管理与信息系统01班 Major 信息管理与信息系统 Instructor Dr. Yong Li Tutor Bowen Zhang Completed Time 2012-3-25 Score CQU Database Principles and Application Instructor: Yong Li Assignment 2 Perform conceptual design for the following case. You must turn in both an ER diagram and a specification document that includes additional constraints not shown on the diagram. If you believe that you need to make additional assumptions, clearly state them in the specification. Continental Palms Video (CPV) is considering creating a database to keep track of various aspects of the store. Impressed by your MIS knowledge and skills, the management of CPV has decided to hire you to design a conceptual schema first. CPV has various kinds (Classic, Horror, Action, Comedy, Foreign, Educational, etc.) of Films for rent. Each film is uniquely identified by a Film ID. Each film is also described by a title, a rate, and possibly one or more directors. For some special kinds of films, more information is recorded. Each foreign film has a spoken language and a subtitle language. Each educational film has a recommended age group, which can have values “infant”, “child”, “teenage”, “adult” and “senior”. To allow customers to search for films based on their preferred performers, CPV also records the information about performers, their name, Christian name, and stage name. Stage name is assumed to be unique among all the performers although name and Christian name are not. A film may have zero or more performers. Each performer performs a role ( r, supporting actor, etc) in a film and may perform in many films. CPV carries zero or more copies of each film. Each copy