Question: Problem 1 0 . For each table in the database, identify the primary key and the foreign key ( s ) . If a table
Problem For each table in the database, identify the primary key and the foreign keys If a table does not have a foreign key, write None. Chapter
Database name: ChBeneCo
Table name: EMPLOYEE
Table name: JOB
Table name: BENEFIT
Table name: PLAN
Problem For each table in the database, identify the primary key and the foreign keys
If a table does not have a foreign key, write None.
Problem Do the tables exhibit entity integrity? Answer yes or no and then explain your
answer.
Problem Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB,
and PLAN.
Problem Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
Problem Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
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
