STATE_LOOKUP | State | State Description | | CA | California | | NY | New York | | NC | North Carolina | MAJOR_LOOKUP | Major | Major Description | | UD | Undeclared | | BI | Biology | | MS | Math/Science | | HI | History | | EN | English | STUDENTS | Student ID | Student Name | College Major | Status | State | License No | | A101 | John | Biology | Degree | NULL | NULL | | A102 | Mary | Math/Science | Degree | NULL | NULL | | A103 | Kathryn | History | Degree | CA | MV-32-13 | | A104 | Steven | Biology | Degree | NY | MV-232-14 | | A105 | William | English | Degree | NC | MV-232-15 | STUDENT_VEHICLES | State | Tag No | Vehicle Desc | Student ID | Parking Sticker | | CA | CD 2348 | 1997 Mustang | A103 | C-101-AB-1 | | NY | MH 8709 | 1998 GTI | A104 | C-101-AB-2 | | NY | JR 9837 | 1982 Civic | A104 | C-101-AB-3 | PARKING_TICKETS | Ticket No | Amount | State | Tag No | | P_01 | 5.00 | CA | CD 2348 | | P_02 | 5.00 | NY | MH 8709 | | P_03 | 5.00 | NY | MH 8709 | | P_04 | 5.00 | NY | JR 9837 | PROFESSORS | Prof Name | Specialty | Hire Date | Salary | Tenure | Department | | Blake | Mathematics | 07-Jul-03 | 1000 | YES | MATH | | Milton | Am History | 07-Jul-02 | 1000 | YES | HIST | | Wilson | English | 08-Jul-01 | 1000 | YES | ENGL | | Jones | Euro Hist | 05-Aug-00 | 1000 | YES | HIST | | Crump | Ancient Hist | 04-Aug-99 | 1000 | YES | HIST | COURSES | Course Name | Course Desc | No of Credits | | ENGL101 | English Lit | 3 | | MATH101 | Algebra | 3 | | HIST102 | Am History | 3 | | BIOL103 | Biology | 3 | STUDENTS_COURSES | Student ID | Course Name | Prof Name | | A101 | ENGL101 | Wilson | | A101 | MATH101 | Blake | | A102 | HIST102 | Crump | | A103 | HIST102 | Milton | | A104 | BIOL103 | Blake | | A104 | ENGL101 | Wilson | |