This repository contains an academic project developed for UMinho's Databases 2025/26 class. The goal of the project was the design and implementation of a relational database system for a travel agency, aiming to support the virtual cataloging of customers’ trips.
The project follows a complete database development process, including requirements analysis, conceptual modeling, logical modeling, normalization, and physical implementation using MySQL. All project documentation and deliverables were produced in Portuguese.
The developed database system aims to support the growth and modernization strategy of a travel agency by providing a structured and centralized platform for the virtual cataloging of real customer trips.
The system supports:
- Structured storage and organization of trips shared by customers, including descriptions and related content
- Creation of a centralized travel catalog that allows users to browse real travel experiences and discover destinations
- Representation of users, trips, and publications, enabling interaction and content sharing
- Reduction of information loss and duplication by replacing informal and unstructured data collection methods
- Validation of the database design through relational algebra queries and normalization up to the Third Normal Form (3NF)
This database system serves as a technological foundation for enhancing customer engagement and supporting the agency’s potential national and international expansion.
The conceptual model was developed using an Entity–Relationship (ER) diagram, representing the main entities of the system and their relationships.
The ER model was transformed into a relational logical model, normalized up to the Third Normal Form (3NF) to ensure data consistency and minimize redundancy.
The logical relational model was translated into a physical database schema and implemented using MySQL.
The SQL scripts used for the database creation and population can be found in this repository.
- Gabriel Lima de Faria, a111532
- Rui Pedro Ferreira de Jesus Gomes, a111273
- Ricardo Machado Rodrigues, a111225
- João Pedro Faria Martins, a111014