Table of Contents



  1. Executive Summary 1
    1. Business description and project goals 1
    2. Business Process 2
    3. Process Overview & Functional Decomposition 3

  2. Database Planning 4
    1. Preliminary Enterprise Data Model 4
    2. Business Function-to-Data Entity Matrix 5
    3. Business Process vs. Entity Matrix 5

  3. Conceptual Design 6
    1. User Views and ERDs
    2. Conceptual Data Model 34
      Integration of all user view ERDSs
    3. Business Rules/Constraints

  4. Logical Design 40
    1. Normalization (3NF)

  5. Physical Design 41
    1. Process vs. Entity Matrix
    2. Transaction analysis
    3. Composite usage map
    4. DDL statements
    5. Contents of populated tables, indexing, etc.

  6. Summary and Conclusion 57
    1. Summary & Conclusion