Database and UI for a hotel service.

Semester project for Databases course, 6th Semester 2021 of the Electrical and Computer Engineering School at the National Technical University of Athens.

In this project my partner and I created a database for covid-19 contact tracing at a hotel, ran some queries on it, and developed a simple UI to interact with it.

Relational diagram

We used Microsoft SQL Server to create our database. Code for creation of tables and constraints is in the file hoteltables.sql, while code for each table specifically is in the tables folder.

Mock data for the database can be added by running the file insertEverything.sql.

The files createViewCustomers.sql and createViewService.sql create two views for the database as instructed.

To connect with the database we use sql authentication so creating a user is necessary. The connection is done by XAMPP with included mssql-php configuration files.

The website is hosted locally, and its code is in file index.php. In lines 34-35 the details of the user created earlier must be added.