Database Reference
In-Depth Information
4
Database Design Using
Normalization
Chapter Objectives
To design updatable databases to store data received
from another source
To use SQL to access table structure
To understand the advantages and disadvantages of
normalization
To understand denormalization
To design read-only databases to store data from
updateable databases
To recognize and be able to correct common design
problems:
The multivalue, multicolumn problem
The inconsistent values problem
The missing values problem
The general-purpose remarks column problem
In Chapter 3 , we defined the relational
model, described modification anomalies, and
discussed normalization using BCNF and 4NF. In this
chapter, we apply those concepts to the design of databases
that are created from existing data.
The premise of this chapter, as it was in Chapter 3 is that you have
received, from some source, one or more tables of data that are to be
stored in a new database. The question is, should that data be stored as is,
or should it be transformed in some way before it is stored? Normalization
theory plays an important role, as you will see.
 
 
 
 
Search WWH ::




Custom Search