Part 1 Logical Design
Video Centers of Europe, Ltd. is a chain of movie DVD rental
stores. It must maintain data on the DVDs it has for rent, the movies recorded on the DVDs, its customers, and
the actual rental. Each DVD for rent has a unique serial number. Movie titles and customer numbers are also
unique identifiers. Assume that each movie has exactly one star. Note the difference in the year that the
movie was originally filmed and the date that a DVDan actual diskwas manufactured. Some of the attributes and
functional dependencies in this environment are as follows:
Part 2 Physical Design
Consider the following relational database for Happy Cruise
Lines. It keeps track of ships, cruises, ports, and passengers. A cruise is a particular sailing of a ship on a
particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2003, and is
a cruise. Note the following facts about this environment: - Both ship number and ship name are unique in the SHIP
Table. - A ship goes on many cruises over time. A cruise is associated
with a single ship. - A port is identified by the combination of port name and
country. - As indicated by the VISIT Table, a cruise includes visits to
several ports and a port is typically included in several cruises. - Both Passenger Number and Social Security Number are unique in
the PASSENGER Table. A particular person has a single Passenger Number that is used for
all of the cruises that she takes. - The VOYAGE Table indicates that a person can take many cruises
and a cruise, of course, has many passengers.
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.
