Bank Database made in SQL
-
Updated
Aug 20, 2020 - PLpgSQL
A CSS Reset is used to remove the default browser styling and make the website look same on all browsers
Bank Database made in SQL
DBMS project on Online Pharmacy/Medicine Store Management
A PostgreSQL library system with automated stock management, reporting views, and audit logging. Designed to enforce data integrity, handle multi-author books, and support real-world loan workflows efficiently.
SocialBook Database made in SQL, with comprehensive documentation.
Airbnb clone database: complete PostgreSQL/MySQL schema, normalization (3NF), advanced SQL queries, indexing, and partitioning strategies
Community reforestation management system — relational database design and implementation
A normalized PostgreSQL database for a travel agency: data-integrity constraints, analytical views with window functions, data-quality checks, and CI-tested.
This project is a clean, production-ready database built for pharmaceutical factories. It uses PostgreSQL to automatically track raw materials, handle expiry risks, and manage safe product recalls. With smart automation built right in, it keeps data accurate and ensures strict quality standards without messy manual updates.
Databases with PostgreSQL - 2nd Semester
Relational database design and implementation for a coffee shop case study using PostgreSQL, including normalization (up to 3NF), views, and materialized views.
A PostgreSQL-based relational database system for a music streaming platform featuring BCNF-normalized schema design, analytical SQL queries and business intelligence reporting.
A real estate database management system developed from scratch: Relations brought into BCNF, database tested with complex queries, and appropriate triggers implemented.
DB design + normalization + SQL for A/B testing
A database design project simulating a national coffee shop chain's data infrastructure. Demonstrates schema normalization, ER modeling, SQL scripting, and cross-database integration using PostgreSQL and MySQL.
A PostgreSQL database project to manage healthcare appointments, prescriptions, and medications.
Hands-on PostgreSQL projects covering SQL fundamentals, joins, window functions, database design, performance tuning, and data preparation for AI/ML — 19 self-contained projects organized by skill level.
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, database management, and analytics projects including schema design, complex queries, and performance optimization.
database modeling, normalization, fragmentation, testing data service application for postgresql