Author Question: Explain briefly each of the first three levels of normalization. What will be an ideal ... (Read 71 times)

tiara099

  • Hero Member
  • *****
  • Posts: 588
Explain briefly each of the first three levels of normalization.
 
  What will be an ideal response?

Question 2

Data stores are used to store:
 
  A) all base elements and some derived elements.
  B) all derived elements and some base elements.
  C) all base and derived elements.
  D) only some base elements and some derived elements (the most critical ones in the system).



owenfalvey

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

The first level of normalization removes all repeating groups and arrays from entities, and makes sure that every column contains a single value all of the same type. Second Normal Form removes functional dependencies, which are subgroups or sub themes of attributes within an entity. Each subgroup should be made into a separate entity. The third level of normalization removes transient dependencies from entities. This ensures that all attributes describe the primary key of an entity and not some other attribute.

Answer to Question 2

A



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

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?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

For a complete list of videos, visit our video library