« previous next »

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

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

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

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Summation of Heart Sounds, Normal Physiological Split of S1 Summation of Heart Sounds, Normal Physiological Split of S1
Normal Distribution of IQ Scores Normal Distribution of IQ Scores
The normal and constricted airway. The normal and constricted airway.
Distribution and Forms of Precipitation: Rain Distribution and Forms of Precipitation: Rain
Cradle the head briefly in both hands to end this section. Hold for a few seconds until you can feel ... Cradle the head briefly in both hands to end this section. Hold for a few seconds until you can feel ...
Normal physiologic mechanisms of the body that restore homeostasis to the balance of serum calcium Normal physiologic mechanisms of the body that restore homeostasis to the balance of serum calcium
Video: Muscular System Animation

For a complete list of videos, visit our video library