Question: what is referential integrity and why is it important?
Answer: Referential integrity is important, because it keeps you from introducing errors into your database. Suppose you have an Order Parts table like the following. Part number and order number, each foreign keys in this relation, also form the composite primary key. ... Such a situation shows a loss of referential integrity.