# Database: Design: Normalization

The process of eliminating repeating fields and minimizing redundancy in relational database tables is called normalization. This process basically replaces data which occurs in more than one place with a keys that point to the one copy of the data.

## Normalized Databases have many tables

The more normalized a database is, the more tables there will be, and the more keys will be used to access data rather than having the data repeated.

## Several levels of normalization

In determining how normalized a database is, a series of conditions are imposed. [TO BE COMPLETED]

## Third Normal Form is usually considered adequate

[TO BE COMPLETED]

## There is usually a tradeoff between normalization and efficiency

[TO BE COMPLETED]

## Example - Student state

[TO BE COMPLETED]

## Example - Student GPA

[TO BE COMPLETED]