Please help me with a micorosft access Database assignment. I$\text{'}$m supposed to create an entity relationship diagram using crows foot notation. here is my current database. For my idea I$\text{'}$m planning on creating a database that manages the numerous winners of the Game

Awards over the past $4$ years and I chose this idea because of my passion for gaming. I want my project

to be able to be sorted by the game's manufacturer's $($e$.$g$.$ Microsoft, Sony, Nintendo$),$ what category

they received the award in $($Best Gameplay, Best Soundtrack$),$ the game genera $($RPG$,$ fighting game$),$ and

obviously the game's name.

Here is the resulting potential database.

Game Information $($GamelD$,$ GameName, ReleaseDate, Developer, Publisher, Genre, Platform$)$

Award Table $($AwardID$,$ BestGameYear, BestRPG, BestAction, BestFighting, BestStratagy, BestRacing,

BestMultiplayer$)$

Nominee Table $($NomineelD$,$ GameID, AwardID $,$ Year, Manufacture, AwardCategory, Genre, Winner$)$

FK $1.$ GameID $($references Game Information$)$ FK $2.$ AwardID $($references Award Table$)$

Winner's Table $($WinnerID$,$ NomineelD, WinnerYear, AwardID, GameID, AwardCategory, Result, Winner$)$

FK $1$ NomineelD $($references Nominee Table$)$ FK $2$ AwardID $($references Award Table$)$ FK $3$ GameID

$($References Game Information$)$