I need help with a task for Microsft Access $.$ I$\text{'}$m attempting to create a table called AwardVotes that tracks the amount of awards a game recieved. This table's fields need to be in $3$rd Normal Form and the fields $($which are all in the short texxt data type$)$ are as follows. The Primary Key is called VoteID, a Forign Key called GameID $($which pulls information about the game from the Game Information table$),$ a Forign Key called PublisherID $($Pulls information from the Publisher table$),$ a Forign Key called GenreID $($Pulls information from the Genre Table$),$ a Forign Key called PlatformID $($which pulls information from the Platform Table$),$ and finally a lookup wizard field that tallies how many awards a game has been nominated for.