Data Dictionary – Class Advising System
This data dictionary is meant to be used for class assignments – the class advising system is meant to keep track of courses that students have taken and apply them towards requirements to graduate.
CollegeCourse | A representation of a class that exists in the course catalog at a college. A CollegeCourse will typically have the following elements;
CoursePrefix – (ex. COP) – A prefix that denotes the subject area of the class CourseCode (ex. 4709). Courses can be upper level (usually denoted by 3000, 4000 in code) or lower level (1000 or 2000). CourseDescription – A description of the course CreditHours (ex. 3) |
Major | A major is a distinct degree that can be awarded to a student.
MajorTitle (ex. Bachelor of Science Information Technology) MajoCode (ex. 6334) MajorDescription – Descriptive information about the major MajorLevel (enumeration; AA, AS, BS, BAS) |
CatalogYear | Because requirements of a major can change from year to year, the requirements (or program guide) for the major must have a specific Catalog Year
CatalogYear – typically a descriptive enumeration like CC16 CatalogYearStartTerm (Fall 16 for CC16) CatalogYearEndTerm (Summer 17 for CC16) – These describe which catalog year students will be placed in based on when they were admitted to a major. |
RequiredCourses | This is a list of CollegeCourse that are required for a specific Major and a specific CatalogYear |
ElectiveCourses | This is a list of CollegeCourse that can be used as an elective for a Major for a specific CatalogYear. |