« previous next »

Author Question: Describe the update cascade option (for implementing a referential integrity constraint). What ... (Read 84 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?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Constraint-Induced Movement Therapy Constraint-Induced Movement Therapy
Cascade of regulated splicing that controls sex determination in Drosophila embr Cascade of regulated splicing that controls sex determination in Drosophila embr
The coagulation cascade. Both the intrinsic pathway and extrinsic pathway lead to a common pathway ... The coagulation cascade. Both the intrinsic pathway and extrinsic pathway lead to a common pathway ...
The regulatory cascade controlling glycogen breakdown The regulatory cascade controlling glycogen breakdown
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
Alpine tundra. Low-growing, hardy plants at a high altitude in Washington’s Cascade range. Alpine tundra. Low-growing, hardy plants at a high altitude in Washington’s Cascade range.
Video: Bipolar Disorder

For a complete list of videos, visit our video library