normalization-3nf

A university-grade DBMS course project featuring a normalized 3NF MySQL database schema, relational ERD, automated triggers, transactional stored procedures, complex viva queries, and realistic seed data.

A university-grade DBMS project featuring a normalized 3NF MySQL schema, dynamic PNR lifecycle engine, automated waitlist-to-confirmed promotion triggers, berth quota logic, ERD, and viva prep kit.

A production-grade DBMS project featuring a normalized 3NF MySQL schema, double-entry financial ledger, customer credit-limit triggers, aging schedule debt analysis, ERD, and viva defense kit.

A university-grade DBMS project featuring a normalized 3NF MySQL schema, doctor roster conflict-check procedures, OPD daily queue token engine, dynamic fee calculations, ERD, and viva defense guide.

A production-grade DBMS project featuring a normalized 3NF MySQL schema, square-footage maintenance billing, amenity double-booking exclusion triggers, defaulter penalties, ERD, and viva defense guide.

A university-grade DBMS project featuring a normalized 3NF MySQL schema, real-time parking slot state machine, dynamic hourly slab tariff engine, overstay penalties, ERD, and viva defense guide.

A production-grade DBMS project featuring a normalized 3NF MySQL schema, flight deck duty-hour limitation triggers (DGCA/FAA), dynamic standby crew rostering, turnaround scheduling, ERD, and viva defense guide.

The goal of this project is to design and implement a database system that efficiently manages patient records and appointment scheduling for a healthcare center. The system stores and organizes essential data such as patient information, physician information, available time slots, and medical treatments.

A production-grade DBMS project featuring a normalized 3NF MySQL schema, RFID copy tracking, progressive tiered overdue fine engine, reservation priority queue, ERD, and viva defense guide.

A production-grade DBMS project featuring a normalized 3NF MySQL schema, automated FIFO batch stock deduction, drug expiry alerts, triggers, ACID procedures, ERD, and viva defense guide.

A production-grade DBMS project featuring a normalized 3NF MySQL schema, blood group compatibility engine, component shelf-life triggers, emergency donor matching procedures, ERD, and viva defense guide.