« previous next »

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

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

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?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

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.

Major steps in the coagulation cascade Major steps in the coagulation cascade
A Developmental Cascade A Developmental Cascade
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 ...
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)
reaction and option reaction and option
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
Video: EpiPen Animation (Part 1)

For a complete list of videos, visit our video library