All Master

Part 4 Methodology
This part of the book covers a methodology for database design. The methodology is
divided into three parts covering conceptual, logical, and physical database design. Each
part of the methodology is illustrated using the DreamHome case study.
Chapter 15 presents a step-by-step methodology for conceptual database design. It shows
how to decompose the design into more manageable areas based on individual views, and
then provides guidelines for identifying entities, attributes, relationships, and keys.
Chapter 16 presents a step-by-step methodology for logical database design for the
relational model. It shows how to map a conceptual data model to a logical data model
and how to validate it against the required transactions using the technique of normalization.
For database applications with multiple user views, this chapter shows how to merge
the resulting data models together into a global data model that represents all the views of
the part of the enterprise being modeled.
Chapters 17 and 18 present a step-by-step methodology for physical database design
for relational systems. It shows how to translate the logical data model developed during
logical database design into a physical design for a relational system. The methodology
addresses the performance of the resulting implementation by providing guidelines for
choosing file organizations and storage structures, and when to introduce controlled
redundancy.