Design an ERD and SQL for the following situation. Express any many$-$to$-$many relationships with an associative entity. An art museum owns a large volume of works of art. Each work of art is described by an item Code, title, type and size. Size if further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID$,$ name, date of birth, and date of death $($which is NULL for still living artists$).$ Only data

about artists for works currently owned by the museum are kept in the database. At any point, a work of art is either on display at the museum, held in storage, away from the museum as part of a travelling 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. A travelling show is described by a show ID$,$ the city of the show, 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 of art need be represented in the database. Finally, another gallery is described by a gallery ID$,$ 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.