Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
Answer to relevant QuestionsDo 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.Identify the TRUCK table’s candidate key(s).Modify the ERD you created in Problem 25 to eliminate the problems created by the use of synonyms. Given the business rule “an employee may have many degrees,” discuss its effect on attributes, entities, and relationships. Write the ten cardinalities that are appropriate for this ERD.
Post your question