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

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

About one in five American adults and teenagers have had a genital herpes infection—and most of them don't know it. People with genital herpes have at least twice the risk of becoming infected with HIV if exposed to it than those people who do not have genital herpes.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

A recent study has found that following a diet rich in berries may slow down the aging process of the brain. This diet apparently helps to keep dopamine levels much higher than are seen in normal individuals who do not eat berries as a regular part of their diet as they enter their later years.

For a complete list of videos, visit our video library