Author Question: Explain the implications of enforcing referential integrity for Insert, Update and Delete ... (Read 122 times)

rachel9 · **on:** Jul 7, 2018

Explain the implications of enforcing referential integrity for Insert, Update and Delete statements.

What will be an ideal response?

Question 2

A schema consists of ownership of database objects.

Indicate whether the statement is true or false

trampas · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Enforcing referential integrity has an effect on three common database actions. It forces a user to insert data in a certain order. There must be an existing value in the primary key table before related records can be entered in the foreign key table. It also effects updates. One cannot change a primary key that has related records in a child or foreign key table. One also cannot update a foreign key column in the child table except to change it to the value of an existing primary key in the primary key table. When it comes to deletes, one cannot delete a record from a primary key table until all the related records in the foreign key table have been deleted first.

Answer to Question 2

TRUE