Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the following database for Q10, Q13-15. Database name: Chos BeneCo Table name: EMPLOYEE Table name: BENEFIT Table name: JOB Table name: PLAN 10.
Refer to the following database for Q10, Q13-15. Database name: Chos BeneCo Table name: EMPLOYEE Table name: BENEFIT Table name: JOB Table name: PLAN 10. For each table in the database, soentily the primary key and the foredgn kess(s) If a table does not houe a foreign key. wree None in the space prorided, 13. Do the tables extibin entity integrity? Answer yes or no, and then explain your acrowet. 14. Do the tables exlibit yoforentlal integrik? Ansuer yes or no, and then explain your anguef. Whte Na (Not Applables) if the table does not have a foregga key. 15. Create the ERD to show the relationships among EMPLOYEE, BENETT, JOB, and PLAN
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