Claudemuremyi/Advanced_Database_Technology

This is a complete PostgreSQL database system for a SACCO (Savings and Credit Cooperative) operating in Rwanda. The system manages member profiles, loan accounts, insurance policies, claims, and payments across multiple branches in Rwanda. # Advanced Database Technology - Course Projects ## Overview This repository contains comprehensive database projects demonstrating advanced database concepts including: - **Relational Database Design** (CAT 1) - **Parallel and Distributed Databases** (ASSIGNMENT_3) - **Intelligent Databases** (INTELIGENT DATABASE) - **Advanced Database Exam** (ADVANCED DATABASE EXAM) All projects are implemented using **PostgreSQL**. Most projects use a **SACCO (Savings and Credit Cooperative) Insurance and Member Extension System** context in **Rwanda**, while the exam project uses a **Restaurant Order and Billing Management System**. --- ## Repository Structure ``` Advanced_Database_Technology/ ├── README.md (This file) ├── CAT 1/ (Relational Database Fundamentals) │ ├── README.md (CAT 1 documentation) │ ├── Queries/ (SQL scripts) │ └── Screenshoots/ (Screenshots and documentation) ├── ASSIGNMENT_3/ (Parallel and Distributed Databases) │ ├── README.md (Assignment 3 documentation) │ ├── Code/ (SQL scripts and README) │ ├── Screenshoots/ (Task screenshots) │ └── [Report files] ├── INTELIGENT DATABASE/ (Intelligent Database Concepts) │ ├── README.md (Intelligent Database documentation) │ ├── [Task SQL files] │ └── Screenshoots/ (Task screenshots) └── ADVANCED DATABASE EXAM/ (Database Exam - Restaurant System) ├── README.md (Exam documentation in restaurant-db-exam/) ├── restaurant-db-exam/ (Main exam project with README) ├── RESTAURANTDB/ (SQL scripts) ├── Screenshoots/ (Task screenshots) └── [Report files] ``` --- ## Project Components ### 1. CAT 1 - Relational Database Fundamentals **Location**: `CAT 1/` **Description**: Implements …