20100369_廖显浩_Assignment_02.docVIP

School of Economics Business Administration Chongqing University Assignment #02 Course Name Database Principle and Application Name of Student 廖显浩 Student ID Class 信息管理与信息系统 Major 信息管理与信息系统 Instructor Dr. Yong Li Tutor Completed Time 2012 -03-19 Score Business Constrains: (1)The films have various kinds(Classic, Horror, Action, Comedy, Foreign, Educational, etc.). (2) Each Film possibly has one or more directors (3) Each educational film has a recommended age group, which can have values “infant”, “child”, “teenage”, “adult” and “senior”. (4) Each performer performs a role (leading actor, supporting actor, etc). (5)The copy type includes VCD, DVD, or Blue Ray. (6) The condition of a copy is between 1 (new) and 5 (broken). (7)The number of nights per rent is between 1 and 10. (8) 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. 整体架构不错，但有单词写错，rentail?