20100357兰茜实验二.docVIP

E-R 图 Constraints for the Continental Palms Video DB 1. 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”. 2. The condition of a copy is between 1 (new) and 5 (broken). 3. copy type must be one of (classical video tape, new arrival video tape, or DVD). 4. Each copy type has a rental price and a number of nights allowed for each rent, which apply to all copies of the type. The number of nights per rent is between 1 and 10. 5. The total amount is calculated from the rental prices of the copies included in the rental agreement. 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. 思路大体正确，但不够完整。缺少CPV has various kinds (Classic, Horror, Action, Comedy, Foreign, Educational, etc.) of Films for rent. Copy type应该独立列出， 3. 缺少address字段