(See related pages)
This chapter describes normalization, a technique to eliminate unwanted redundancy in relational tables. After this chapter, the student should have acquired the following knowledge and skills:
|
|
|
Identify modification anomalies in tables with excessive redundancies. |
|
|
|
Define functional dependencies among columns of a table. |
|
|
|
Normalize tables by detecting violations of normal forms and applying normalization rules. |
|
|
|
Analyze M-way relationships using the concept of independence. |
|
|
|
Appreciate the usefulness and limitations of normalization. |