4.1. Entity Relationship Diagram

Figure 4-1 describes a student schema. There is a lookup table for state abbreviations and their descriptions, the STATE_LOOKUP table. Another lookup stores academic concentrations, the MAJOR_LOOKUP table.

A professor has an attribute DEPARTMENT that is enforced with a CHECK constraint rather than a lookup table. Other check constraints are on the professor's SALARY column, professor's TENURE column, and students DEGREE column.

A student can register vehicles on campus. Students register for courses from those offered in the COURSES table. The official registration list of students and classes taken by students is the STUDENTS_COURSES table.