Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Our database will start with 3 tables. Create the games table, the reviewers table, and the reviews table. Each table will have multiple fields included.

Our database will start with 3 tables. Create the games table, the reviewers table, and the reviews table. Each table will have multiple fields included. Please create the fields as shown below:
Table Name: Games
Add the following properties (fields) for the Games table:
gameId
gameName
gameDescription
gamePlatform
gameGenre
Table Name: People
Add the following properties (fields) for the Reviewers table:
peopleId
peopleFirstName
peopleLastName
peoplePlatform
peopleRegion
Table Name: Reviews
Add the following properties (fields) for the Reviews table:
reviewId
reviewGameId
reviewPlatform
peopleFirstName
peopleLastName
reviewRating
Once your tables are created, then set up the relationships. As you create the tables, think about how each table will be related to one or more other tables using the following general rule of our database:
One reviewer can complete many reviews, and one reviewer can review multiple games.
Use the above rule to set the relationships between your tables and include the appropriate Crows Foot lines to show the type of relationship between your tables

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions

Question

What are three myths about mindfulness?

Answered: 1 week ago