1. Design a database to help a large art museum keep track of its works of art. Each work of art is

described by an item code (identifier), title, type (i.e. painting, sculpture, etc.), genre (i.e. abstract,

photograph, etc.), height, width, and weight. A work of art may be of more than one genre, but it is of

only one type. Each genre may be related to more than one work of art. Each type may be related to

more than one work of art. The museum wants to create separate lists of the types and genres of art work

available at the museum. The museum has predefined the descriptions of types and genres and wants to

standardize them for greater consistency of data.

A work of art is created by one and only one artist, but the artist for some works is unknown. An artist is

described by an artist ID (identifier), name, date of birth, and date of death (the date of death will be null

for artists who are still living). Only data about artists for works currently owned by the museum are kept

in the database. It is quite possible that one artist can create more than one work of art.

The museum wants to keep track of the location of each work of art over time. At any point in time, a

work of art is: 1) on display at the museum, 2) in storage, 3) away as part of a traveling show, 4) on loan

to another museum, or 5) in transit. The museum wants to retain a complete history of the placement of

works of art. They want to know when (beginning and ending dates) and where a work of art was located

at any given point in time. They want to be able to tell where a work of art is right now, but they also

want to be able to tell where a work of art was two years ago. They want to know such things as how

many works of art have been loaned to another museum. They want to know which works of art have

been away in traveling shows. They want to know how long a particular work of art is in storage.

Assume that all date fields also can contain time, so there is no need to separate date and time into

separate fields.

If on display at the museum, the work of art is also described by its location within the museum. A

location within the museum is defined by a building #, room #, wall # and position #. You do not have to

keep any other information about the internal locations within the museum (like a description of the

building or room).

A traveling show is described by a showID (identifier), title of the show, city and country in which the

show is currently appearing, and the start and end dates of the show. The start and end dates of the show

may be different than the beginning and ending dates that the work of art was at the show. For example, a

show might last for six months in one location, but a specific work of art may be at that show for only

four of those six months.

Other museums are identified by a museumID, the name of the museum, and the location (city, state,

country). There is no standard identifier like a zip code for these museum locations, since the museums

could be anywhere around the world.