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 88 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
Wow, this really help

rachel

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

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
(a) Mean duration (days) and (b) average maximum depth (mm) of snow cover throughout northern latitu (a) Mean duration (days) and (b) average maximum depth (mm) of snow cover throughout northern latitu
Disposable plastic cover placed over probe Disposable plastic cover placed over probe
Edouardo Benito, Cover of Vogue. Edouardo Benito, Cover of Vogue.
Assist recipient into side-lying position. Woman sits on edge of table holding drape to cover her ... Assist recipient into side-lying position. Woman sits on edge of table holding drape to cover her ...
Ocean cover most of Earth’s surface Ocean cover most of Earth’s surface
Video: What are Strong & Weak Acids and How they're different?

For a complete list of videos, visit our video library