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]