« previous next »

Author Question: Briefly explain first, second, and third normal forms. What will be an ideal ... (Read 76 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 human body produces and destroys 15 million blood cells every second.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Normal development of posture and spinal curves. (A) Toddler: Protruding abdomen; lumbar lordosis. ( Normal development of posture and spinal curves. (A) Toddler: Protruding abdomen; lumbar lordosis. (
EEG recordings showing the differences between normal, absence seizure, and generalized tonic–clonic EEG recordings showing the differences between normal, absence seizure, and generalized tonic–clonic
Security Tips for Accepting Various Forms of Payment Security Tips for Accepting Various Forms of Payment
Three types of “end feel” in normal joints. Three types of “end feel” in normal joints.
Normal and thermal inversion air masses interaction Normal and thermal inversion air masses interaction
Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA ... Explain the assumptions that must be satisfied in order to validly use the one-way ANOVA ...
Video: Eczema

For a complete list of videos, visit our video library