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.
Answer to relevant QuestionsCreate the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.For each table, identify a superkey and a secondary key.Draw the relational diagram for the design you revised in problem 27. (After you have had a chance to revise the design, your instructor will show you the results of the design change, using a copy of the revised database ...Suppose you are working within the framework of the conceptual model in Figure Q4.5.a. Write the business rules that are reflected in it.b. Identify all of the cardinalities.Write the business rules reflected in this ERD.
Post your question