This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Introduction to Database Design I S410, Section 8535 Fall 2011 Assignment 1, Due before the class on Tuesday, Sep.27 Perform conceptual design for the following case. You must turn in a softcopy of both an ER diagram and a specification that includes additional constraints not shown on the diagram. The specification should be written in English. If you believe that you need to make additional assumptions, clearly state them in the specification. RedBox, 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 schema first. RedBox has various categories (Classic, Horror, Action, Comedy, Foreign, Educational, etc.) of Films for rent. Each film is uniquely identified by a Film ID. Each film is also described by a title, a rate, its category, and possibly one or more directors. For some special kinds of films, more information is recorded. Each foreign film has a spoken language and a subtitle language. Each educational film has a recorded....
View Full Document
- Spring '08