Database concepts

Database design: logical models

Referential integrity

Question
Briefly describe what referential integrity means?

Show me

Referential integrity means that you cannot add a record to a relation (or table) unless a corresponding record already exists in a related table. For example, in our invoice database we cannot create a new invoice for a customer unless a record for that customer exists in the customer table.