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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.