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

dbose

  • Hero Member
  • *****
  • Posts: 597
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
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
 

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

For a complete list of videos, visit our video library