O'Reilly logo

Database Design: Know It All by Graham Witt, Graeme Simsion, Markus Schneider, Patrick O'Neil, Elizabeth O'Neil, Bonnie O'Neil, Thomas P. Nadeau, Tony Morgan, Jim Melton, Sam S. Lightstone, W.H. Inmon, Jan L. Harrington, Terry Halpin, Ralf Hartmut Güting, Lowell Fryman, Stephen Buxton, Toby J. Teorey

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

Given any pool of entities and attributes, there are a number of ways you can group them into relations. In this chapter, you will be introduced to the process of normalization, through which you create relations that avoid most of the problems that arise from bad relational design.

There are at least two ways to approach normalization. The first is to work from an entity–relationship (ER) diagram. If the diagram is drawn correctly, then there are some simple rules you can use to translate it into relations that will avoid most relational design problems. The drawback to this approach is that it can be difficult to determine whether your design is correct. The second approach is to use the theoretical concepts behind ...

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