Exercises

What is normalization?

What is the purpose of normalization?

Describe how normalization support database design.

What is a repeating group?

When is a table in $1NF?$

Describe the concept of functional dependency.

When is a table in $3$NF$?$

What is a partial dependency? With what normal for is it associated?

Explain the concept of transitive dependency.

Given the dependency diagram shown in below, answer items $($i$)-($iii$).$

$($i$)$ Identify and discuss each of the indicated dependencies.

$($ii$)$ Create a database whose tables are at least in $2NF,$ showing the dependency diagrams for each table.

$($iii$)$ Create a database whose tables are at least in $3NF,$ showing the dependency diagrams for each table.