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!
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 ...