« previous next »

Author Question: Briefly explain first, second, and third normal forms. What will be an ideal ... (Read 88 times)

sjones

  • Hero Member
  • *****
  • Posts: 520
on: Jul 7, 2018
Briefly explain first, second, and third normal forms.
 
  What will be an ideal response?

Question 2

Describe and give an example of constraints.
 
  What will be an ideal response?


wergv

  • Sr. Member
  • ****
  • Posts: 365
Reply #1 on: Jul 7, 2018
Answer to Question 1

A table is in the first normal form (1NF) if it contains no repeating groups. It is in the second normal form (2NF) if it is in the first normal form and every non-key attribute is fully dependent on the entire primary key. Finally, a table is in the third normal form (3NF) if it is in the second normal form and no non-key attribute is dependent on another non-key attribute.

Answer to Question 2

Constraints are rules that apply to associations: generalization, a patient can be issued many hospital cards but only one card can be valid at any given time.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Parkinson's disease is both chronic and progressive. This means that it persists over a long period of time and that its symptoms grow worse over time.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

Cutaneous mucormycosis is a rare fungal infection that has been fatal in at least 29% of cases, and in as many as 83% of cases, depending on the patient's health prior to infection. It has occurred often after natural disasters such as tornados, and early treatment is essential.

A comparison between chromosomes found in a normal human cell and a cancer cell from the same person A comparison between chromosomes found in a normal human cell and a cancer cell from the same person
Retinopathy. Illustration of a normal retina (left) and a diseased retina (right). The diseased reti Retinopathy. Illustration of a normal retina (left) and a diseased retina (right). The diseased reti
Hematocrits, left to right: normal, anemia, polycythemia. Hematocrits, left to right: normal, anemia, polycythemia.
Distribution and Forms of Precipitation: Sleet Distribution and Forms of Precipitation: Sleet
Examples of Primary (Congenital) Forms of Immunodeficiency Examples of Primary (Congenital) Forms of Immunodeficiency
Distribution of dystrophin in muscle cells. (a) In normal muscle cells, all the dystrophin is locate Distribution of dystrophin in muscle cells. (a) In normal muscle cells, all the dystrophin is locate
Video: Four Giant Convection Cells oF Earth

For a complete list of videos, visit our video library