When to use normalization as a design strategy
In real life, entity analysis and normalizing data may not be as separate as this book suggests. They both lead to an ERD. Hence, you can utilize entity analysis skills (arguments) during normalization, and vice versa. Especially when you don't create a new database but you alter (extend) an existing one that isn't well normalized, you will use both techniques simultaneously.
For many people, normalizing data is equivalent to relational databases. The misconception is that a database has to be normalized in order to be a relational database. In Chapter 1, Introduction to Databases, you learned that storing data as tables is what makes a database relational. You also learned that those tables have to be created before you can store actual data. All databases created using a Relational Database Management System (RDBMS) are relational databases. However, normalizing is a technique used to design relational databases.
This...
