Jay Ellsworth

In your CSS, is the same style that's being applied to kulturnat-box also being applied to rosenfeldt-box?

Hello, Long-time reader, first time posting. I got my bachelor's in software development a few years ago now and my courses were all online. I didn't know any of my classmates, communication wasn't great and getting help from the instructor involved emailing your question, waiting like a day, getting part of it answered, ask follow-up questions, wait a day. Rinse and repeat. I got through my homework each night largely due to the information I found on w3schools.com. There were others of course, but w3schools was a staple for me. I've always liked how it's laid out and how things ar

Oh ok, you're right and I see what you're saying now. Game to GameTag for example is one-to-many so GameTag has GameID as a foreign key, that makes sense. I had it in my head that the columns had to exist in both tables for some reason. I understand composite keys like you're saying, but I didn't realize that would help with searching, I just want it to be designed correctly and run well. I will take your advice and get each of those changed to use composite keys instead. Thanks for the reply, I appreciate the help

No they're not left overs, the GameTag and GamePlatform tables are the intermediary tables to satisfy the many-to-many relationships between Game and Tag and Game and Platform respectively. They both contain their own ID and both foreign keys of the tables they connect. They just don't look necessary because my relationships aren't visible. I could do a composite key like you're saying, but as-is I have a dedicated ID for each table for uniqueness.

Perfect! Ok, so for this first post there are basically 5 tables: Game Tag Platform Developer Publisher Two of which have many-to-many relationships with the Game table, so each of those two have intermediary tables: GameTag GamePlatform The Tag table is a combination of genre's and all the other descriptors that we use to describe games that aren't genre's, things like Open World, Co-op and Sandbox. Actual genre's will bubble to the top. And bear with me please, I realize some portions of development get farmed out to other developers and

Hello, I'm a newbie developer and I'm just wondering if these forums would be an appropriate place to post the designs for a database I'm working on? I'm working on a site that people can use to keep track of their game collection. It's the first database I've designed entirely by myself and I'm looking for a place to post it so I can get some feedback on it. I see there's a thread for posting finished sites, is there a similar thread for databases? Thanks, Jay