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 |