Material

materialIDnamequantitycost
1Cement10039.99
2Steel Rebars20068.75
3Concrete Blocks30025.0
4Bricks15018.5
5Electrical Wiring10045.0

Employee

employeeIDfirstNamelastNamehireDateposition
1JohnDoe2021-01-01Project Manager
2JaneSmith2021-02-01Engineer
3MikeJohnson2021-03-01Construction Worker
4EmilyBrown2021-04-01Supervisor
5TomWhite2021-05-01Architect

Project

projectIDprojectNamestartDateendDatebudget
1Residential Building2021-06-012021-08-01300000.0
2Commercial Complex2021-07-012021-09-011000000.0
3Road Repair2021-08-012021-10-01500000.0
4School Renovation2021-09-012021-11-01600000.0
5Office Building2021-10-012021-12-01700000.0

Inventory

inventoryIDmaterialIDquantity
(→ Material.materialID)
1150
22100
33200
44100
5550

Safety

safetyIDemployeeIDpersonalProtectiveEquipmenttrainingProgramsconstructionWorker
(→ Employee.employeeID)
11Hard Hat, Gloves, Steel-toed BootsOSHA Training, First Aid CertificationExperienced
22Helmet, Earplugs, Safety GlassesFall Protection Training, CPR/First AidIntermediate
33Hard Hat, Gloves, Safety VestToolbox Talks, Scaffolding TrainingNovice
44Helmet, Safety Shoes, GogglesHazard Communication Training, Forklift OperationSkilled
55Hard Hat, Gloves, Knee PadsLockout/Tagout Training, Confined Space EntryExpert