Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is ...

For National 5 Computing Science, revise the use of primary and foreign keys and the difference between flat file and relational databases.

For example, a library database might be made up of three tables - books, customers and lending. Foreign keys could be introduced to link the lending table to the books table and customers table.