| StudentID | FirstName | LastName | Major | City | Campus |
|---|---|---|---|---|---|
| 1 | John | Doe | Computer Science | New York | Uptown |
| 2 | Jane | Smith | Mathematics | Los Angeles | Downtown |
| 3 | Michael | Brown | Physics | Chicago | Lake Shore |
| 4 | Emily | White | Chemistry | Houston | Medical Center |
| 5 | David | Garcia | Biology | Phoenix | Central |
| TeacherID | FirstName | LastName | SubjectTaught | HireDate | OfficeLocation |
|---|---|---|---|---|---|
| 1 | Mr. | Green | English Literature | 2019-08-15 | Room 207 |
| 2 | Ms. | Black | History | 2018-09-01 | Room 210 |
| 3 | Dr. | Wilson | Calculus | 2016-05-30 | Room 302 |
| 4 | Prof. | Martin | Physics | 2015-10-12 | Room 404 |
| 5 | Dr. | Jackson | Biology | 2017-12-20 | Room 506 |
| ClassID | CourseTitle | CreditHours | EnrollmentLimit | RoomNumber |
|---|---|---|---|---|
| 1 | Introduction to English Literature | 3 | 25 | Room 207 |
| 2 | World History I | 4 | 30 | Room 210 |
| 3 | Calculus II | 4 | 25 | Room 302 |
| 4 | General Physics | 3 | 20 | Room 404 |
| 5 | Anatomy and Physiology | 4 | 30 | Room 506 |
| DepartmentID | Name | DeanName | Building |
|---|---|---|---|
| 1 | English Department | Dean Smith | Building A |
| 2 | History Department | Dean Brown | Building B |
| 3 | Math Department | Dean Johnson | Building C |
| 4 | Physics Department | Dean Miller | Building D |
| 5 | Biology Department | Dean Davis | Building E |
| FacilityID | Type | Capacity | OpeningTime | ClosingTime |
|---|---|---|---|---|
| 1 | Library | 100 | 08:00:00 | 22:00:00 |
| 2 | Gymnasium | 200 | 06:00:00 | 22:00:00 |
| 3 | Science Lab | 50 | 08:00:00 | 22:00:00 |
| 4 | Art Studio | 25 | 08:00:00 | 22:00:00 |
| 5 | Music Hall | 100 | 08:00:00 | 22:00:00 |