It is a Hotel Management System that developed with Django - Python. Database tables have been created according to normalization rules.

A tool for database analysis

A PostgreSQL-based Freelancer Marketplace Database System designed using ER modeling, Functional Dependencies, BCNF normalization, and advanced SQL analytics.

Hybrid database management system for the Abyssinia Grand Hotel using MySQL and MongoDB for dynamic guest profiling.

Production-grade REST API for a hyperlocal service marketplace — 23-table BCNF-normalized PostgreSQL schema, 19 endpoints with advanced SQL, Stored Procedures & Triggers

General Information

Developed a program that Generates SQL Statements to Check Normalization in One Table and Normalize It If Needed. [Python and PostgreSQL]

A toolset for database analysis as bottom up approach

SQL Assignments from CSC 453

This repository contains the Assurance of Learning (AoL) Group Project by Jonathan et al. for the Database Technology course (COMP6799001). The project received a high distinction with a score of 100 (Grade: A).

Takes Database and Functional dependencies as Input and checks Normalization form and converts up to BCNF.

PostgreSQL rental search and analytics platform with normalized schema design, SQL workflows, stored procedures, triggers, indexing, and Tableau-ready queries.

A normalized MySQL database system for managing, analyzing, and tracking phishing email datasets. Features ER modeling, 3NF/BCNF normalization, SQL queries, PL/SQL automation, user reporting, blacklist management, and phishing trend analysis.

A driver program to decompose a relation with violating functional dependencies into BCNF

Seminar task from college subject SQL Practicum. App that finds primary key candidates and handles database normalization - decomposition to Third Normal Form and Boyce-Codd normal form. 🔑

SQL database schema normalizer (3NF && BCNF)

Foodie_Table

IoT-enabled health monitoring system with MySQL — BCNF schema, query optimization (85% faster), and ACID transactions