database-normalization

Repository of a Final project in Software Engineering Course to build an API system via web that manages local university clinic data automatically

📊 Analyze and correct data models for university libraries with an interactive dashboard, showcasing errors and delivering optimized SQL solutions.

Oracle SQL normalization notes in PDF format covering database normalization concepts and normal forms.

Normalisation in Relational Model Visualiser

A collection of database management scripts and interactive shell programs built using PostgreSQL and Bash. Includes robust ETL pipelines, querying tools, and terminal-based applications.

A relational database designed and implemented in Oracle SQL for a car rental business management system, featuring 17 normalized tables (3NF) and 10 complex operational queries.

SQL Server data analysis project

A relational database system in Oracle SQL for managing parking areas, vehicles, slots, and fees — includes table design, normalization, and analytical queries.

Five relational database design projects created from business requirements, covering ERD modeling, relational schemas, normalization, keys, and database relationships.

Desktop restaurant POS system (JavaFX + MySQL) with full UNF to 3NF database normalization. Group final project for Database Technology at BINUS University.

A production-ready MySQL 8.0 database for a multi-seller E-commerce Marketplace. Features advanced SQL (Window Functions, CTEs), ACID transactions, database programmability (Procedures/Triggers), and performance index tuning.

Database Normalization — independent third-party profile of a public API surface, by API Evangelist. Database Normalization is the formal process of structuring relational schemas to reduce redundancy and avoid update, insert, and delete anomalies. It is governed by Codd's normal forms (1NF through 6NF) and the Boyce-Codd Normal Form, and is the fo

A comprehensive, theory-driven and practice-oriented journey from SQL and database fundamentals to advanced MySQL, database design, normalization, transactions, ACID, indexing, query optimization, MySQL internals, security, backup & recovery, scaling, replication, and SQL vs NoSQL.

A comprehensive database design and normalization case study (UNF to BCNF) for JEMARI, a fictional mental health consultation app, developed for the COMP6799001 – Introduction to Database Technology course.

Full-stack pharmacy inventory system; normalised PostgreSQL database (behind a Flask app) with authentication, live low-stock alerts, and full CRUD.

Production-ready relational database schema architecture and storage optimization engine for StreamPulse Media digital cataloging.

SQL database design for an online retail application including ER diagram, schema, normalization, and queries.

An intelligent tutor for database normalization to 2NF, built with CTAT. LearnLab Summer School 2026.

HackerRank and LeetCode practice

A RESTful API for a personal blogging platform, with full CRUD operations on posts, categories, and tags, plus search by term. Built as a practice project to reinforce MVC architecture concepts, database normalization, and REST API design best practices.