Database Reference
In-Depth Information
CHAPTER 10
DATA NORMALIZATION METHOD
CHAPTER OBJECTIVES
•
Understand how the normalization method creates the relational data
model
•
Examine this informal approach and its potential pitfalls
•
Note the significance of the normalization approach
•
Study the systematic steps that lead to a normalized relational data model
•
Learn the fundamental normal forms in depth
•
Review the higher normal forms
As you studied the model transformation method in Chapter 9, you might have had
thoughts on the necessity of that method. You might have wondered why you need
to create a semantic data model first and then bother to transform that model into
a relational data model. If you already know that your target database system is
going to be a relational database system, why not create a relational data model
itself from the information requirements? These are valid thoughts. Even though
you learned the merits of the model transformation method in Chapter 9, is it not
a longer route for logical design?
In this chapter, we will pursue these thoughts. We will attempt to put together a
relational data model from the information requirements. We will see what happens
and whether the resultant model readily becomes a relational data model. If not,
we will explore what should be done to make the initial outcome of this method
become a good relational model.
Search WWH ::
Custom Search