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

Mochi

  • Member
  • Posts: 300
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Dred Scott and his wife and children are featured on the cover of Frank Leslie’s Illustrated Newspap Dred Scott and his wife and children are featured on the cover of Frank Leslie’s Illustrated Newspap
Herbert Bayer, Cover for Bauhaus 1. Herbert Bayer, Cover for Bauhaus 1.
Purse cover, from the Sutton Hoo burial ship. Purse cover, from the Sutton Hoo burial ship.
A corroded electronic throttle control assembly shown with the cover removed. A corroded electronic throttle control assembly shown with the cover removed.
When the cover is removed from the top of the engine, a mouse or some other animal nest is ... When the cover is removed from the top of the engine, a mouse or some other animal nest is ...
The chart under the cover for the relay center indicates the location of the relay that controls ... The chart under the cover for the relay center indicates the location of the relay that controls ...
Video: Properties of water -structure of water and polarity (Ionized and polar compounds)

For a complete list of videos, visit our video library