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 |