Step 2 is the process of Conceptual database design.

I have identified the following Access-specific entities (others are look-up tables derived from the SIS database structure):

Conventions used: underlined terms refer to primary keys (PK); "FK" refers to foreign keys. Data Architect is one possible tool to use to convert the following entities into appropriate Entity-Relationship Diagrams.

Terms

  1. code
  2. description
  3. start date
  4. end date

Examples: 992, Spring 1999, 1/6/99, 5/8/99

Student Athletes

  1. PID
  2. ID
  3. Last
  4. First
  5. Middle
  6. Title
  7. SSN
  8. Sport 1
  9. Sport 2
  10. Male
  11. First Year
  12. E-mail
  13. Line 1
  14. Line 2
  15. Line 3
  16. City
  17. State
  18. Zip
  19. Phone

Award

  1. TermID (FK to Terms)
  2. PID (FK to Student Athletes)
  3. Tuition
  4. TuitionCap
  5. Fees
  6. FeesCap
  7. Room
  8. RoomCap
  9. Board
  10. BoardCap
  11. Books
  12. BooksCap
  13. Room/Student?
  14. Board/Student?
  15. Granville?
  16. Tuition/IS
  17. Books/IS
  18. Credit Hours
  19. CountryValue (FK to Citizen)
  20. ClassificationValue (FK to Classification)
  21. CollegeValue (FK to College)
  22. MajorValue (FK to Major)
  23. Code (FK to Scholarship.Code)
  24. SportValue (FK to Sport)
  25. TaxStatusValue (FK to TaxStatus)
  26. Special Program (FK to Special Program)
  27. Notes
  28. Effective Date
  29. Cancellation Date
  30. Withdrawal Date

Vendors

  1. VendorID
  2. VendorName
  3. Street
  4. City
  5. State
  6. Zip
  7. Contact Person Name
  8. Phone
  9. Fax
  10. E-mail
  11. Account#
  12. Dept#

Debits & Credits

  1. Tx#
  2. Term (FK to Award)
  3. PID (FK to Award)
  4. Order (FK to Transaction Types.Order, this IDs the transaction as tuition, fees, etc.)
  5. Amount
  6. Tax Code (FK to Tax Codes.Tax Code)
  7. Reason (FK to Reasons.Reason)
  8. Ticket#
  9. X or K#

The database design process is comprised of the following steps*:

Step Description
1 Requirements collection and analysis
2 Conceptual database design
3 Choice of a DBMS
4 Data model mapping (also called logical database design)
5 Physical database design
6 Database system implementation

Other Links:

Last modified by Blaise Byron Faint on: July 23, 2001