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

parshano

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

« previous next »
 

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

There are more bacteria in your mouth than there are people in the world.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Herbert Bayer, Cover for Bauhaus 1. Herbert Bayer, Cover for Bauhaus 1.
Purse cover, from the Sutton Hoo burial ship. Purse cover, from the Sutton Hoo burial ship.
With all vacuum lines and the intake tube removed, the valve cover can be removed after removing all ... With all vacuum lines and the intake tube removed, the valve cover can be removed after removing all ...
Mobilize the rib cage. Redrape to cover the chest, and stand to one side of the table. Place your ... Mobilize the rib cage. Redrape to cover the chest, and stand to one side of the table. Place your ...
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 ...
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
Video: A Human Karyotype Preparation Animation

For a complete list of videos, visit our video library