Chapter 8Physical Database Design

Key Skills & Concepts

The Physical Design Process

Designing Tables

Integrating Business Rules and Data Integrity

Adding Indexes for Performance

Designing Views

Once the logical design phase of a project is complete, it is time to move on to physical design. Other members of a typical project team will define the hardware and system software required for the application system. We will focus on the database designer’s physical design work, which is transforming the logical database design into one or more physical database designs. For situations in which an application system is being developed for internal use, it is normal to have only one physical database design for each logical design. However, ...

Get Data Modeling, A Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.