Students

StudentIDFirstNameLastNameMajorCityCampus
1JohnDoeComputer ScienceNew YorkUptown
2JaneSmithMathematicsLos AngelesDowntown
3MichaelBrownPhysicsChicagoLake Shore
4EmilyWhiteChemistryHoustonMedical Center
5DavidGarciaBiologyPhoenixCentral

Teachers

TeacherIDFirstNameLastNameSubjectTaughtHireDateOfficeLocation
1Mr.GreenEnglish Literature2019-08-15Room 207
2Ms.BlackHistory2018-09-01Room 210
3Dr.WilsonCalculus2016-05-30Room 302
4Prof.MartinPhysics2015-10-12Room 404
5Dr.JacksonBiology2017-12-20Room 506

Classes

ClassIDCourseTitleCreditHoursEnrollmentLimitRoomNumber
1Introduction to English Literature325Room 207
2World History I430Room 210
3Calculus II425Room 302
4General Physics320Room 404
5Anatomy and Physiology430Room 506

Departments

DepartmentIDNameDeanNameBuilding
1English DepartmentDean SmithBuilding A
2History DepartmentDean BrownBuilding B
3Math DepartmentDean JohnsonBuilding C
4Physics DepartmentDean MillerBuilding D
5Biology DepartmentDean DavisBuilding E

Facilities

FacilityIDTypeCapacityOpeningTimeClosingTime
1Library10008:00:0022:00:00
2Gymnasium20006:00:0022:00:00
3Science Lab5008:00:0022:00:00
4Art Studio2508:00:0022:00:00
5Music Hall10008:00:0022:00:00