Designing a table to catalog your collection of games

Create a table in a database to catalog a collection of games.  Clearly you could develop a far more sophisticated table, I am giving you a basic design that you can use or you can expand upon it. If you fallow my model, the fields you want to carry on each record in your database table should be:

• the game id

• the game name

• the developer

• date released

• the genre (sports, education etc)

• the platform (PC, playstation etc)

• mode (1 player or multi).

If you want to design your own table, then you need to give me a layout and then implement that layout. You should create the table and populate it with at least 10 records.  Be sure to have the same developer a few times, and the same genre, platform (you can come up for codes that indicate multi platforms if you want to), mode etc.  In populating with data, look at the queries I want you to do and make sure that you have data that will give meaningful results when the query is done.

Queries:

1. Do a query to show game id, developer, date released for a particular developer.

2. Do a query to show all of the fields for a particular developer and a particular genre

3. Do a query to show all of the fields for two tests that are in an OR relationship (for example a particular platform OR a particular mode).

4. Do a query to show all of the fields for a particular developer AND either (a particular platform or a particular mode)

5. Do a query to show all of the fields for a particular developer and a particular platform OR a particular genre