Students

StudentIDFirstNameLastNameBirthdateEnrollmentYear
1JohnDoe1998-06-152017
2JaneSmith2000-01-202018
3MichaelBrown1996-09-052016
4EmilyJohnson1995-02-122017
5DavidWilliams2001-05-032019

Teachers

TeacherIDFirstNameLastNameDateHiredSubjectTaught
1Mr.White2015-08-25Mathematics
2Ms.Black2014-08-18Physics
3Mr.Green2018-09-01Chemistry
4Ms.Yellow2013-07-22Biology
5Dr.Blue2017-05-15Computer Science

Classes

ClassIDClassNameStartTimeEndTimeRoomNumberTeacherID
(→ Teachers.TeacherID)
1Math 10108:00:0009:00:001011
2Physics 20109:30:0010:30:001022
3Chemistry 30111:00:0012:00:001033
4Biology 40101:00:0002:00:001044
5CS 50102:30:0003:30:001055

LabEquipment

EquipmentIDDescriptionQuantityInStockLaboratory_EssentialsDate_of_PurchaseClassID
(→ Classes.ClassID)
1Lab Equipment20Lab Equipment2023-01-011
2Safety Gear50Safety Gear2023-01-012
3Lab Equipment30Lab Equipment2018-05-013
4Safety Gear40Safety Gear2018-05-014
5Lab Equipment15Lab Equipment2021-03-015
6Extra Lab Equipment10Lab Equipment2023-01-011
7Additional Safety Gear20Safety Gear2023-01-012