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 37 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
:D TYSM

bimper21

  • Member
  • Posts: 309
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

The strongest synthetic topical retinoid drug available, tazarotene, is used to treat sun-damaged skin, acne, and psoriasis.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

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 freshly applied autograft. Note that the donor skin has been perforated so that it can be stretche A freshly applied autograft. Note that the donor skin has been perforated so that it can be stretche
What are examples of ideal forms? What are examples of ideal forms?
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 ...
Passenger Space Oddity (David Bowie Cover) Passenger Space Oddity (David Bowie Cover)
Marriages and Families: Changes, Choices, and Constraints, 9th Edition Marriages and Families: Changes, Choices, and Constraints, 9th Edition
Video: Types of Transport - Uniport, Antiport and Symport (Glucose and Na+K+ Transporters)

For a complete list of videos, visit our video library