Author Question: For the M-O (parent mandatory, child optional) case, what action(s) should be taken to ensure ... (Read 70 times)

JGIBBSON

  • Hero Member
  • *****
  • Posts: 538
For the M-O (parent mandatory, child optional) case, what action(s) should be taken to ensure minimum cardinality is maintained?
 
  A) Define referential integrity constraint from child to parent
  B) Make foreign key NOT NULL
  C) Will require trigger or other application code
  D) Both A and B are correct

Question 2

The data model produced by reverse engineering is a(n) ________.
 
  A) conceptual schema
  B) internal schema
  C) dependency graph
  D) table-relationship diagram



Jossy

  • Sr. Member
  • ****
  • Posts: 336
Answer to Question 1

D

Answer to Question 2

D



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

For a complete list of videos, visit our video library