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 54 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
Great answer, keep it coming :)

mochi09

  • Member
  • Posts: 335
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Constraint-Induced Movement Therapy Constraint-Induced Movement Therapy
In countries where water can be contaminated, breastfeeding is an important option for the health of ... In countries where water can be contaminated, breastfeeding is an important option for the health of ...
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.
Control of lipolysis in adipose cells by a cAMP-mediated cascade system Control of lipolysis in adipose cells by a cAMP-mediated cascade system
The 1980 Mount Saint Helens eruption obliterated the community at the base of this Cascade volcano. The 1980 Mount Saint Helens eruption obliterated the community at the base of this Cascade volcano.
Video: Energy sources - types

For a complete list of videos, visit our video library