bcnf

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

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

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.

General Information

A comprehensive healthcare database system designed using PostgreSQL, featuring ER modeling, BCNF normalization, relational schema design, and SQL implementation.

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

SQL Assignments from CSC 453

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 toolset for database analysis as bottom up approach

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

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

BCNF-normalized 23-table PostgreSQL schema for a service-marketplace platform, with DDL, sample data, and analytical SQL queries covering multi-table JOINs and subqueries.

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