This project is the product of my work in the programming with data module of my MSc in Data Science. We were tasked with requirements for a database to store data about teams, players and other entities from the 2022 World Cup in Qatar. First I began with creating an Entity Relationship Diagram to represent the database that I was going to build. Using MySQL I then had to create a database, create the tables, and populate those tables and then create SQL queries to answer questions about the data, and implement this also using python.
See the below overview of the files present in this repo:
- FIFA World Cup Project Report - This gives a description of all of the actions taken to complete the project
- createdb.sql - This file contains all of the queries that were used to create the database in MySQL
- queries.sql - This file contains all of the queries that were used to query the data to answer the questions about the data in the database.
- pythonsql.py - This file contains the python implementation of the SQL queries from
queries.sql