Author Question: In the normalization process, if you find that every determinant in a relation is a candidate key ... (Read 66 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?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

The National Institutes of Health have supported research into acupuncture. This has shown that acupuncture significantly reduced pain associated with osteoarthritis of the knee, when used as a complement to conventional therapies.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

For a complete list of videos, visit our video library