Week 3
(June 6th - June 10th)
The last queries from last week's source were ran this week. These allowed the breakdown of our previous tables to create more tables with clearer descriptions of the over a million game events studied. The large amount of information in the new table required much more time for the execution of queries used to populate the new tables. This week's next task was to create a visual and appealing representation of the some of the information currently in the database. This meant creating a graphical user interface that allowed the querying of the information organised in the database and visually displaying the query results in various graph for easy interpretation. The main query information was about the outcomes (success and failure) of each shots made by each player and/or each team in all its games yearly or over the seasons. The graphical user interface allowed the querying of each team by player and by year in order to view the shots made and those missed as wells as the distance at which each shot was made.
Two types of distances were considered: an (x, y) distance with respect to an origin (0,0) and an angular distance (r, Θ) with respect to the hoop. These were working at the end of the week.
Two types of distances were considered: an (x, y) distance with respect to an origin (0,0) and an angular distance (r, Θ) with respect to the hoop. These were working at the end of the week.