Skip to content

⚽️ | Champions League Database: Automated Population & Trigger Testing Suite

Notifications You must be signed in to change notification settings

Davide64-dev/FEUP_BD_ChampionsLeague

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

A Database for the UEFA Champions League

Overview

This repository contains a database project focused on the UEFA Champions League. The project is part of the coursework for the Databases unit.

Project Structure

The project is organized into the following components:

Create & Populate

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:

Alt text

Queries

A directory containing 10 example queries is provided to facilitate testing and exploring the database.

Triggers

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.

Usage

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.

Other Information

For detailed insights into the project, please refer to the Report.

About

⚽️ | Champions League Database: Automated Population & Trigger Testing Suite

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published