Question: Q 3 ) From the ER Diagram given below, answer the following questions. a ) List all the weak entity type ( s ) and
Q From the ER Diagram given below, answer the following questions.
a List all the weak entity types and all of their partial keys respectively. points
b List all the relationship attributes. 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. 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. points
e Assume that a customer can visit at most restaurant branches. Also, a restaurant
branch can have at most customers that can visit at a time. How does this show up
on the minmax constraints? points
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
