## Students

StudentID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 1998-06-15
2 | Jane | Smith | 2000-10-20
3 | Michael | Johnson | 1997-02-25
4 | Emma | Williams | 2002-04-10
5 | David | Martinez | 1999-08-15

## Teachers

TeacherID | FirstName | LastName | SubjectTaught
--- | --- | --- | ---
1 | Mr. | White | Mathematics
2 | Ms. | Black | Physics
3 | Dr. | Green | Chemistry
4 | Prof. | Red | Biology
5 | Miss | Blue | English

## Classes

ClassID | ClassName | RoomNumber | StartTime | EndTime
--- | --- | --- | --- | ---
1 | Algebra I | 101 | 08:00:00 | 09:00:00
2 | Calculus II | 201 | 10:00:00 | 11:00:00
3 | General Chemistry | 301 | 12:00:00 | 01:00:00
4 | Organic Chemistry | 302 | 02:00:00 | 03:00:00
5 | Advanced Physics | 401 | 04:00:00 | 05:00:00

## Laboratories

LabID | LabName | Location | HasEquipment
--- | --- | --- | ---
1 | Main Science Lab | Room 100 | 1
2 | Computer Lab | Room 200 | 0
3 | Art Lab | Room 300 | 1
4 | Music Lab | Room 400 | 0
5 | Language Lab | Room 500 | 1

## Purchases

PurchaseID | LabID | ItemName | Quantity | Cost
--- | --- | --- | --- | ---
| (→ Laboratories.LabID) |  |  |
1 | 1 | Microscope | 1 | 500.0
2 | 1 | Beakers | 50 | 2.5
3 | 2 | Headphones | 10 | 10.0
4 | 3 | Paintbrushes | 20 | 3.0
5 | 4 | Guitars | 5 | 300.0

## LaboratoryEssentials

EssentialID | LabID | Category | Description | Laboratory_Essentials | Date_of_purchase
--- | --- | --- | --- | --- | ---
| (→ Laboratories.LabID) |  |  |  |
1 | 1 | Lab Equipment | Glassware and chemicals | Flasks, Beakers, Test Tubes, etc. | January 2023
2 | 1 | Lab Equipment | Scientific instruments | Microscopes, Balances, Spectrophotometers, etc. | February 2023
3 | 1 | Safety Gear | Personal protective equipment | Gloves, Safety goggles, Lab coats, etc. | January 2023
4 | 2 | Lab Equipment | Computers and peripherals | Desktops, Monitors, Keyboards, etc. | March 2023
5 | 3 | Safety Gear | Fire prevention and control equipment | Fire extinguishers, Fire blankets, Smoke detectors, etc. | April 2023