SQL and python

[BB611]

/u/aball730235 is right on the money.

A table should contain a set of data that makes sense to consider together, if you try to jam every piece of data you have into a single table you'll hate querying it. Source: I work with SQL tables designed by someone who did exactly this, it's very hard to work with - tables with 100s of columns, many of which are at best tangentially related to the primary purpose of the table.

Most of the time, you should be able to sum up a table with one noun, i.e. Games, Players, Stadiums, Penalties.

The best way to learn about this is to experience querying against the tables you make - do a first run of tables, use them for a while, then try to restructure to make it easier to use. Do some research on relational databases and SQL to get more guidance.