Reference no: EM131652488

An art museum owns a large volume of works of art. A work of art is developed by an artist (either still living or dead), but the artist for some works is unknown. 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. 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. The museum wants to retain a complete history of loaning work of art to other galleries, and each time a work is loaned, the museum wants to know the date the work is loaned, and the date it was returned. Client wants list of all attributes for the entities that you feel are comprehensive