Students

studentIDfirstNamelastNameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceJohnsonalice.johnson@example.com
4BobWilliamsbob.williams@example.com
5CharlieBrowncharlie.brown@example.com

Instructors

instructorIDfirstNamelastNameemail
1Dr.Avaavadoc@email.edu
2ProfessorXanderxanderx@email.edu
3AssistantPenelopepennyassis@email.edu
4AdjunctRobertrobertadjuct@email.edu
5TeachingMilesmilesteach@email.edu

Classes

classIDclassNameinstructorID
(→ Instructors.instructorID)
1Introduction to Computer Science1
2Advanced Calculus2
3Organic Chemistry3
4Physics I4
5World History5

StudentsEnrolledInClasses

enrollmentIDstudentIDclassID
(→ Students.studentID)(→ Classes.classID)
111
222
333
444
555

Labs

labIDlabNamebuildingNumberroomNumber
1Computer Lab ABuilding 1Room 101
2Biology Lab BBuilding 2Room 202
3Chemistry Lab CBuilding 3Room 303
4Physics Lab DBuilding 4Room 404
5Art Studio EBuilding 5Room 505

Lab_Equipments

equipmentIDlabIDequipNamedateOfPurchasecost
(→ Labs.labID)
11High Performance Desktop ComputersJanuary 20238999.99
21VR HeadsetsFebruary 20237999.99
32Advanced MicroscopesApril 20236999.99
42CentrifugesMay 20235999.99
53Electronic BalancesAugust 20234999.99

Safety_Gears

safetyGearIDlabIDgearNamedateOfPurchasecost
(→ Labs.labID)
11Fire ExtinguishersJanuary 20231999.99
21First Aid KitsFebruary 2023999.99
32Eye Wash StationsApril 20231499.99
42Spill Cleanup KitMay 2023899.99
53RespiratorsAugust 2023599.99