Author Question: Explain briefly each of the first three levels of normalization. What will be an ideal ... (Read 81 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?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Acute bronchitis is an inflammation of the breathing tubes (bronchi), which causes increased mucus production and other changes. It is usually caused by bacteria or viruses, can be serious in people who have pulmonary or cardiac diseases, and can lead to pneumonia.

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

For a complete list of videos, visit our video library