20100371秦瑶_作业二.docVIP

Specification Document A film may have zero or more performers. Each performer performs a role (leading actor, supporting actor, etc) in a film and may perform in many films CPV carries zero or more copies of each film. Each copy has a copy number that is unique among the copies of the same film. But multiple copies of different film may have the same copy number The condition of a copy is between 1 (new) and 5 (broken) Each copy belongs to one copy type (classical video tape, new arrival video tape, or DVD) Each copy type has a rental price and a number of nights allowed for each rent The number of nights per rent is between 1 and 10 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 思路清晰，但结构相对比较简单。 (1)The kinds of films? (2)The constrains of directors? (3)Each performer performs a role (leading actor, supporting actor, etc) in a film and may perform in many films? (4) CPV carries zero or more copies of each film?