Start Workbench $$ you do not need to connect to a server for this assignment. After Workbench starts, click on the diagram icon in the left and then click on plus sign after the word Models. This will create a new model for your database. Double click the mydb name that appears next and rename it game reviews. Then double click on the diagram icon at the top to begin creating your game reviews model ERD diagram as demonstrated in the Lecture Videos for this module.

Step $2$:

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 Crow$$s Foot lines to show the type of relationship between your tables as well as the appropriate cardinality based on your readings this week.

Next week you will normalize this simple database and creating additional tables if necessary, but for now, your assignment is complete. Take a screenshot showing your $3$ tables with the relationship and cardinality in place and submit for grading.