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

parshano

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

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?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

The trophic cascade hypothesis. The trophic cascade hypothesis.
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 regulatory cascade controlling glycogen breakdown The regulatory cascade controlling glycogen breakdown
Cascade with fries Cascade with fries
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.
Alpine tundra. Low-growing, hardy plants at a high altitude in Washington’s Cascade range. Alpine tundra. Low-growing, hardy plants at a high altitude in Washington’s Cascade range.
Video: Summary of glucose catabolism

For a complete list of videos, visit our video library