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

xiaomengxian

  • Member
  • Posts: 311
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

The lipid bilayer is made of phospholipids. They are arranged in a double layer because one of their ends is attracted to water while the other is repelled by water.

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 typical oil pump mounted in the front cover of the engine that is driven by the crankshaft. A typical oil pump mounted in the front cover of the engine that is driven by the crankshaft.
Reinstall the valve cover being careful to not pinch a wire or vacuum hose between the cover and ... Reinstall the valve cover being careful to not pinch a wire or vacuum hose between the cover and ...
A PCV valve shown in a cutaway valve cover showing the baffles that prevent liquid oil from being ... A PCV valve shown in a cutaway valve cover showing the baffles that prevent liquid oil from being ...
Cover the breasts with a towel before undraping to expose the abdomen. Cover the breasts with a towel before undraping to expose the abdomen.
HYLLS - Linger (The Cranberries Cover) HYLLS - Linger (The Cranberries Cover)
Video: Helper T cell receptors, activation, proliferation, differentiation & action

For a complete list of videos, visit our video library