FieldTrips

iddestinationdatepurposebudgetNumber_of_students
1New York2023-09-16Museum Visit5000.050
2Washington DC2023-08-20Monument Tour7500.030

StudyHalls

idbuildingcapacityavailable_hoursnumber_of_students
1Building A10008:00 - 22:0050
2Building B15008:00 - 22:0030

Teachers

idnamesubjectyears_experienceoffice_number
1Mr. SmithMath10123
2Ms. JohnsonHistory7456

Classes

idteacher_idclass_namegrade_level
(→ Teachers.id)
11Algebra I9
22World History10

Students

idfirstNamelastNamestudentIdbirthDatefieldtrip_participantstudyhall_userclass_id
(→ Classes.id)
1JohnDoeJD1232005-05-15111
2EmmaSmithES4562004-06-18112