A structured relational database for managing detailed information about Olympic Games, including athletes, teams, events, results, and awards.
A Developer’s Journey to Choosing the Right ID Solution
MySQL database design for a pizza restaurant
A database-driven E-Commerce Order Tracking System built using Oracle SQL and PL/SQL, featuring automated triggers, audit logging, and analytical reports to manage orders, payments, and deliveries efficiently.
PostgreSQL database design for a football ticket booking system with ERD, relational schema, and SQL queries.
This is a demo repo for a talk at the PyCon Austria 2025.
Enterprise SQL relational key integrity engine and foreign key bridge audit pipeline for FreightFlow Logistics by Elsamag IT Solutions.
Shows how JDX ORM named sequence generators SEQUENCE / JDXSeqUtil produce persistently unique, application-managed primary key values across application restarts. Uses DeptIdSequence and EmpIdSequence with configurable MAX_INCREMENT and START_WITH parameters.
This project involves designing and building a robust, normalized relational database for an Airbnb-like application. It covers the full lifecycle from creating an Entity-Relationship Diagram (ERD) and applying normalization principles to writing SQL scripts for schema definition and data population
Demonstrating my understanding of SQL fundamentals
A practical reference for designing, building, and maintaining PostgreSQL databases.
To associate your repository with the primary-keys topic, visit your repo's landing page and select "manage topics."