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 41 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
Gracias!

JCABRERA33

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

« previous next »
 

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

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.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

A phosphorylation cascade. A phosphorylation 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 Steps in the Coagulation Cascade The Steps in the 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.
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: Glycolysis - and oxygen

For a complete list of videos, visit our video library