« previous next »

Author Question: Briefly explain first, second, and third normal forms. What will be an ideal ... (Read 98 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?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

The largest baby ever born weighed more than 23 pounds but died just 11 hours after his birth in 1879. The largest surviving baby was born in October 2009 in Sumatra, Indonesia, and weighed an astounding 19.2 pounds at birth.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Chest Configurations, Normal Adult, Barrel Chest, Pectus Carinatum, Pectus Excavatum Chest Configurations, Normal Adult, Barrel Chest, Pectus Carinatum, Pectus Excavatum
Electrocardiography. (a) Electrodes are placed on the patient’s chest to record the electrical event Electrocardiography. (a) Electrodes are placed on the patient’s chest to record the electrical event
An oscillating needle 1 or 2 inches Hg below normal could indicate an incorrect air–fuel mixture ... An oscillating needle 1 or 2 inches Hg below normal could indicate an incorrect air–fuel mixture ...
Normal tympanic membrane with cone of light and process of malleus Normal tympanic membrane with cone of light and process of malleus
Normal (A) and Abnormal (B) Balance between Dopamine and Acetylcholine Normal (A) and Abnormal (B) Balance between Dopamine and Acetylcholine
Section of a normal brain (left) and an HD brain (right). The HD brain shows extensive damage to the Section of a normal brain (left) and an HD brain (right). The HD brain shows extensive damage to the
Video: Red Blood Cells - Erythropoietin (EPO)

For a complete list of videos, visit our video library