This repository contains the source code and database schema for managing the supply chain operations of Al-Haram Suffra, a charitable organization focused on providing food aid to those in need.
- Database Schema: The SQLite database schema includes tables for managing donors, volunteers, suppliers, supervisors, workers, and more.
- Data Generation: Python scripts are provided to generate random data for populating the database tables.
- Data Analysis: Utilize Python and matplotlib to analyze supply chain data, including charts showing the distribution of donors, volunteers, suppliers, and more.
- Real-time Monitoring: Create alerts for proactive mitigation of food shortages and monitor food inventory in real-time.
- Documentation: Detailed documentation is provided to explain the database schema, data generation process, and data analysis.
- Clone the repository:
git clone https://github.com/Ziad-Algrafi/Supply-Chain-DB-for-Al-Haram-Suffra.git
- Install dependencies:
pip install -r requirements.txt