Module 10: Creating and Refining Tables During the Design Phase.

 

Creating and Refining Tables During the Design Phase.

1. What does it mean by insert check based on referential integrity?

A record can’t be added to a child table unless the parent record exists in the parent table.

2. What does it mean by update check based on referential integrity?

Parent and child table records can’t have their linking key field values changed, unless both are changed simultaneously.

3. What does it mean by delete check based on referential integrity?

A parent table record can’t be deleted when a child table record exists, unless all related child table records are deleted first.

4. What does it mean by delete cascade check based on referential integrity?

A parent table record can be deleted if all child records are deleted first. This is known as a cascading delete.