## Material

materialID | name | quantity | cost
--- | --- | --- | ---
1 | Cement | 100 | 39.99
2 | Steel Rebars | 200 | 68.75
3 | Concrete Blocks | 300 | 25.0
4 | Bricks | 150 | 18.5
5 | Electrical Wiring | 100 | 45.0

## Employee

employeeID | firstName | lastName | hireDate | position
--- | --- | --- | --- | ---
1 | John | Doe | 2021-01-01 | Project Manager
2 | Jane | Smith | 2021-02-01 | Engineer
3 | Mike | Johnson | 2021-03-01 | Construction Worker
4 | Emily | Brown | 2021-04-01 | Supervisor
5 | Tom | White | 2021-05-01 | Architect

## Project

projectID | projectName | startDate | endDate | budget
--- | --- | --- | --- | ---
1 | Residential Building | 2021-06-01 | 2021-08-01 | 300000.0
2 | Commercial Complex | 2021-07-01 | 2021-09-01 | 1000000.0
3 | Road Repair | 2021-08-01 | 2021-10-01 | 500000.0
4 | School Renovation | 2021-09-01 | 2021-11-01 | 600000.0
5 | Office Building | 2021-10-01 | 2021-12-01 | 700000.0

## Inventory

inventoryID | materialID | quantity
--- | --- | ---
| (→ Material.materialID) |
1 | 1 | 50
2 | 2 | 100
3 | 3 | 200
4 | 4 | 100
5 | 5 | 50

## Safety

safetyID | employeeID | personalProtectiveEquipment | trainingPrograms | constructionWorker
--- | --- | --- | --- | ---
| (→ Employee.employeeID) |  |  |
1 | 1 | Hard Hat, Gloves, Steel-toed Boots | OSHA Training, First Aid Certification | Experienced
2 | 2 | Helmet, Earplugs, Safety Glasses | Fall Protection Training, CPR/First Aid | Intermediate
3 | 3 | Hard Hat, Gloves, Safety Vest | Toolbox Talks, Scaffolding Training | Novice
4 | 4 | Helmet, Safety Shoes, Goggles | Hazard Communication Training, Forklift Operation | Skilled
5 | 5 | Hard Hat, Gloves, Knee Pads | Lockout/Tagout Training, Confined Space Entry | Expert