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;
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (2)
I know it's a late response but thank you so much for the feedback! I went back through and did what you said and switched to using ids for all of my foreign keys. For my game-genre and game-dev-publisher tables, there's games with multiple genres like you mentioned and games with different dev/publisher combinations so I updated the keys but ended up leaving the tables.