Designed and Developed a comprehensive Database Management System for a modern Pharmacy.

A case study about designing simple database system for a bookstore. This repository contains ERD design and SQL codes for design of bookstore database system. The main purpose of this system is to build database system for bookstore.

3NF-normalize Yelp data on S3 with Spark and load it into Redshift - automate the whole thing with Apache Airflow

Program which normalize relation scheme to 3NF.

A tool for database analysis

In this project, we are designing the database for the Graphics Design School named ‘Nexus’. A proper methodology of database systems has been followed starting with designing an ER Diagram for the database till the normalization of the schema till 3NF.

Valorant Esports Tournament Ecosystem: 3NF Database + FastAPI + React. Analyze VCT player stats, agent metas, and tournament history through a professional dashboard and interactive SQL query runner

Designed and implemented an end-to-end ETL pipeline using PostgreSQL, transforming raw transactional data into a normalized OLTP schema (3NF) and analytical OLAP star schema. Generated business insights through complex SQL queries and ensured data integrity through validation checks.

This was a semester-long project in which we were given a description of a database that a client needed. We then went through the process of creating a conceptual EER model, then refined it into a relational model, then converted the relations into 3NF, and then actually created the sql statements with triggers. We also created queries and views.

SchemaForge Studio | Professional database engineering showcase for Khulisa Commerce. Features 3NF schema design, advanced T-SQL (Stored Procedures, Analytics Views, Window Functions), NoSQL (MongoDB), and CI/CD automation with real-time SQL integration testing.

Учебный проект по курсу “Системная аналитика DWH”, онлайн-школа T1

A comprehensive, 3rd Normal Form (3NF) relational database design for an online retail platform. Includes SQL schema, automated setup scripts, sample data, and analytical views for e-commerce business intelligence

A professional SQL Projects Portfolio showcasing enterprise-grade database designs (3rd Normal Form), complex analytical queries, and real-world data visualization. Includes comprehensive projects for Airline Reservations, Online Retail, COVID-19 Analytics, and Hospital Management.

This is a database that stores information about car brands and models. The database has been normalized to comply with Third Normal Form (3NF), and its data is made available to users through a small web application.

The System designed in 3NF, comprises entities such as Guests, Rooms, Bookings, and Updates. It optimally organizes guest reservations, room availability management, payment handling, and improves customer experience with real-time updates and personalized services.

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

A complete, production-ready database schema for an AirBnB. Features a fully normalized (3NF) PostgreSQL design with UUID primary keys, comprehensive constraints, sample data, and detailed documentation. Includes tables for users, properties, bookings, payments, reviews, and etc. with proper foreign key relationships and business rule enforcement.

SQL file for HouseBoat Mnagement System-Normalized-All features-Queries

Conception et implémentation d’une base de données immobilière : modélisation (MCD/MLD), dictionnaire de données, chargement des tables et requêtes d’analyse.

A toolset for database analysis as bottom up approach