Frontdesk - Hotel Management System

Assignment 4
By Liam Duncan and Cam Della-Savia
For SE3309 Databases


This assignment was functionality focused - no time was spent on aesthetics.
Short time frame to complete for submission.


Liam - > Frontend + API
Cam -> sql queries in backend


Assignment only wanted 5 functionalities to the user. We provided:

  • Guest Name Search (first, last, city)
  • Adding Guests to database
  • Currently Checked In Guests by ID (including order by options)
  • Room Lookup (by multiple optional details + price range)
  • Booking Search (including order by options)

Built With

Share this project: