Week 5

Question 1

What is normalization?

Answer 1

Normalization is a technique for producing a set of suitable relations that the support the data requirements of an enterprise.

Question 2

What are some purposes of normalization?

Answer 2

The minimal number of attributes needed to support requirements of an enterprise.
Reduces file storage space thus minimizes costs

Question 3

What is functional dependency?

Answer 3

Functional dependency describes relationship between attributes.

Question 4

What is unnormalized form?

Answer 4

A table that contains one or more repeating groups.

Question 5

What is first normalized form (1NF)

Answer 5

A relation in which the intersection of each row and column contains one and only one value.

Question 6

What is second normalized form (2NF)?

Answer 6

A relation that is 1NF and every non-primary key attribute is fully functionally dependent on the primary key.

Question 7

What is third normal formal (3NF)?

Answer 7

A relation that is 1NF and 2NF and which no non-primary key attribute is transitively independent on the primary key