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

Tirant22 · **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.

soda0602 · **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