Normalization of Database Tables: Lesson 7

Question 1

What is normalization?

Answer 1

Normalization is the evaluating and correcting of data structures to reduce data inconsistencies thereby reducing the likelihood of data anomalies.

Question 2

What is denormalization?

Answer 2

Produces lower normal form

Question 3

What is functional dependence?

Answer 3

Attribute A determines attribute B

Question 4

What are the 2 types of functional dependencies?

Answer 4

Partial and transitive

Question 5

What is partial dependence?

Answer 5

It is functional dependence in which the determinant is only part of the primary key

Question 6

What is transitive dependence?

Answer 6

An attribute functionally depends on a non-key attribute

Question 7

What are the 3 steps of doing the first normal form?

Answer 7

1. eliminate the repeating groups
2. identify primary keys
3. identify all dependencies