This topic contains a solution. Click here to go to the answer

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

jazziefee

  • Hero Member
  • *****
  • Posts: 505
Describe the delete cascade option (for implementing a referential integrity constraint).
 
  What will be an ideal response?

Question 2

The STATEWIDE HEALTH PRESCRIPTIONS database column PrescTimeOfDay provides the data for a dimension in the STATEWIDE HEALTH star schema.
 
  Indicate whether the statement is true or false



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

jointhecircus

  • Sr. Member
  • ****
  • Posts: 343
Answer to Question 1

The delete cascade option allows a record to be deleted if its primary key value is referred to by a foreign key value. However, all the records whose foreign key value refers to the primary key value of the record that is being deleted will also be deleted.

Answer to Question 2

FALSE





 

Did you know?

About 3.2 billion people, nearly half the world population, are at risk for malaria. In 2015, there are about 214 million malaria cases and an estimated 438,000 malaria deaths.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

For a complete list of videos, visit our video library