O'Reilly logo

Concepts of Database Management System by Shefali Naik

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required