Relational Database and Flask Application for NFL Player Querying
Completion: May 2023
I completed this project with a partner for a Columbia University graduate course in Database design and implementation.
Overview:
This relational database is for the National Football League. The database will be used to track the statistics, status, and biographical information of each player in the NFL. This tool will be useful for avid NFL fans, especially for fans who engage in Fantasy Football, a game played over the course of the football season where players create a team of players across the league, receiving points based on the performance of the players they select.
Purpose:
What makes this relational database unique from existing statistics repositories such as ESPN and football reference is that our database will allow for specific queries to be performed, which is not admissible on existing sites.
For example, if I search “NFL players with at least 6 receiving touchdowns in 2022 season”, I will not receive a list of player names with the proper criteria, but rather a comprehensive data table of the receiving statistics for all NFL players, which can be sorted from least to greatest.
Tags: Database Frontend HTML CSS Flask Json SQL PostgreSQL mySQL Data-visualization Teamwork Columbia