Database Reference
In-Depth Information
4
Database Design Using
Normalization
●
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