johnteeklo-analyst/Ghana-Energy-Database-Design

Relational database design for a centralized energy data management system in Ghana — MSBA 611 Academic Project # Ghana Centralized Energy Data Management System Relational database design for a centralized energy data management system in Ghana — UGBS Project ## Project Overview A fully normalized relational database designed to consolidate operational data across Ghana's electricity value chain, covering generation, distribution, billing, payments, outages, and maintenance. ## Contents - ghana_energy_db.sql — Full database and table creation script ## Tables 1. Region 2. Plant 3. Substation 4. Generation 5. Customer 6. Tariff 7. Billing 8. Payment 9. Outage 10. Maintenance ## Skills Database Normalization | ERD Design | Crow's Foot Notation | Relational Schema | SQL | Functional Dependency Analysis