This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain First Normal Form and provide examples. What will be an ideal ... (Read 358 times)

Tirant22

  • Hero Member
  • *****
  • Posts: 532
on: Jul 7, 2018
Explain First Normal Form and provide examples.
 
  What will be an ideal response?

Question 2

The symbol X(8 ) represents:
 
  A) eight digits.
  B) eight alphanumeric characters.
  C) a data structure or element that repeats eight times.
  D) an element that is found within eight data structures.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

soda0602

  • Sr. Member
  • ****
  • Posts: 313
Reply #1 on: Jul 7, 2018
Answer to Question 1

The First Normal Form removes repeating groups and arrays. If a column in a Customer table, for example, contained multiple phone numbers, that would be an array. If it contained multiple columns named something like Phone1, Phone2, etc., that would be a repeating group. To make the table conform to First Normal Form the phone numbers should be placed in another entity with a relation to the Customer entity.

Answer to Question 2

B


Tirant22

  • Member
  • Posts: 532
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

ultraflyy23

  • Member
  • Posts: 312
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

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?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

How the study of genomes and proteomes can provide us with connections to different biological level How the study of genomes and proteomes can provide us with connections to different biological level
Examples of fermentation Examples of fermentation
Summation of Heart Sounds, Normal Physiological Split of S1 Summation of Heart Sounds, Normal Physiological Split of S1
Skilled nursing facilities provide care for patients requiring longer stays than hospitals allow. Skilled nursing facilities provide care for patients requiring longer stays than hospitals allow.
Examples of Disease-Causes Bacteria Examples of Disease-Causes Bacteria
form unit form unit
Video: Inflammation Animation

For a complete list of videos, visit our video library