This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What are MUST NOT and MUST COVER constraints? What will be an ideal ... (Read 79 times)

evelyn o bentley

  • Hero Member
  • *****
  • Posts: 564
on: Jul 7, 2018
What are MUST NOT and MUST COVER constraints?
 
  What will be an ideal response?

Question 2

The SQL DELETE TABLE statement can be used to remove unneeded tables after the normalized tables are created and populated.
 
  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

strudel15

  • Sr. Member
  • ****
  • Posts: 324
Reply #1 on: Jul 7, 2018
Answer to Question 1

Both MUST NOT and MUST COVER constraints occur when working with three tables in a ternary relationship. When a MUST NOT constraint occurs, it indicates that one binary relationship of two of the tables contains combinations of values that are not allowed to occur in the ternary relationship. When a MUST COVER constraint occurs, it indicates that one binary relationship of two of the tables contains combinations of values that must all appear in the ternary relationship.

Answer to Question 2

FALSE


evelyn o bentley

  • Member
  • Posts: 564
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it

vickybb89

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

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?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Cover/Uncover Test Cover/Uncover Test
The vulva, sagittal section illustrating how the labia majora and labia minora cover and protect the The vulva, sagittal section illustrating how the labia majora and labia minora cover and protect the
Disposable plastic cover placed over probe Disposable plastic cover placed over probe
Purse cover, from the Sutton Hoo burial ship. Purse cover, from the Sutton Hoo burial ship.
What looks like an oil pan gasket leak can be a rocker cover gasket leak. Always look up and look ... What looks like an oil pan gasket leak can be a rocker cover gasket leak. Always look up and look ...
With all vacuum lines and the intake tube removed, the valve cover can be removed after removing all ... With all vacuum lines and the intake tube removed, the valve cover can be removed after removing all ...
Video: How do the different types of chromatography work? (No Audio)

For a complete list of videos, visit our video library