SQL

Question 1

What is referential integrity?

Answer 1

Referential integrity requires that, whenever a foreign key value is used it must be referenced a valid existing primary key in the parent table

Question 2

What is Entity integrity?

Answer 2

Entity integrity ensures that there are no duplicate records within the table and that the field that identifies each record within the table is unique and never null