Understanding Normalization

A solid database structure is the foundation of any successful database application, and you will inevitably encounter problems if your database is poorly designed. Regardless of how you access your data, the information you retrieve is only as good as the data upon which it is based. In this paper, I’ll cover a traditional database design topic that seems to be quite a hurdle for many database designers and developers: Normalization. Normalization is the process of refining table structures into a proper state so that they can store data as efficiently as possible. Here you'll discover why Normalization is crucial and learn how to normalize your tables using Normal Forms. First, you'll learn about modification ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.