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.
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
