This is the group assignment of the course Databases (AUTh, Department of Electrical and Computer Engineering - 9th semester). The goal is to create a relational database.
Our team designed a relational database that would support a hiking application. The main function of the application would be to provide information about hiking routes, trails and refugges in Greece. Furthermore, a user could create an account to book an excursion with a certified guide of the app. Additional functionality of the database includes informing the hiker about the necessary equipment for a certain route
Database model in MySQL Workbench format.
SQL script that contains the dump for creating the database (tables, constraints, inserted data, views).
SQL script for creating the users of the database and their rights.
SQL scripts that include queries to the database.
Database model diagram as a png file extracted from MySQL Workbench.
Report of the assignement in Greek.
Team 25, Databases, December 2020
Zoi Bontsiou
Chrysoula Moschou
Christina Sakka