Question: Please help me create an entity relationship that utitilizes crow's feet notation. Each table is supposed to have 7 - 1 0 fields. Here is

Please help me create an entity relationship that utitilizes crow's feet notation. Each table is supposed to have 7-10 fields. Here is the resulting potential database.
Game Information (GameID, GameName, ReleaseDate, Developer, Publisher, Genre, Platform)
Award Table (AwardID, BestGameYear, BestRPG, BestAction, BestFighting, BestStratagy, BestRacing, BestMultiplayer)
Nominee Table (NomineeID, GameID, AwardID , Year, Manufacture, AwardCategory, Genre, Winner)
FK 1. GameID (references Game Information) FK 2. AwardID (references Award Table)
Winners Table (WinnerID, NomineeID, WinnerYear, AwardID, GameID, AwardCategory, Result, Winner)
FK 1 NomineeID (references Nominee Table) FK 2 AwardID (references Award Table) FK 3 GameID (References Game Information)For my idea I'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)
 Please help me create an entity relationship that utitilizes crow's feet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!