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 73 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!

ashely1112

  • Member
  • Posts: 347
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Since 1988, the CDC has reported a 99% reduction in bacterial meningitis caused by Haemophilus influenzae, due to the introduction of the vaccine against it.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

A phosphorylation cascade. A phosphorylation cascade.
Constraint-Induced Movement Therapy Constraint-Induced Movement Therapy
Prolonged abuse leads to production of stress hormones that can lead to a cascade of effects ... Prolonged abuse leads to production of stress hormones that can lead to a cascade of effects ...
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
Cascade with fries Cascade with fries
Video: What is Reverse Osmosis?

For a complete list of videos, visit our video library