CHAPTER 5
Normalization
CHAPTER OBJECTIVES
- Understanding importance of normalization.
- Identifying dependencies from the given Table.
- Converting Tables into various normal forms.
- Evaluating Tables after normalization for correctness and lossless decomposition.
- Understanding some more dependencies.
- Learning with examples: how to normalize Tables.
5.1 INTRODUCTION
After drawing E-R diagram, the Tables should be designed. An E-R model is a conceptual (semantic) model which shows only entities, relationships and attributes. It does not show data types and constraints which should be put up on the attributes. Data types and constraints must be decided by studying actual values of the attributes. Moreover, we can decide input format, set of values ...
Get Concepts of Database Management System now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
