Menu
info@onlinenursinghomework.com
Cell: +1 (714) 584-4466

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

Don't use plagiarized sources. Get Your Custom Essay on
I am trying to understand entity integrity and referential integrity. Can you please look and see if I am on the right track?
Just from $9/Page or 300 words
Order Now

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.

Looking for a similar assignment? Get help from our nursing qualified experts!

Order Now

Open chat
Get help
You can now contact our live agent via whatsapp! ping +1 (714)-584-4466.
You will get plagiarism free custom written paper