« previous next »

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

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

The average older adult in the United States takes five prescription drugs per day. Half of these drugs contain a sedative. Alcohol should therefore be avoided by most senior citizens because of the dangerous interactions between alcohol and sedatives.

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Emphysema. (a) Illustration comparing normal lungs and emphysemic lungs. The inserts illustrate how Emphysema. (a) Illustration comparing normal lungs and emphysemic lungs. The inserts illustrate how
PET scan of a normal brain. PET scan of a normal brain.
Assume z is a standard normal random variable. What is the value of z if the area to the right ... Assume z is a standard normal random variable. What is the value of z if the area to the right ...
An endoscopic view of the colon of someone who carries the normal alleles for the APC gene An endoscopic view of the colon of someone who carries the normal alleles for the APC gene
Number of Mutations Associated with Specific Forms of Cancer Number of Mutations Associated with Specific Forms of Cancer
The traditional human karyotypes derived from a normal female and a normal male The traditional human karyotypes derived from a normal female and a normal male
Video: Pores and Ion Channels

For a complete list of videos, visit our video library