20100367信管01班贾强伟.docxVIP

School of Economics Business AdministrationChongqing UniversityAssignment #02Course Name Database Principle and ApplicationName of Student 贾强伟 Student ID Class 01班 Major 信管 Instructor Dr. Yong LiTutor Bowen Zhang Completed Time 2012 - 3 – 26Score 整体架构是对的，但有些关系比较混乱，比如“customer”与“performers”Additional Business RulesFilm kinds include (Classic, Horror, Action, Comedy, Foreign, Educational, etc.)Every film has possibly one or more directors. Recommended age group can have values “infant”, “child”, “teenage”, “adult” and “senior”Each performer performs a role (r, supporting actor, etc)The condition of a copy is between 1 (new) and 5 (broken).Copy type includes (classical video tape, new arrival video tape, or DVD).The number of nights per rent is between 1 and 10.Name includes (first name, middle initial, and last name)Address includes (street, city, state, zip),A customer with an age under 18 can not rent a film rated “18 or above”A broken copy can not be rented any more.