Design Simple Access Database

Design the database and draw an ER diagram. An art museum owns a large volume of work of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but each artist may have many works. An artist is described by an [Artist_ID] (identifier), name, date of birth, and date of death (which is null for still living artists). At any point in time, a work of art is either on display at the museum, 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 ([Location_ID]) within the museum. Each work of art is associated with one fixed location. A traveling show is described by a [Show_ID] (identifier), 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. On the other hand, each work of art may be in different show at different periods. The database should store historic data about which item was in which show. Finally, a gallery is described by a [gallery_ID] (identifier), name, and city. Each work could be loaned to different galleries at different periods. Each gallery may also request many different works. 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 is loaned and the date it was returned. This is a quick and easy project.