Chapter 6Logical Database Design Using Normalization

Key Skills & Concepts

The Need for Normalization

Applying the Normalization Process

Denormalization

In this chapter, you will learn how to perform logical database design using a process called normalization. It is normalization that teaches you how best to organize your data into tables. Therefore, normalization is essential to logical database design. The design is most often documented using a logical data model. The main inputs to the logical database design phase are the requirements from the Requirements Gathering phase, the conceptual data model, and user views (the collection of all the web pages, screens, reports, printed reports, and other presentations of the data that the ...

Get Data Modeling, A Beginner's Guide 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.