« previous next »

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

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

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?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

The burning of fossil fuels has greatly increased atmospheric CO2 levels and temperatures. The burning of fossil fuels has greatly increased atmospheric CO2 levels and temperatures.
Spinal cord—levels of injury; A, areas of sensory function (dermatomes); B, areas of motor function. Spinal cord—levels of injury; A, areas of sensory function (dermatomes); B, areas of motor function.
Four levels of protein hierarchy Four levels of protein hierarchy
Nursing Interventions for Different Levels of Anxiety Nursing Interventions for Different Levels of Anxiety
The four levels of protein structure The four levels of protein structure
An overview of the levels of organization in nature An overview of the levels of organization in nature
Video: Factors that affect conduction rates (myelination, axon diameter & temperature)

For a complete list of videos, visit our video library