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 67 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

T4T

  • Member
  • Posts: 348
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

Blood in the urine can be a sign of a kidney stone, glomerulonephritis, or other kidney problems.

Did you know?

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

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

A phosphorylation cascade. A phosphorylation cascade.
Major steps in the coagulation cascade Major steps in the coagulation cascade
Cascade of regulated splicing that controls sex determination in Drosophila embr Cascade of regulated splicing that controls sex determination in Drosophila embr
A Developmental Cascade A Developmental Cascade
Is it ethical to break the law to defend our personal integrity? Is it ethical to break the law to defend our personal integrity?
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: Effect of the environment on coat color in the Himalayan rabbit Animation

For a complete list of videos, visit our video library