We started with a general introduction to the theory of relational algebra, relational databases, and data modeling. This was discussed in Chapter 1, Relational Databases.
Fundamentals
Normalization
Normalization is a process of restructuring a relational database in order to bring its tables into one of the normal forms. There are several normal forms that define requirements to the structure of a table or, strictly speaking, a relation.
For example, a relation is in first normal form (1NF) only when each of its attributes contains a single value. To understand this concept, think about a table that contains a phone book where each record corresponds to a person. If a person has more than one telephone number, they all would...
