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 (painting, sculpture, etc.), genre (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. The museum wants to create a list 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 developed 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 (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 produce more than one work of art. 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, or
4) on loan to another museum.

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 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.
If on display at the museum, the work of art is also described by its location within the museum. A traveling show is described by a showID (identifier), city in which the show is currently appearing, and the start and end dates of the show. Other museums are identified by a museumID, the name of the museum, and the location (city, state, country).