BorrowDB4 years ago
completedpublic
BorrowDB is a relational database schema designed for a mobile borrowing platform that allows neighbors to share underutilized possessions, reducing unnecessary purchases. The project implements six interconnected tables modeling users, items, borrowing transactions, and ratings, with complex SQL queries, stored procedures for core operations like item requests and profile summaries, and custom functions for calculating loan durations and updating user ratings.
// meta
role
Solo Developer
status
completed
// highlights
>Designed normalized relational schema with 6 interconnected tables and 8+ foreign key constraints
>Created 9 complex SQL queries including multi-table joins, aggregations, and subqueries
>Implemented 2 stored procedures handling user profile summaries and borrowing transaction workflows
>Developed 3 PL/SQL functions for loan duration calculation and dynamic rating updates
>Populated sample dataset with realistic borrowing transaction records and user ratings
// stack
Oracle SQLPL/SQL
// links