VIdeo, a local video renting shop, Is considering creating a database to keep track of various aspects of the store. Impressed by your IS knowledge and skills, the management has decided to hire you to design a conceptual data model first. Video has films of various genres (such as Drama, Horror, Action, Comedy, Foreign, Educational) for rent. Each film is uniquely identified by a Film ID. Each film is also described by a title, a rate, its genre, and possibly one or more directors.
For some special kinds of films, more information is recorded. For instance, each foreign film has a spoken language and a subtitle language. Each educational film has a recommended age group, which can take the values of “infant”, “child”, “teenager”, “adult”, and “senior. Video carries zero or more DVD copies of each film. Each copy has an index number that is unique among all the copies of the same film. But copies of deferent films may have the same index number.
Video allocates a unique customer ID for each customer. Other information about a customer includes name (first name, middle initial, and last name), address (street, city, state), phone number, birth year (to compute age), and total rental amount. Every time a customer wants to rent some copies of films, video database should records the checkout date, due date, and amount paid. A customer with an age under 18 cannot rent a film rated “18 or above”.