Approaching Database Design Systematically
o Overview of Database Design
o Gathering Database Requirements
o Creating a Conceptual Database Design
Modeling a Database at the Logical Level
o Building a Logical Database Model
o Designing for OLTP Activity
o Designing for Data Warehousing
o Evaluating Logical Models
Modeling a Database at the Physical Level
o Designing Physical Database Objects
o Designing Constraints
o Designing for Database Security
o Designing Server and Database Options
o Evaluating the Physical Model
Designing for Database Performance
o Designing Indexes
o Planning for Table Optimization
o Planning for Database Optimization
Designing a Database Access Strategy
o Designing for Secure Data Access
o Designing User-Defined Functions
o Designing Stored Procedures
Modeling Database Dependencies
o Modeling Local Database Dependencies
o Modeling Remote Database Dependencies
