Question: Create an ERD diagram based on the below case. In this scenario, we're designing an ERD for an Art Gallery Management System, tasked with overseeing

Create an ERD diagram based on the below case.
In this scenario, we're designing an ERD for an Art Gallery Management System, tasked with overseeing various facets of gallery operations, including locations, galleries, drawings, and artist information.
Location represent the physical sites of galleries and include attributes such as LocationID, Address, City, State, Zip Code, and Country.
Gallery represents the individual galleries within each location where artworks are displayed. Each gallery has attributes like GalleryID, Name, Capacity, and Description.
Drawing represents the drawings or artworks displayed within the galleries. Each drawing has attributes such as DrawingID, ArtistID, Title, Size, Material, Date and Description.
Artist represents the artists who create the drawings or artworks. Each artist has attributes like ArtistID, Name, Birthdate, Email and Phone.
Additionally, each location can host multiple galleries, but each gallery is exclusive to one location. Similarly, galleries can exhibit multiple drawings, and each drawing may be displayed in several galleries. Finally, artists can produce multiple drawings, but each drawing is the creation of only one artist.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!