« previous next »

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

tiara099

  • Hero Member
  • *****
  • Posts: 588
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

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?

There are 20 feet of blood vessels in each square inch of human skin.

Levels of biological organization in a plant. Levels of biological organization in a plant.
Diabetes mellitus. The metabolic disease diabetes mellitus, with symptoms of polydipsia, polyuria, a Diabetes mellitus. The metabolic disease diabetes mellitus, with symptoms of polydipsia, polyuria, a
Sunlight on Mars is dimmer than on Earth. This photo of a Martian sunset was imaged by Mars Pathfind Sunlight on Mars is dimmer than on Earth. This photo of a Martian sunset was imaged by Mars Pathfind
This chart illustrates the four quadrants in which we can place the relationships between the state This chart illustrates the four quadrants in which we can place the relationships between the state
Levels of Processing Affects Long-Term but not Short-Term Memory Levels of Processing Affects Long-Term but not Short-Term Memory
Coastal sensitivity to rising sea levels Coastal sensitivity to rising sea levels
Video: Parkinson's Disease

For a complete list of videos, visit our video library