CHAPTER 5

image

Putting Good Tables Together

Now that you have an idea about how tables work, we need to make sure they can store our data in a proper manner. To do this, we use a process called Database Normalization. Once this has been applied to our tables, we should have an efficient database structure that minimizes duplicate data. Or to put it simply, everything should just work!

Database Normalization

A database is considered normalized when it meets a set of rules, known as the three rules of normalization. All this means is the database is structured in a way that follows recognized good practices and supports efficient data querying. It reduces ...

Get Introducing SQL Server now with O’Reilly online learning.

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