• Home
  • Blog
  • 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?

0 comments

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.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}