kirengaaime04-boop/Database-assignment-27345

Rwanda revenue authority database design & queries *Student Name:* KIRENGA Aime Jules *Student ID:* 27345 *Course:* Database Management Systems (DBMS) - PostgreSQL *Institution:* Adventist University of Central Africa (AUCA) ## Project Overview This repository contains the complete relational database setup and analytical queries for *REVENUE_ADMINISTRATION_DB*, designed for the Rwanda Revenue Authority (RRA). The database models 20 interconnected entities including taxpayers, tax centers, officers, registrations, declarations, assessments, payments, penalties, audits, refunds, enforcement cases, properties, vehicles, and revenue targets. ## Repository Structure * 01_tables.sql: Contains the Data Definition Language (DDL) scripts for table creations, primary keys, foreign keys, check constraints, unique constraints, and cascade delete rules. * 02_records.sql: Contains sample data insertions for all 20 entities ensuring relational integrity. * 03_queries.sql: Contains the 20 complex analytical SQL queries incorporating INNER JOIN, LEFT JOIN, RIGHT JOIN, GROUP BY, and HAVING filters. * screenshots/ - A folder containing screenshots of the table creation outputs and all 20 query results. ## Execution Order To execute the project cleanly without foreign key constraint errors, run the files in the following order: 1. 01_tables.sql 2. 02_records.sql 3. 03_queries.sql