Reignmad/Academic-Projects-Hands-on

A fully normalized relational database (3NF) for Khumbulekhaya Stokvel, a South African community financial organization. Built with Microsoft SQL Server—featuring 11 interconnected tables, stored procedures with error handling, performance indexing, and RBAC-ready security. # Academic-Projects-Hands-on A fully normalized relational database (3NF) for Khumbulekhaya Stokvel, a South African community financial organization. Built with Microsoft SQL Server—featuring 11 interconnected tables, stored procedures with error handling, performance indexing, and RBAC-ready security. # 🏦 Khumbulekhaya Stokvel - Database Management System ## 📌 Project Overview This project involved designing and implementing a **fully normalized relational database** for Khumbulekhaya Stokvel, a community-based financial organization registered under NASASA (National Stokvel Association of South Africa). The database centralizes member management, savings tracking, investment portfolios, travel expense calculations, and business/skills repositories into a single, unified platform. **Business Problem:** The Stokvel needed to move from disjointed spreadsheets to a centralized system that could track member contributions, generate reports, and provide real-time financial insights to the executive committee. --- ## 🛠️ Technologies Used - **Microsoft SQL Server** (Database Engine) - **SQL** (Data Definition, Data Manipulation, Stored Procedures) - **SQL Server Management Studio (SSMS)** (Development Environment) --- ## 📊 Database Schema (11 Tables) | Table | Purpose | | :--- | :--- | | `Member` | Stores member personal and contact information | | `Savings` | Tracks individual member savings contributions | | `Investments` | Records investment portfolios and performance metrics | | `Transactions` | Logs all financial activities (deposits, withdrawals, investments) | | `TravelExpenseCalculation` | Calculates travel-related expenses per member | | `ExpenseGapBreaching` | Tracks shortfalls and gap breaches in member finances | | `Trip` | Manages trip requests, destinations, and costs | | `Vehicle` | Stores vehicle availability and trip history | | `InvestmentProjection` | Forecasts investment returns over time | | `Business` | Records businesses owned by member …