4.4. Sample Data

STATE_LOOKUP
StateState Description
CACalifornia
NYNew York
NCNorth Carolina
MAJOR_LOOKUP
MajorMajor Description
UDUndeclared
BIBiology
MSMath/Science
HIHistory
ENEnglish
STUDENTS
Student IDStudent NameCollege MajorStatusStateLicense No
A101JohnBiologyDegreeNULLNULL
A102MaryMath/ScienceDegreeNULLNULL
A103KathrynHistoryDegreeCAMV-32-13
A104StevenBiologyDegreeNYMV-232-14
A105WilliamEnglishDegreeNCMV-232-15
STUDENT_VEHICLES
StateTag NoVehicle DescStudent IDParking Sticker
CACD 23481997 MustangA103C-101-AB-1
NYMH 87091998 GTIA104C-101-AB-2
NYJR 98371982 CivicA104C-101-AB-3
PARKING_TICKETS
Ticket NoAmountStateTag No
P_015.00CACD 2348
P_025.00NYMH 8709
P_035.00NYMH 8709
P_045.00NYJR 9837
PROFESSORS
Prof NameSpecialtyHire DateSalaryTenureDepartment
Blake ...

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.