A small SQL project demonstrating database design and analysis skills, built in MySQL Workbench.
The database models a fictional library that contains detective novels from Agatha Christie (Poirot & Marple) and Arthur Conan Doyle (Sherlock Holmes).
It includes:
- Relational schema with foreign keys and check constraints
- Seed data (18 books, 8 patrons, 9 loans)
- Views for book availability, patron activity, and series counts
- Analysis queries using joins, GROUP BY, CTEs, and window functions
- An ERD diagram