| 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 |
| 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 |
| 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 |
| inventoryID | materialID | quantity |
|---|---|---|
| (→ Material.materialID) | ||
| 1 | 1 | 50 |
| 2 | 2 | 100 |
| 3 | 3 | 200 |
| 4 | 4 | 100 |
| 5 | 5 | 50 |
| 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 |