Table of Contents

  1. Introduction
    1. Executive Summary

  2. Planning for the Database
    1. Business Function vs. Entity Matrix
    2. Preliminary Enterprise Data Model (EDM)

  3. Conceptual Design
    1. User Views and Entity Relationship Diagrams (ERDs)
      1. Ask Question (User View)
        Ask Question (ERD)
      2. Edit Question (User View)
        Edit Question (ERD)
      3. Pass Question (User View)
        Pass Question (ERD)
      4. Answer Question (User View)
        Answer Question (ERD)
      5. Edit Answer (User View)
        Edit Answer (ERD)
      6. Evaluate Answer (User View)
        Evaluate Answer (ERD)
      7. Recycle Question (User View)
        Recycle Question (ERD)
      8. Check Status (User View)
        Check Status (ERD)
      9. Search Question (User View)
        Search Question (ERD)
      10. Join Scientist (User View)
        Join Scientist (ERD)
      11. List Scientist (User View)
        List Scientist (ERD)
      12. Post Message (User View)
        Post Message (ERD)
      13. Post Reply (User View)
        Post Reply (ERD)
      14. Search Link (User View)
        Search Link (ERD)
      15. Submit Experiment (User View)
        Submit Experiment (ERD)
      16. Evaluate Experiment (User View)
        Evaluate Experiment (ERD)
      17. Search Experiment (User View)
        Search Experiment (ERD)
      18. Put on Hold (User View)
        Put on Hold (ERD)
    2. Conceptual Data Model (CDM)
    3. Domain Definition
    4. Other Business Rules, Restrictions, & Constraints

  4. Logical Design
    1. Normalization (3NF)

  5. Physical Design & Implementation
    1. Process vs. Entity Matrix
    2. Transaction Analysis Forms (TAFs)
    3. Composite Usage Map
    4. Data Definition Language (DDL) statements
    5. List contents of populated tables
    6. Sample Queries
    7. Discussion of Physical Design

  6. Summary and Conclusion
    1. Project Summary

  7. Appendix A