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 key-if 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 (1:1,
1: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 hand-write these in). Also please be sure to
specify all constraints on the supertype/subtype relationships (i.e., whether they are
overlapping or disjoint and whether they are partially or totally complete).
For Problem 3, you may hand-write your cardinalities in. Please ensure that your ER Diagram
breaks correctly and is readable.
For each entity, please be sure to specify the

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!