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 136 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?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

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.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

For a complete list of videos, visit our video library