Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
