[ uniten academic project — full stack web development ]
one book, multiple authors, multiple categories — built the system that keeps track of all of it.
bookstores managing large collections need to track books, their authors, and categories — but these relationships are complex. one book can have multiple authors and belong to multiple categories simultaneously.
a laravel-based bookstore management system with secure authentication, full crud for books, authors, and categories, many-to-many relationships managed via pivot tables, and a reporting dashboard showing total books, authors, and categories at a glance.
used laravel pivot tables to handle many-to-many relationships cleanly — a book can have multiple authors and categories without duplicating data. built a reporting dashboard so admins can see the state of the database without running manual queries. protected all routes behind authentication.
tackles a more complex relational database scenario than a simple one-to-many — many-to-many relationships with pivot tables are a common real-world requirement. demonstrates auth-protected routes, dashboard reporting, and multi-entity crud in one system.
6
database tables including 2 pivot tables
2
many-to-many relationships managed via Eloquent
0
unprotected routes — nothing accessible without authentication
dashboard
book management
author management
category management
