Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Comparative International Accounting

Authors: Christopher Nobes, R. H. Parker

6th Edition

0273646028, 978-0273646020

More Books

Students also viewed these Accounting questions