Now that you understand the keys and how to normalize a database so that it meets the criteria for up to $4$NF$,$ it is time for you to do the same with games review database ERD you began creating last week in MySQL Workbench. Open your saved work from last week and normalize your games review ERD database to at least $3$NF $($but you may need to take your normalization one step further to $4$NF as shown in the Tutorial Video for Module $3).$ Be sure you include primary, foreign, composite, and compound key notation in your tables as necessary to create a normalized database. As you complete your assignment, remember the main benefits for normalizing a database are:

Eliminate Redundant Data

Reduce Modification Anomalies

Ensures Dependencies are Logical

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