Question: Use the database shown in Figure P 3 . 1 7 to answer Problems 1 7 , 1 8 , 1 9 , and 2
Use the database shown in Figure P to answer Problems and
For each table, identify the primary key and the foreign keys If a table does not have a foreign key, write None.
Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA Not Applicable if the table does not have a foreign key.
Create the ERD for this database. Please show the relationship types and the names of the relationships.
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
