James-Muguro/MajiNdogo-Water-Project

An initiative to analyze and improve water sources in Maji Ndogo, tracking visits, water quality, pollution, and progress in enhancing water infrastructure. # Maji Ndogo Water Project ## Project Overview The Maji Ndogo Water Project is a data-driven initiative aimed at analyzing and improving water sources in various towns and provinces. The project involves the exploration of multiple database tables, including information on water sources, visits, water quality, and pollution, to assess the current state of water infrastructure and identify areas for improvement. ## Table Structure The project utilizes several database tables to store relevant data: - **Location Table (`location`):** Contains information about specific locations, including address, province, town, and urban status. - **Visits Table (`visits`):** Holds details about each employee's visits, including source and location, time of record, visit count, and time in the queue. - **Water Quality Table (`water_quality`):** Contains information about subjective quality scores and visit counts. - **Water Source Table (`water_source`):** Logs details about each water source, such as location, source type, and the number of people served. - **Well Pollution Table (`well_pollution`):** Provides information about well pollution, including type, source ID, date recorded, pollutant concentration, biological contamination, and results. - **Auditor Report Table (`auditor_report`):** Stores information obtained from an auditor's report, including location ID, water source type, true water source score, and statements. - **Project Progress Table (`project_progress`):** Created for tracking improvement projects, this table includes project ID, source ID, address, town, province, source type, improvement action, source status, date of completion, and comments. ## Queries and Analysis ### Data Exploration and Analysis Queries have been written to explore and analyze different aspects of the data: - **Water Sources Analysis:** Investigates unique water sources based on source types. - **Visits to Water Sources:** Identifies visits where the estimated time to g …