Question: For each table identify the primary key and the foreign
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.
Answer to relevant QuestionsDo the tables exhibit entity integrity? Answer yes or no and then explain your answer.Draw the ERD to show the relationships among EMPLOYEE, STORE, and REGION.Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.For each table, where possible, identify:a. The primary keyb. A superkeyc. A candidate keyd. The foreign key(s)e. A secondary keyCreate the table that would result from applying a DIFFERENCE relational operator of your result from problem 29 to your result from problem 30.
Post your question