Answered step by step
Verified Expert Solution
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 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started