Question: For each entity, please be sure to specify the primary key - if it does not exist, you must create the field. In addition, please
For each entity, please be sure to specify the primary keyif it does not exist, you must create
the field. In addition, please specify all attributes for the entity, as illustrated in the Customer
entity above.
For each relationship drawn on this diagram, be sure to specify: A the relationship type :
:many, many:many using hash marks and crow's foot notation; B whether the relationship is
mandatory or optional using hash marks and circles; and C minimum and maximum
cardinalities using parentheses notation you may handwrite these in Also please be sure to
specify all constraints on the supertypesubtype relationships ie whether they are
overlapping or disjoint and whether they are partially or totally complete
For Problem you may handwrite your cardinalities in Please ensure that your ER Diagram
breaks correctly and is readable.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
