| studentID | firstName | lastName | |
|---|---|---|---|
| 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 |
| instructorID | firstName | lastName | |
|---|---|---|---|
| 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 |
| 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 |
| enrollmentID | studentID | classID |
|---|---|---|
| (→ Students.studentID) | (→ Classes.classID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |
| 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 |
| 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 |
| 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 |