Draw an ERD for the following situation. If you believe that you need to make additional

assumptions, clearly state them for each situation.

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; size is 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 $($identifier$),$ 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 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. 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 of art need be represented in the database. Finally, another gallery is

described by a gallery ID $($identifier$),$ name, and city.