Materials

material_idnamecost
1Concrete30.0
2Steel Rebar60.0
3Lumber20.0
4Bricks15.0
5Cement45.0

Projects

project_idnamestart_dateend_dateinfrastructure_id
(→ Infrastructure.infrastructure_id)
1Highway Bridge Repair2023-01-012023-07-311
2Road Paving2023-05-012023-10-312
3Building Foundation2023-03-012023-09-303
4Stadium Construction2023-08-012024-02-284
5Park Improvement2023-06-012023-12-315

Infrastructure

infrastructure_iddescriptionservice_life_expectancy_idrenewal_schedule_id
(→ Service_Life_Expectancy.service_life_expectancy_id)(→ Renewal_Schedule.renewal_schedule_id)
1Bridge Abutment11
2Retaining Wall22
3Foundation Slab33
4Earthwork Embankment44
5Drainage System55

Workers

worker_idfirst_namelast_nameskill_level
1JohnSmith8
2JaneDoe9
3MikeJohnson7
4EmilyWilliams9
5DavidBrown8

Tasks

task_iddescriptionassigned_to_worker_iddue_datecompleted
(→ Workers.worker_id)
1Repair concrete cracks12023-07-150
2Install new drainage system22023-10-010
3Replace steel rebar32023-09-150
4Paint bridge abutments42023-11-150
5Level retaining wall52023-12-150

Service_Life_Expectancy

service_life_expectancy_idmin_yearsmax_years
12040
21530
33060
41020
5515

Renewal_Schedule

renewal_schedule_idfrequency
1Yearly
2Quarterly
3Semiannually
4Monthly
5Annually