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 27 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!

dawsa925

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

« previous next »
 

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

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?

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?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Eastern skunk cabbage, an endothermic plant, can melt its way up through spring snow cover Eastern skunk cabbage, an endothermic plant, can melt its way up through spring snow cover
This cover of Life (1925) offered a stereotypical rendering of the new generation: a young couple .. This cover of Life (1925) offered a stereotypical rendering of the new generation: a young couple ..
This spark plug boot on an overhead camshaft engine has been arcing to the valve cover causing a ... This spark plug boot on an overhead camshaft engine has been arcing to the valve cover causing a ...
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 ...
Apply the substance to the arm with long, smooth strokes, then cover the arm and abdomen with the ... Apply the substance to the arm with long, smooth strokes, then cover the arm and abdomen with the ...
Passenger Space Oddity (David Bowie Cover) Passenger Space Oddity (David Bowie Cover)
Video: Definitions of stroke volume, preload definition & Factors influencing stroke volume

For a complete list of videos, visit our video library