if you use the genrename as foreignkey in game-genre, you can store the genrename in game table and drop the game-genre table. but if a game can have multiple genre(fantasy-strategy) you should use the ids in this table.
same with the game developers publishers table, or will one game have multiple dev-publusher combinations?
the game-to-console table you can keep, but please use id instead and name and title.
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.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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.