Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 - a - ) What are the referential integrity constraints in this model? Write them in the form of FK - - - >
a What are the referential integrity constraints in this model? Write them in the form of FKPK
Assume that the value of MGR in the last row is NULL.
Hint: A PK may consist of more than one attribute.
b Transform this relational database model to its equivalent ER model.
Hint: Notice which tables transform to entities and which tables to relationships. Do not forget to
specify the cardinality constraints inmaxmin notations.
Step 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