« previous next »

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

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Four main models that describe the relationship between ecosystem function and biodiversity. Four main models that describe the relationship between ecosystem function and biodiversity.
Critical thinking and implementing care Critical thinking and implementing care
Control of lipolysis in adipose cells by a cAMP-mediated cascade system Control of lipolysis in adipose cells by a cAMP-mediated cascade system
Essentials of Paramedic Care Update Essentials of Paramedic Care Update
The Steps in the Coagulation Cascade The Steps in the Coagulation Cascade
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: Carbohydrate digestion - mouth and stomach & pancreas and small intestine

For a complete list of videos, visit our video library