This repository contains a database project focused on the UEFA Champions League. The project is part of the coursework for the Databases unit.
The project is organized into the following components:
Two SQL scripts are provided for creating the database structure and populating it with initial data.
The database is designed with the following UML structure:
A directory containing 10 example queries is provided to facilitate testing and exploring the database.
The triggers directory includes a set of 3 triggers,, each consisting of three files:
triggerX_add.sql: Creates the trigger.triggerX_remove.sql: Removes the trigger.triggerX_verify.sql: Tests the trigger.
To set up the database, execute the create.sql script followed by the populate.sql script. The provided queries and triggers can be used to interact with and test the database.
For detailed insights into the project, please refer to the Report.