Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help making an ER diagram given the following information: Suppose your customer hire your company to develop a database and an application about

I need help making an ER diagram given the following information:

Suppose your customer hire your company to develop a database and an application about art pieces and museums that maintain them. Each museum has a name (unique), a postal address, and a phone number. A museum may purchase art pieces from galleries. A gallery must have at least one art piece, but typically it has several art pieces. Each art piece may still be with the artist who made it or may already be maintained by a gallery. The database keeps information about artists, their names (which are unique), birthplaces, and style of art. For each art piece, the artists first and last names (unique), the year it was made, its unique title, its type of art (e.g., painting, lithograph, sculpture, photograph) must be kept in the database. An artist may not complete any art piece yet, or he/she already produced some art pieces. An art piece must be made by only one artist. An art piece is classified into groups, for example, portraits, still life, works by Picasso, or works of the 19th century. A given art piece may belong to more than one group. Each group is identified by a unique name (like those just given) that describes the group. The purchasing information about which museum purchases which art piece from which gallery at what price on what date must be maintained. Draw an ER diagram that captures all the above requirements. You may specify other constraints and represent them in the diagram as long as they do not contradict with the given requirements. Make sure that you do not miss any key attribute for any entity set.

Note:

An entity set is symbolized with a rectangle. A relationship set is symbolized with a diamond shape. Attributes are symbolized with a circle/ oval. Key attributes are underlined. Total participation is symbolized with a bold line. Key constraints are symbolized with an arrow.

Attached is an example ER diagram

image text in transcribed

illustrates the constraint. ir no, provide the reasons why it is not possible in the E diagram. phone no. manage Employees phone no. specialty Hourly_Workers FullTime_WorkersManagers alary salary Workers and Qaitypurchase ake Managers cover Employews fulitime workers, and Menagers are not Products bought from Suppliers Of Ingredients

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Geodatabases In ArcGIS Pro

Authors: David W. Allen

1st Edition

1589484452, 978-1589484450

More Books

Students also viewed these Databases questions

Question

Describe Table Structures in RDMSs.

Answered: 1 week ago