Esitty/green-hydrogen-supply-chain-analytics

Relational database design and analytics for a green hydrogen supply chain (Africa to Europe) # Green Hydrogen Supply Chain Analytics A relational database design and analytics project modelling a green hydrogen supply chain from production sites in Morocco, Namibia, and Egypt to European offtakers in Germany, the Netherlands, and France. Aapplying a structured forward engineering methodology - Introduce, Decompose, Build, Validate, Deploy and Document. --- ## Overview Green hydrogen is produced through electrolysis powered by solar and wind energy. Africa has some of the best solar and wind resources in the world, while Europe is a major buyer under bilateral hydrogen partnerships (e.g. Germany's Nationale Wasserstoffstrategie). This project models the data infrastructure needed to manage that supply chain from production and storage through to shipping, contracts, and financial performance. --- ## Database Schema The database consists of **8 tables** covering 8 business domains: | Domain | Table | Description | |---|---|---| | Production | `ProductionSites` | Hydrogen production facilities across Morocco, Namibia, Egypt | | Supplier Management | `Suppliers` | Equipment and material suppliers per site | | Storage | `StorageFacilities` | Export port storage facilities | | Inventory | `StockInventory` | Variance between produced and stored hydrogen | | Contract Management | `Contracts` | Agreements between producers and European offtakers | | Offtakers | `Offtakers` | European buyers (Germany, Netherlands, France) | | Shipments and Logistics | `Shipments` | Vessel movements from Africa to Europe | | Financial Performance | `Financials` | Revenue, production cost, and logistics cost | **Schema summary:** 8 primary keys, 11 foreign keys, normalised to 3NF. --- ## Entity Relationship Diagram The ERD shows all 8 tables, primary keys, foreign keys, and relationships — including the many-to-many relationship between `ProductionSites` and `Offtakers`, resolved through the `Contracts` junction table. *(See `/diagrams/erd.png`)* --- ## Views | View | …