Waste_Disposal_Method

idmethod_namedescription
1LandfillDisposing of waste by burying it in a designated area.
2IncinerationBurning waste to reduce its volume and kill pathogens.
3RecyclingProcessing waste materials to create new products.
4CompostingBreaking down organic matter into nutrient-rich humus.
5Biodegradable WasteOrganic waste that can be broken down by microorganisms.

Recycling_Program

idprogram_namedescription
1Community Recycling ProgramA local initiative to encourage recycling among residents.
2Corporate Recycling ProgramAn initiative by companies to recycle their waste.
3Electronic Waste RecyclingA specialized program to recycle electronic devices.
4Hazardous Waste RecyclingA program to handle and recycle hazardous waste.
5Construction Materials RecyclingA program focused on recycling construction materials.

Construction_Material

idmaterial_typequantity
1Concrete100.0
2Steel200.0
3Bricks300.0
4Glass400.0
5Aluminum500.0

Construction_Site

site_idsite_namelocationwaste_disposal_method_idrecycling_program_id
(→ Waste_Disposal_Method.id)(→ Recycling_Program.id)
1Site ANew York City11
2Site BLos Angeles22
3Site CChicago33
4Site DMiami44
5Site EDallas55

Site_Material

site_material_idconstruction_site_idconstruction_material_idamount
(→ Construction_Site.site_id)(→ Construction_Material.id)
11150.0
21275.0
32360.0
42480.0
53590.0

Disposed_Waste

disposed_waste_idsite_material_idwaste_disposal_method_iddisposal_date
(→ Site_Material.site_material_id)(→ Waste_Disposal_Method.id)
1112022-01-01
2112022-01-02
3222022-01-03
4222022-01-04
5332022-01-05