## Students

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

## Teachers

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

## Classes

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

## Departments

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

## Facilities

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