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

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

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

General Information

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

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

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

A toolset for database analysis as bottom up approach

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).

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.

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

SQL Assignments from CSC 453

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

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