This topic contains a solution. Click here to go to the answer

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

Tirant22

  • Hero Member
  • *****
  • Posts: 532
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
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
:D TYSM


atrochim

  • Member
  • Posts: 331
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

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

For a complete list of videos, visit our video library