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 93 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
YES! Correct, THANKS for helping me on my review

Dnite

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

« previous next »
 

Did you know?

Common abbreviations that cause medication errors include U (unit), mg (milligram), QD (every day), SC (subcutaneous), TIW (three times per week), D/C (discharge or discontinue), HS (at bedtime or "hours of sleep"), cc (cubic centimeters), and AU (each ear).

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

There are immediate benefits of chiropractic adjustments that are visible via magnetic resonance imaging (MRI). It shows that spinal manipulation therapy is effective in decreasing pain and increasing the gaps between the vertebrae, reducing pressure that leads to pain.

Ground cover and colour such as shown here in (a) white sand Ground cover and colour such as shown here in (a) white sand
(a) Mean duration (days) and (b) average maximum depth (mm) of snow cover throughout northern latitu (a) Mean duration (days) and (b) average maximum depth (mm) of snow cover throughout northern latitu
Cover/Uncover Test Cover/Uncover Test
Edouardo Benito, Cover of Vogue. Edouardo Benito, Cover of Vogue.
A visual inspection indicated that this pump cover was worn. A visual inspection indicated that this pump cover was worn.
Use flat fingers to apply L stroke in several locations to cover the entire forehead, from midline ... Use flat fingers to apply L stroke in several locations to cover the entire forehead, from midline ...
Video: Phases of an Action Potential - Resting Potential, Threshold, Rising, Falling, & Recovery Phases

For a complete list of videos, visit our video library