Answered You can hire a professional tutor to get the answer.
I am trying to understand entity integrity and referential integrity. Can you please look and see if I am on the right track?
I am trying to understand entity integrity and referential integrity. Can you please look and see if I am on the right track?
ENTITY INTEGRITY
Employee table ; Entity Integrity YES ; Each employee has a unique number for the primary key.
Store table ; Entity Integrity YES ; Each region is represented by a unique number as the primary key.
Region ; Entity Integrity YES ; Each region is represented by a unique number as the primary key.
REFERENTIAL INTEGRITY
Employee table ; Referential Integrity YES ; The table has a foreign key and the values in it reference valid information in another table.
Store table ; Referential Integrity YES ; The table has a foreign key and the values in it reference valid information in another table.
Region ; Referential Integrity N/A ; Region table does not have a foreign key.
