chapter 8Physical Database Design
As introduced in Chapter 5 in Figure 5-1, once the logical design phase of a project is complete, it is time to move on to physical design. 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. The sections that follow cover each of the major steps involved in physical database design.
CHAPTER OBJECTIVES
In this chapter, the reader should:
• Understand the process of designing physical tables, including the alternatives for handling supertypes and subtypes.
• Understand the techniques for integrating business rules and data integrity into physical database designs, including alternatives for implementing constraints. ...
Get Databases DeMYSTiFieD, 2nd Edition, 2nd Edition 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.
