Database

Overview

The CBRSys database is designed to support either a course-based registration system (where students can be enrolled on a course-by-course basis) or a semester-based registration system (where students enroll in a “semester” and are slotted into specific courses based upon which courses are offered for that semester and upon what courses the student has already completed).

The main difference in these two systems lies in their respective business rules, rather than the specific organization of the data. The idea here is that both systems can be supported by the data structure as long as that structure has an adequate level of “abstraction” amongst its entities.
TODO:
  • Done: Finish initial database design
  • Done: Revise and post database
  • Post table descriptions & the ERD
  • Generate the create scripts for the ERD
  • Do an article on "Database Versioning"

Last edited May 2, 2009 at 6:13 AM by dagilleland, version 4

Comments

No comments yet.