TV Games Database Read through the User Stories below.

Create a database that can handle the information as described. Write queries (database questions) that prove that User Stories work with the database.

Create a database that meets these User Stories:

1. As a collector, I want an index of games where I can see their name and genre.

2. As a collector, I want to be able to see which games belong to a certain console.

3. As a collector, I want to be able to see which games belong to a certain genre.

1 = You should therefore be able to ask questions to the database that connects games with a certain one genre and console.

Add the information to the database about games and their consoles and genre, such as described below.

Consoles:

Nintendo Switch, 03/03/2017, Nintendo

PlayStation 1, 1994-12-03, Sony

Super Nintendo, 11/21/1990, Nintendo

Xbox 360, 2005-11-22, Microsoft

Genre

Platformer

Open-World

Arcade

Action

Shooter

RPG

Simulation Nintendo Switch has:

Super Mario Odyssey, Platformer

Yoshi's Created World, Platformer

Zelda: Breath of the Wild, Open-World

Tetris 99, Arcade