How do I get a platform specific release date, or a box shot for a game?
I guess there is a games table and a platforms table joined by a many-to-many joiner table. This normalisation is efficient, but it raises a couple of issues. Game data that is platform specific is stored in the games table, and is consequently lost. Some games have different release dates on the PS3 and Xbox 360. They also have different box shots. The way the data is modelled at the moment does not allow for this flexibility.
Am I missing something? Is it possible to get platform specific release dates and box shots?
Log in to comment