Author Question: In the normalization process, if you find that every determinant in a relation is a candidate key ... (Read 20 times)

JMatthes

  • Hero Member
  • *****
  • Posts: 578
In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that:
 
  A) the relation is well formed.
  B) the relation needs to be broken into two or more new relations.
  C) surrogate keys in the relation may not be correctly linked to other relations.
  D) the relation needs to have foreign keys added in order to be correctly linked to other relations.
  E) referential integrity constraints concerning the relation need to be established.

Question 2

The SQL keyword ________ can be used with SELECT statements retrieving view instances to sort the results of the SELECT.
 
  Fill in the blank(s) with correct word



Jane

  • Sr. Member
  • ****
  • Posts: 309
Answer to Question 1

A

Answer to Question 2

ORDER BY



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

For a complete list of videos, visit our video library