« previous next »

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

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Your heart beats over 36 million times a year.

The logistic growth model does not describe all populations. The logistic growth model does not describe all populations.
A Developmental Cascade A Developmental Cascade
The cascade of events by which the stroke-induced release of glutamate kills neurons. The cascade of events by which the stroke-induced release of glutamate kills neurons.
How to describe transformations of a sinusoidal function (y=a*sin⁡b(x−c)+d) How to describe transformations of a sinusoidal function (y=a*sin⁡b(x−c)+d)
Cascade with fries Cascade with fries
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
Video: What is an ecosystem?

For a complete list of videos, visit our video library