OYINKANSOLAOJUGBELE/maji-ndogo-sql-project

SQL project exploring water access and quality, with data-cleaning updates and insights. # Maji Ndogo Water Crisis Analysis ## Project Overview This repository contains SQL analysis scripts for the Maji Ndogo water crisis project - a comprehensive data-driven initiative to address water access and quality issues affecting millions of people in Maji Ndogo. The project analyzes a database of 60,000+ survey records collected by field engineers, scientists, and analysts. **Project Leadership:** - **President Aziza Naledi** - Project Sponsor - **Chidi Kunto** - Senior Data Analyst & Mentor ## Background Maji Ndogo faces a critical water crisis affecting millions of citizens. This analysis aims to: - Identify water sources requiring urgent intervention - Assess water quality and contamination levels - Understand service delivery bottlenecks (queue times) - Correct data integrity issues for accurate decision-making ## Database Structure ### Tables - **location** - Geographic information (address, province, town, location type) - **visits** - Visit logs with timestamps, queue times, and employee assignments - **water_source** - Water source types and people served - **water_quality** - Quality scores from field surveyors (1-10 scale) - **well_pollution** - Contamination test results (biological and chemical) - **employee** - Staff information - **data_dictionary** - Built-in documentation for all columns ### Key Relationships - `source_id` links visits to water_source table - `location_id` links visits to location table - `assigned_employee_id` links visits to employee table ## Water Source Types 1. **River** - Open water source with highest contamination risk 2. **Well** - Closed underground source (may be contaminated) 3. **Shared Tap** - Public taps serving 2,700-3,900+ people 4. **Tap in Home** - Ideal solution, serves ~6 people per household 5. **Broken Tap in Home** - Infrastructure exists but non-functional ## Analysis Workflow ### 1. Data Exploration ```sql -- View all tables in database SHOW TABLES; -- Preview data structure SELECT * FROM …