Database Design

Requirements Analysis

user needs; what must database do?

Conceptual Design

high level description (often done w/ER model)

Entities

Relationships

Logical Design

translate ER into DBMS data model

Schema Refinement

consistency, normalization

Physical Design

indexes, disk layout

Security Design

who accesses what, and how

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.