Skip to content

Latest commit

 

History

History
44 lines (25 loc) · 2.12 KB

README.md

File metadata and controls

44 lines (25 loc) · 2.12 KB
Raw

💻 Project: WorldCup Database

Worldcup banner

Project goal:

Create a Bash script that enters information from World Cup games.csv file into PostgreSQL, then query the database for useful statistics.

Project made as part of the FreeCodeCamp Relational Databases Beta Certificate course

Creating the database

Dataset: games.csv

Created the database, 'worldcup', and the appropriate tables ('teams' and 'games') on PostgreSQL to visualise the data from games.csv.

Added appropriate constraints (primary keys and foreign keys) required to relate the tables.

Tables:

  • 'games' tracks all matches and scores made by both the winner team and the opponent team (using team_id as the identifier).
  • 'teams' lists all teams that played in the matches.

View: initial_tables_creation.sql

Relational Database diagram

worldcup diagram

Automating data insertion and querying with SQL

Created a Bash script that reads the games.csv data and uses SQL query commands to insert the data automatically into the tables previously created.

Took constraints into consideration when creating the Bash script to insert all winner and opponent teams individually into 'teams' and then into 'games' based on the team_id created.

View: insert_data.sh

Finished by writing a Bash script that utilises SQL to query the database and obtain useful values.

View: queries.sh

Database dump (after inserting data): worldcup.sql