« previous next »

Author Question: Describe the update cascade option (for implementing a referential integrity constraint). What ... (Read 89 times)

dbose

  • Hero Member
  • *****
  • Posts: 597
on: Jul 7, 2018
Describe the update cascade option (for implementing a referential integrity constraint).
 
  What will be an ideal response?

Question 2

Give a definition of 1NF.
 
  What will be an ideal response?


heinisk01

  • Sr. Member
  • ****
  • Posts: 329
Reply #1 on: Jul 7, 2018
Answer to Question 1

The update cascade option allows the primary key value of a record to be changed if its primary key value is referred to by a foreign key value. However, all the foreign key values that refer to the primary key being changed are also changed and set to the new value of the primary key.

Answer to Question 2

A table is in 1NF if each row is unique and no column in any row contains multiple values from the column's domain.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

A phosphorylation cascade. A phosphorylation cascade.
A Developmental Cascade A Developmental Cascade
Describe how fat is digested, absorbed, and transported in the body Describe how fat is digested, absorbed, and transported in the body
Major steps in coagulation cascade Major steps in coagulation cascade
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
The 1980 Mount Saint Helens eruption obliterated the community at the base of this Cascade volcano. The 1980 Mount Saint Helens eruption obliterated the community at the base of this Cascade volcano.
Video: Exercise and cardiac output

For a complete list of videos, visit our video library