Explain the implications of enforcing referential integrity for Insert, Update and Delete statements
What will be an ideal response?
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.
You might also like to view...
The income summary account for a corporation is closed to Retained Earnings
Indicate whether the statement is true or false
A responsibility center in which the authority over and responsibility for costs and revenues is vested in the department manager is termed a profit center
Indicate whether the statement is true or false
In which type of society do subordinates and supervisors consider themselves existentially equal?
a. individualistic societies *b. small power distance societies c. large power distance societies d. feminism societies
Because the Consumer Product Safety Commission has no power to force a product off the market, safety is not a very important consideration in product design.
Answer the following statement true (T) or false (F)