CSC 455 Fall 2012

Chapter 3 Lab 2

50 points if done by beginning of class Friday, 9/14

1) Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies. Design an Entity- Relationship diagram for the movie database.

2) An art museum owns a large volume of works of art. Each work of art is described by a unique item code, title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by a unique artist ID number, name, date of birth, and date of death (which is null for still living artists). Only data about artists for works currently owned by the museum are kept in the database. At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location within the museum. A traveling show is described by a unique show ID, the city in which the show is currently appearing, and the start and end dates of the show. Many of the museum works may be part of a given show, and only active shows with at least one museum work of art need be represented in the database. Finally, another gallery is described by a unique gallery ID, name, and city. The museum wants to retain a complete history of loaning a work of art to other galleries, and each time a work is loaned, the museum wants to know the date the work was loaned and the date it was returned. Draw an E-R diagram for this scenario.