Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe1998-06-15
2JaneSmith2000-10-20
3MichaelJohnson1997-02-25
4EmmaWilliams2002-04-10
5DavidMartinez1999-08-15

Teachers

TeacherIDFirstNameLastNameSubjectTaught
1Mr.WhiteMathematics
2Ms.BlackPhysics
3Dr.GreenChemistry
4Prof.RedBiology
5MissBlueEnglish

Classes

ClassIDClassNameRoomNumberStartTimeEndTime
1Algebra I10108:00:0009:00:00
2Calculus II20110:00:0011:00:00
3General Chemistry30112:00:0001:00:00
4Organic Chemistry30202:00:0003:00:00
5Advanced Physics40104:00:0005:00:00

Laboratories

LabIDLabNameLocationHasEquipment
1Main Science LabRoom 1001
2Computer LabRoom 2000
3Art LabRoom 3001
4Music LabRoom 4000
5Language LabRoom 5001

Purchases

PurchaseIDLabIDItemNameQuantityCost
(→ Laboratories.LabID)
11Microscope1500.0
21Beakers502.5
32Headphones1010.0
43Paintbrushes203.0
54Guitars5300.0

LaboratoryEssentials

EssentialIDLabIDCategoryDescriptionLaboratory_EssentialsDate_of_purchase
(→ Laboratories.LabID)
11Lab EquipmentGlassware and chemicalsFlasks, Beakers, Test Tubes, etc.January 2023
21Lab EquipmentScientific instrumentsMicroscopes, Balances, Spectrophotometers, etc.February 2023
31Safety GearPersonal protective equipmentGloves, Safety goggles, Lab coats, etc.January 2023
42Lab EquipmentComputers and peripheralsDesktops, Monitors, Keyboards, etc.March 2023
53Safety GearFire prevention and control equipmentFire extinguishers, Fire blankets, Smoke detectors, etc.April 2023