Premier_League_Database

Project Overview

This is a university course project involves designing a relational database for managing data related to the English Premier League. The database includes tables for players, teams, matches, positions, and more. This project uses MySQL Workbench for database design and management.

Features

• Data Modeling: Includes an Entity-Relationship (ER) model representing the league structure.
• Database Implementation: SQL scripts for creating tables, inserting data, and querying the database.
• Views: Custom views created for easy querying of complex data.
• Functions and Procedures: Includes custom SQL functions and procedures to handle common database operations.

Tools Used

• MySQL Workbench: For designing the ER model and implementing the database.
• SQL: Used for all database interactions.

How to Use

Please create tables in the following order:

stadiums
nationalities
teams
coaches
positions
players
player_positions
referees
matches
matches_participation