« previous next »

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

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

The average office desk has 400 times more bacteria on it than a toilet.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Deviation of Normal Posture Deviation of Normal Posture
Alternative forms of surgeries involving the uterus, ovaries, and fallopian tubes. The solid lines i Alternative forms of surgeries involving the uterus, ovaries, and fallopian tubes. The solid lines i
How Coal Forms How Coal Forms
The various forms of spina bifida The various forms of spina bifida
Distribution and Forms of Precipitation: Snow Distribution and Forms of Precipitation: Snow
Normal electrocardiogram tracing Normal electrocardiogram tracing
Video: Alternative Energy Sources

For a complete list of videos, visit our video library