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 68 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
Wow, this really help

cassie_ragen

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

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 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
Major steps in coagulation cascade Major steps in coagulation cascade
reaction and option reaction and option
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: Audiology

For a complete list of videos, visit our video library