Question: Q 3 ) From the ER Diagram given below, answer the following questions. a ) List all the weak entity type ( s ) and

Q3) From the ER Diagram given below, answer the following questions.
a) List all the weak entity type(s) and all of their partial key(s) respectively. [2 points]
b) List all the relationship attributes. [2 points]
C) For each relationship attribute, state whether they can be made an attribute of an entity
instead. Explain why or why not for each case. [6 points]
d) List the names of all relationship types, and specify the ( min,max ) constraint on each
participation of an entity type in a relationship type. [10 points]
e) Assume that a customer can visit at most 5 restaurant branches. Also, a restaurant
branch can have at most 200 customers that can visit at a time. How does this show up
on the min-max constraints? [5 points]
Q 3 ) From the ER Diagram given below, answer 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!