O'Reilly logo

Database Systems: Concepts, Design and Applications, 2nd Edition by Shio Kumar Singh

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

CHAPTER9

Functional Dependency and Decomposition

9.1 INTRODUCTION

As explained in the earlier chapters, the purpose of database design is to arrange the corporate data fields into an organised structure such that it generates set of relationships and stores information without unnecessary redundancy. In fact, the redundancy and database consistency are the most important logical criteria in database design. A bad database design may result into repetitive data and information and an inability to represent desired information. It is, therefore, important to examine the relationships that exist among the data of an entity to refine the database design.

In this chapter, functional dependencies and decomposition concepts have been discussed to achieve ...

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