SQL-based business analytics and aggregation queries on the Chinook PostgreSQL database using joins, subqueries, and grouping.
-
Updated
May 17, 2026
SQL-based business analytics and aggregation queries on the Chinook PostgreSQL database using joins, subqueries, and grouping.
Academic Materials – Semester 4 | Part of the Cosmos Vault multi-semester collection.
B+ tree index implementation in C using block-based storage, supporting efficient insertion and search operations
Flask + SQL library app (NYU Principles of Database Systems): member loan history and live copy availability on PostgreSQL or SQLite
A Database Systems semester project that replaces manual Excel brackets with a centralized, automated MS SQL Server database system. Features a PyQt5 frontend, automated bracket progression, role-based architecture, and email OTP verification.
Second Year undergraduate repository containing modules, labs, tutorials, coursework, and learning materials covering OOP, Databases, SDGP, Client-Server Architectures, Server-Side Web Development, and Advanced Client-Side Development.
Extended toyDB database system implementing page buffering, slotted pages, and bulk-loading index construction in C.
Contains all codes and reports for CS3700 - Database Systems course taught by Prof. P Sreenivasa Kumar during Jul-Nov 2021
SQL database design project for restaurant and bar operations including ER modeling, normalization, schema design, and query implementation.
A Relational Database for the project of the class "Database Systems" 2024-2025
Lab assignments completed for Introduction to Database Systems (COEN 178)
Priority-aware load balancing, resource allocation and failure recovery for replicated database services.
"Registry Database" is an hierarchical key-value storage engine like Windows registry editor featuring client-server architecture, strict data typing, and real-time synchronization.
Database Systems Project
The project involves creating a Hospital Management Database with tables for Patients, Doctors, Appointments, Medical Records, Prescriptions, and Inpatient Admissions.
An open-source, less cloud-dependent, secured, and private database system designed primarily for small- to mid-sized local organizations and government units in digitizing their services and records one at a time without compromising data ownership and avoiding cloud-related shutdowns.
SQL data warehouse implementation using star schema design for retail analytics with dimensional modeling and BI queries
To associate your repository with the database-systems topic, visit your repo's landing page and select "manage topics."