Practice Problem $2$:

Using the business rules provided below, complete the following:

List all the entities and $2-3$ attributes.

Identify each relationship type among the entities $(1$:$1,1$:M$,$ M:N$).$

Draw an Entity$-$Relationship diagram using the Crow$$s Foot notation in Lucidchart or MS Visio, that includes all entities, attributes, and relationships identified above.

Business rules are defined as follows:

A painter can paint many paintings. Each painting is painted by only one painter.

A gallery can exhibit many paintings. Each painting is exhibited in only one gallery.

A painter can exhibit paintings at more than one gallery at a time.