Hotel Booking Database

A custom database was designed using SQL for a fictional hotel to allow management of bookings, promotions, and certain operational elements. Both terminal and graphic programs were created to interface with the database. Appropriate permissions within the database allowed for access control to limit employees to making changes according to their position.

24 tables were used to implement this, normalised to BCNF to prevent data anomalies. Records are stored for customer management with payment and invoice, comprehensive bookings, room service, and ammenities. Rates for all of these, with support for promotions is provided. Room management with key-code access management functionality is provided.

A terminal user interface was created using Bash script. The graphic user interface was developed using the Microsoft .NET MAUI application for cross-platform compatibility. Full functionality was demonstrated in initialising, modifying, and querying the database.