Normal Forms and Anomalies
Learn about normal forms and anomalies in a database.
We'll cover the following...
While some rules (such as the rule of silence) can’t really apply to database modeling, most of them do so in a very direct way. Normal forms offer a practical way to enforce respect for those rules. SQL provides a clean interface to connect our data structures: the join operations.
As we’re going to see later, a database model with fewer tables isn’t a better or simpler data model. The rule of separation might be the most important on that list. Also, the rule of representation in database modeling is reflected directly in the choice of correct data types with advanced behavior and processing function availability.
To summarize all those rules and the different levels for normal forms, we believe that we need to express our intentions first. Anyone reading a database schema should instantly understand the business model.
There are several levels of normalization.
Normal forms
In this quick introduction to database normalization, we include the ...