This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint betweenCLIENT and ... (Read 25 times)

javeds

  • Hero Member
  • *****
  • Posts: 570
on: Jul 7, 2018
If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint betweenCLIENT and AGENT in the HAPPY INSURANCE database, what will be the outcome after auser tries to delete the last record (A4, James, 3, 90, 2010, A3 ) from AGENT?
 
  A) CLIENT will have 7 records
  AGENT will have 4 records
  B) CLIENT will have 6 records
  AGENT will have 3 records
  C) CLIENT will have 7 records
  AGENT will have 3 records
  D) CLIENT will have 6 records
  AGENT will have 4 records

Question 2

A dimensional model can contain more than one fact table.
 
  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

Swizqar

  • Sr. Member
  • ****
  • Posts: 357
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

TRUE


javeds

  • Member
  • Posts: 570
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

Liddy

  • Member
  • Posts: 342
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

The average adult has about 21 square feet of skin.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

A phosphorylation cascade. A phosphorylation cascade.
Constraint-Induced Movement Therapy Constraint-Induced Movement Therapy
Prolonged abuse leads to production of stress hormones that can lead to a cascade of effects ... Prolonged abuse leads to production of stress hormones that can lead to a cascade of effects ...
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 ...
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.
Video: Summation - defined, spatial, temporal & AP generation or not

For a complete list of videos, visit our video library