Tech Stack
MySQL
ER Modeling
SQL Queries
Overview
This project implements a relational database for a public library. It includes entity-relationship modeling, constraints, and SQL queries to handle borrowing, membership, fines, and reporting.
Features
- Relational schema with 15+ tables and foreign key constraints.
- Queries for borrowing and returning books.
- Membership and fines management.
- Reporting and insights from library data.