CHAPTER 5
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
