• 

  Welcome Page

• 

  Main Page

• 

  Guest Search

• 

  Guest Entry

• 

  Room Lookup

• 

  Demo Room Lookup Results

• 

  Current Bookings

• 

  Example Results from booking search

Frontdesk - Hotel Management System

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

Note***

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

Roles

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

Functionality

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

• angular2
• express.js
• mysql