Recently I've been spending some time working with PostgreSQL. While I have had experience building databases within Microsoft Excel, it's been an eye opener to see how everyday sites I use at work and home communicate with an underlying database. As a start to understanding how to build a proper database schema and automate data input into my database, I built a sample database for GameCube/PS2/Xbox games as well as a python script to automate the entry of my dataset rather than writing several insert clauses. I'd love to hear any feedback about how I could improve my schema. The SQL file and python script can be found below for those interested;

https://github.com/Dwayne-Lacey/VideoGameDatabase