An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size. The size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works may be unknown. An artist is described by the first and last names (which together serve as the identifier), date of birth, and date of death (which is null for still living artists). Only data about artists for the works currently owned by the museum are kept in the database. At some points, a work of art would be away from the museum as part of a traveling show, or on loan to another gallery. 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, and only active shows with at least one museum work 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 (which is null if the art work is not retuned yet). Required:
Develop the ERD for this problem