Question: 3. Conceptual Data Modeling - 50 points ( 25 points each) Create a data model (ERD) based on the following business rules. You must -

3. Conceptual Data Modeling - 50 points ( 25

3. Conceptual Data Modeling - 50 points ( 25 points each) Create a data model (ERD) based on the following business rules. You must - Identify all of the main entities. - Identify all of the relations and connectivities. - Identify PK and FK - Identify the type of participation optionality, existence dependency and relationship strength in all the relationships. - Resolve the many to many relationships using the associative entities. You must use Lucidchart to draw the ERD (and then copy and paste your complete diagram). 3-1 ABC Gallery keeps information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph), and its price must be stored. Pieces of artwork are also classified into groups of various kinds, for example, portraits, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, galleries keep information about customers. For each customer, galleries keep that person's unique name, address, total amount of dollars spent in the gallery (very important!), and the artists and groups of art that the customer tends to like. Other customers could like the same artists and groups as well

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 General Management Questions!