My Role: Project Lead & Backend Architect
As the team leader of a 6-person development group (managing frontend, backend, and technical documentation specialists), I directed the project roadmap while handling backend infrastructure and data engineering.
Figure: Database Schema.
Architecture & Implementation
What I provided in the project:
- Database Schema Design: Through multiple iterative revisions, I architected and finalized a comprehensive relational database schema. The design efficiently tracks complex, overlapping data points including physical book inventory, student borrowing and lending lifecycles, active bookmarks, and historical user data.
- Backend Logic & Synchronization: Engineered the core business logic required to bridge the user interface with the database. I wrote the migrations, developed the seeders for testing, and ensured that all state changes in the database were accurately and instantly reflected on the live website.
- Role-Based Feature: Implemented the backend security and routing logic to seamlessly accommodate both user types, ensuring facilitators had secure administrative control over the booking system while students are able to borrow and bookmark books easily.
Results & Insights
The project was a success — we were able to pass it in time. We were able to test and add extra features like adding books with images and database event schedulers. I learned a lot about how a website and database connect to each other. I was fascinated by how every action could be stored in the database and then reflected on the website.
Website Showcase
