SQL Assignment
Individual Assignment 2: SQL Overview The purpose of this task is to develop student’s skills in designing and implementing a relational database for a given case study. Assessment Details Major League Soccer (MLS) [1] is a men's professional soccer league played in the United States. It is equivalent to European (and South American) football. The league comprises 24 teams — 21 in the U.S. and 3 in Canada. There are many games played in each season by many teams. You can find the details of the team names and home locations listed at this Wikipedia page: https://en.wikipedia.org/wiki/2019_Major_League_Soccer_season You are part of a SPORTS PERFORMANCE team and you currently gather the following information: - Video footage of each game – several frames per second, and recorded and stored in MP4 format. - GPS track logs of each player for each game, including the three referee s...