Executive Summary 1

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

Database Planning 4

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

Conceptual Design 6

1. User Views and ERDs
   • Employee Information view 7
   • Employee Information ERD 8
   • Jurisdiction Contact Information view 9
   • Jurisdiction Contact Information ERD 10
   • City Zoning Information view 11
   • City Zoning Information ERD 12
   • Property Basic Information view 13
   • Property Basic Information ERD 15
   • Owner Information view 16
   • Owner Information ERD 17
   • Broker Information view 18
   • Broker Information ERD 19
   • Property Financial Information view 20
   • Property Financial Information ERD 21
   • Property Tax Information view 22
   • Property Tax Information ERD 23
   • Developer Information view 24
   • Developer Information ERD 25
   • Developer Search Analysis view 26
   • Developer Search Analysis ERD 27
   • Employee Analysis Report view 28
   • Employee Analysis Report ERD 29
   • Misc. User Views (administrative backend only)
     • Property Usage Information View 30
     • Property Search view 31
     • Property Contaminant Information View 32
     • City, State, Zip Information View 33
     • Original Brokers' Userviews
2. Conceptual Data Model 34
   Integration of all user view ERDSs
3. Business Rules/Constraints
   • Domain Definitions 35
   • Other business rules, restrictions, constraints 39
     Requirements for the database
   • Referential Integrity 39

Logical Design 40

1. Normalization (3NF)

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.

Summary and Conclusion 57

1. Summary & Conclusion