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 limiting the scope. 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).
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:
- Do a
query to show game id, developer, date released for a particular
developer.
- Do a
query to show all of the fields for a particular developer and a
particular genre
- 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).
- Do a
query to show all of the fields for a particular developer AND either (a
particular platform or a particular mode)
- Do a
query to show all of the fields for a particular developer and a
particular platform OR a particular genre