e-hotels
a hotel booking system for guests and front-desk staff, built as part of a database course.
e-Hotels is a booking system for a group of hotel chains. Customers search for rooms and book them. Staff look after the other side: check-ins, walk-in rentals, and managing hotels and rooms.
It started as a database course project, where the point was to design a proper relational model and build something real on top of it.
I worked across the stack in a team of three. I built screens for both customers and staff, wrote the typed API layer that sits between the Next.js front end and the Flask back end, and built the room search with its filters.
I also spent a lot of time resolving integration issues between the frontend and backend, including schema mismatches, credentials, and rendering bugs.
The database does real work: triggers and views keep availability and capacity honest, so the app doesn't have to re-derive them. The room search waits for you to stop typing before it asks the server anything.
I would define the API contract before writing either side. We found most of our bugs at the boundary, and agreeing the shapes first would have saved most of them.