## Waste_Disposal_Method

id | method_name | description
--- | --- | ---
1 | Landfill | Disposing of waste by burying it in a designated area.
2 | Incineration | Burning waste to reduce its volume and kill pathogens.
3 | Recycling | Processing waste materials to create new products.
4 | Composting | Breaking down organic matter into nutrient-rich humus.
5 | Biodegradable Waste | Organic waste that can be broken down by microorganisms.

## Recycling_Program

id | program_name | description
--- | --- | ---
1 | Community Recycling Program | A local initiative to encourage recycling among residents.
2 | Corporate Recycling Program | An initiative by companies to recycle their waste.
3 | Electronic Waste Recycling | A specialized program to recycle electronic devices.
4 | Hazardous Waste Recycling | A program to handle and recycle hazardous waste.
5 | Construction Materials Recycling | A program focused on recycling construction materials.

## Construction_Material

id | material_type | quantity
--- | --- | ---
1 | Concrete | 100.0
2 | Steel | 200.0
3 | Bricks | 300.0
4 | Glass | 400.0
5 | Aluminum | 500.0

## Construction_Site

site_id | site_name | location | waste_disposal_method_id | recycling_program_id
--- | --- | --- | --- | ---
|  |  | (→ Waste_Disposal_Method.id) | (→ Recycling_Program.id)
1 | Site A | New York City | 1 | 1
2 | Site B | Los Angeles | 2 | 2
3 | Site C | Chicago | 3 | 3
4 | Site D | Miami | 4 | 4
5 | Site E | Dallas | 5 | 5

## Site_Material

site_material_id | construction_site_id | construction_material_id | amount
--- | --- | --- | ---
| (→ Construction_Site.site_id) | (→ Construction_Material.id) |
1 | 1 | 1 | 50.0
2 | 1 | 2 | 75.0
3 | 2 | 3 | 60.0
4 | 2 | 4 | 80.0
5 | 3 | 5 | 90.0

## Disposed_Waste

disposed_waste_id | site_material_id | waste_disposal_method_id | disposal_date
--- | --- | --- | ---
| (→ Site_Material.site_material_id) | (→ Waste_Disposal_Method.id) |
1 | 1 | 1 | 2022-01-01
2 | 1 | 1 | 2022-01-02
3 | 2 | 2 | 2022-01-03
4 | 2 | 2 | 2022-01-04
5 | 3 | 3 | 2022-01-05