Draw an ERD diagram for the scenario below.

Each work of art will have an item code assigned to it that will allow the museum to uniquely identify it. In addition, the museum also wants to keep track of the items title (e.g., The Persistence of Memory), category, size (dimensions), weight, origin, date created (if known), period in history (e.g., 11th century), medium, item description, provenance, ownership, and status. Each item can belong to only one category (e.g., painting, sculpture, etc.), but the museum will most likely have several items belonging to the same category.

Each item might have gone through multiple conservations, but it might as well be in its original state. If any conservation was performed, the museum will need to keep track of the contractor who performed it, conservations beginning and ending dates, and the description of the type of work that was performed. The museum will also want to have a list of the contractors on file (name, address, representative name, phone, email, fax, website), so that they can be contacted should the need occur. The museum can use a contractor for multiple jobs, but it does not have to (for example, if the museum does not have any items in which a contractor is a subject matter expert).

Each work of art has an artist behind it, but in some cases the artist remains unknown. For each artist, the museum will keep track of the artists internally assigned unique identifier, artist name, nationality, date and place of birth, date and place of death, and short biography. Each work of art, at any point time, is either on display, held at storage, away from a museum as part of travelling on a show, or on loan to another museum or institution. If on display at the museum an item is also described by its location within the museum. 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 items may be part of a given show, and only active shows with at least one museum work of art need to be represented in the database.

Finally, another gallery is described by a gallery ID (identifier), name, and city. 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 was loaned and the date it was returned.