-
Nischol Antao authored
Modified local programs to output csv data. Measured the amount of time each query took on a local pc. Started a document for Challenges_Encountered
Nischol Antao authoredModified local programs to output csv data. Measured the amount of time each query took on a local pc. Started a document for Challenges_Encountered
Challenges_Encountered.txt 757 B
Challenges
I] Question 1
a) Had to clean up data for Players whose country of origin was unknown in the database.
This was especially true for years before 1912
II] Question 2
a) There was incorrect data in the Salaries.csv file, in the teamId field, for the Year 2016,
for some of the teams in the database. The Entire Database used a fixed convention for teamId,
however this convention was changed for the Year 2016 in the Salaries.csv file. When a database
join was performed between the data in the Salaries.csv file and the Teams.csv file, this resulted
in the salary data for 12 teams being omitted from the results. The data in the Salaries.csv file
had to be manually cleaned to match the convention in the rest of the database to fix this.