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 28 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

jamesnevil303

  • Member
  • Posts: 337
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

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?

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?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

The FDA recognizes 118 routes of administration.

In 2005 historian Angela Lakwete used this print as the cover of Inventing the C In 2005 historian Angela Lakwete used this print as the cover of Inventing the C
An example of a cover letter sent in response to a classified ad. An example of a cover letter sent in response to a classified ad.
After testing, be sure to reinstall the relay and the relay cover. After testing, be sure to reinstall the relay and the relay cover.
Apply deep effleurage to the thigh from knee to superior thigh. Cover anterior, medial, and lateral ... Apply deep effleurage to the thigh from knee to superior thigh. Cover anterior, medial, and lateral ...
Passenger Space Oddity (David Bowie Cover) Passenger Space Oddity (David Bowie Cover)
The Nature and Properties of Soils, 15th Edition Cover The Nature and Properties of Soils, 15th Edition Cover
Video: Oxygen transport - methods and oxyhemoglobin

For a complete list of videos, visit our video library