realNommy/maji-ndogo-data-analytics
Domain:
environment and energyRecord type:
dataset
Creator:
rea
Host:
End-to-end data analytics project using SQL, MySQL, Power BI, Power Query, DAX, data modeling, and data visualization.
-- ==============================================================================
-- MAJI NDOGO WATER SERVICES DATABASE (COMPLETE SEED SCRIPT)
-- Course: ALX Data Analytics / Maji Ndogo Project
-- ==============================================================================
CREATE DATABASE IF NOT EXISTS maji_ndogo;
USE maji_ndogo;
-- ------------------------------------------------------------------------------
-- Table: employee
-- ------------------------------------------------------------------------------
DROP TABLE IF EXISTS employee;
CREATE TABLE employee (
assigned_employee_id INT PRIMARY KEY,
employee_name VARCHAR(255) NOT NULL,
phone_number VARCHAR(50),
email VARCHAR(255),
address VARCHAR(255),
province_name VARCHAR(100),
town_name VARCHAR(100),
position VARCHAR(100)
);
INSERT INTO employee (assigned_employee_id, employee_name, phone_number, email, address, province_name, town_name, position) VALUES
(0, 'Jengo Tumaini', '+99712584936', 'jengo.tumaini@mdwater.gov', '123 River View', 'Sokoto', 'Balanja', 'Field Agent'),
(1, 'Vuyisile Ghadir', '+99317854629', 'vuyisile.ghadir@mdwater.gov', '45 Lab Lane', 'Amanzi', 'Dahabo', 'Micro Biologist'),
(2, 'Usafi Bahir', '+99234156789', 'usafi.bahir@mdwater.gov', '78 Health St', 'Hawassa', 'Zuri', 'Data Analyst'),
(3, 'Bello Pendo', '+99654123890', 'bello.pendo@mdwater.gov', '89 Central Ave', 'Sokoto', 'Balanja', 'Field Agent'),
(4, 'Farai Simba', '+99432187654', 'farai.simba@mdwater.gov', '12 Green Rd', 'Amanzi', 'Dahabo', 'Field Agent');
-- ------------------------------------------------------------------------------
-- Table: location
-- ------------------------------------------------------------------------------
DROP TABLE IF EXISTS location;
CREATE TABLE location (
location_id VARCHAR(50) PRIMARY KEY,
province_name VARCHAR(100),
town_name VARCHAR(100),
location_type VARCHAR(50)
);
INSERT INTO location (location_id, province_name, town_name, location_type) VALUES
('SoBa31102', 'Sokoto', 'Balanja', 'Urban' …