## Students

studentID | firstName | lastName | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Alice | Johnson | alice.johnson@example.com
4 | Bob | Williams | bob.williams@example.com
5 | Charlie | Brown | charlie.brown@example.com

## Instructors

instructorID | firstName | lastName | email
--- | --- | --- | ---
1 | Dr. | Ava | avadoc@email.edu
2 | Professor | Xander | xanderx@email.edu
3 | Assistant | Penelope | pennyassis@email.edu
4 | Adjunct | Robert | robertadjuct@email.edu
5 | Teaching | Miles | milesteach@email.edu

## Classes

classID | className | instructorID
--- | --- | ---
|  | (→ Instructors.instructorID)
1 | Introduction to Computer Science | 1
2 | Advanced Calculus | 2
3 | Organic Chemistry | 3
4 | Physics I | 4
5 | World History | 5

## StudentsEnrolledInClasses

enrollmentID | studentID | classID
--- | --- | ---
| (→ Students.studentID) | (→ Classes.classID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Labs

labID | labName | buildingNumber | roomNumber
--- | --- | --- | ---
1 | Computer Lab A | Building 1 | Room 101
2 | Biology Lab B | Building 2 | Room 202
3 | Chemistry Lab C | Building 3 | Room 303
4 | Physics Lab D | Building 4 | Room 404
5 | Art Studio E | Building 5 | Room 505

## Lab_Equipments

equipmentID | labID | equipName | dateOfPurchase | cost
--- | --- | --- | --- | ---
| (→ Labs.labID) |  |  |
1 | 1 | High Performance Desktop Computers | January 2023 | 8999.99
2 | 1 | VR Headsets | February 2023 | 7999.99
3 | 2 | Advanced Microscopes | April 2023 | 6999.99
4 | 2 | Centrifuges | May 2023 | 5999.99
5 | 3 | Electronic Balances | August 2023 | 4999.99

## Safety_Gears

safetyGearID | labID | gearName | dateOfPurchase | cost
--- | --- | --- | --- | ---
| (→ Labs.labID) |  |  |
1 | 1 | Fire Extinguishers | January 2023 | 1999.99
2 | 1 | First Aid Kits | February 2023 | 999.99
3 | 2 | Eye Wash Stations | April 2023 | 1499.99
4 | 2 | Spill Cleanup Kit | May 2023 | 899.99
5 | 3 | Respirators | August 2023 | 599.99