This topic contains a solution. Click here to go to the answer

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

rachel9

  • Sr. Member
  • ****
  • Posts: 495
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

trampas

  • Sr. Member
  • ****
  • Posts: 320
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




rachel9

  • Member
  • Posts: 495
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


shewald78

  • Member
  • Posts: 340
Reply 3 on: Yesterday
Excellent

 

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

For a complete list of videos, visit our video library