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.
Hi there! Click one of our representatives below and we will get back to you as soon as possible.