DATA NORMALIZATION METHOD - Database Design and Development: An Essential Guide for IT Professionals - page 321

SocSecNo StudntName ClassNo RoomNo CourseDesc Credits FacltyName Speczn Department Phone Major

ISBN Title Price ISBN Author

TypeID ExamName MinScore SocSecNo ClassNo Score

SocSecNo StudntName Major

ClassNo RoomNo CourseDesc Credits FacltyName Speczn Department Phone

ClassNo CourseNo RoomNo FacultyID CourseNo CourseDesc Credits ISBN

FacultyID FacltyName Speczn Department Phone

TypeID ExamName MinScore

CourseNo ClassNo TypeID SocSecNo Score

Figure 10-16 University information: normalization steps.

Next, examine each table and go through the normalization steps one by one.
Figure 10-16 illustrates the normalization steps. Note carefully the outcome from
each step.
Figure 10-17 presents the final relational data model as a result of the normal-
ization process. Compare this with the relational data model in Figure 9-22 arrived
at through the data model transformation method.

CHAPTER SUMMARY

• The normalization method of creating a relational data model is an informal
design methodology.
• In this method, you intuitively create an initial data model from information
requirements and normalize it into a relational data model.
• An initial data model created through intuition contains potential anomalies
relating to updates, deletes, and addition of data.
• The normalization approach consists of systematically examining the initial
data model, removing the causes for anomalies, and transforming the data
model into a true relational data model. The approach consists of definite,
sequential steps.
• Each step removes one type of irregularity in the initial data model and trans-
forms the model into a distinct normal form.
• The first four steps transform the initial data model into fundamental
normal forms. Transformation into these fundamental normal forms removes