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 70 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
:D TYSM


sarah_brady415

  • Member
  • Posts: 328
Reply 3 on: Yesterday
Gracias!

 

Did you know?

When blood is exposed to air, it clots. Heparin allows the blood to come in direct contact with air without clotting.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Historic treatments for rheumatoid arthritis have included gold salts, acupuncture, a diet consisting of apples or rhubarb, nutmeg, nettles, bee venom, bracelets made of copper, prayer, rest, tooth extractions, fasting, honey, vitamins, insulin, snow collected on Christmas, magnets, and electric convulsion therapy.

For a complete list of videos, visit our video library