20100356-官子力-作业二.docVIP

School of Economics Business Administration Chongqing University Assignment #02 Course Name Database Principle and Application Name of Student Guan Zili Student ID Class 2010 Major Information Management Instructor Dr. Yong Li Tutor Bowen Zhang Completed Time 2012 - 3 - 19 Score Additional constraints: The kind of each film is one of (‘Classic’, ‘Horror’, ‘Action’, ‘Comedy’, ‘Foreign’, ‘Education’, ‘Other’). Age_demand of each film is ‘Under 18’ or ’18 or above’. Age group must be one of (‘infant’, ‘child’, ‘teenage’, ‘adult’, ‘senior’). Role is one of (‘Leading actor’, ‘Supporting actor’, ‘Other’). Condition of each copy is between 1 (new) and 5 (broken). Type name must be one of (‘VCD’, ‘DVD’, ‘Blue DVD’). Each rental night is between 1 and 10. The age of each customer is computed from Birth year. 整体思路和框架不错，加油！