Question
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
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 IngredientsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started