Lab_Equipment

idEquipmentNamePurchaseDate
1MicroscopeJanuary 2023
2ThermometerFebruary 2023
3ScaleMarch 2023
4BeakerApril 2023
5EyedropperMay 2023

Safety_Gear

idGearTypeDate_of_Purchase
1GlovesJanuary 2023
2GogglesFebruary 2023
3MaskMarch 2023
4HairnetApril 2023
5BootsMay 2023

Employees

idNamePosition
1John DoeLaboratory Technician
2Jane SmithResearch Scientist
3Alice JohnsonQuality Control Officer
4Bob BrownEngineer
5Charlie DavisManager

Purchases

idDate_of_PurchaseLab_EquipmentIdSafety_GearIdEmployeeId
(→ Lab_Equipment.id)(→ Safety_Gear.id)(→ Employees.id)
1January 2023111
2February 2023222
3March 2023333
4April 2023444
5May 2023555