Chapter Objectives
In this chapter you will learn:
n The purpose of a design methodology.
n Database design has three main phases: conceptual, logical, and physical
design.
n How to decompose the scope of the design into specific views of the enterprise.
n How to use Entity–Relationship (ER) modeling to build a local conceptual data
model based on the information given in a view of the enterprise.
n How to validate the resultant conceptual model to ensure it is a true and accurate
representation of a view of the enterprise.
n How to document the process of conceptual database design.
n End-users play an integral role throughout the process of conceptual database
design.