4.4. Sample Data
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 |
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.
