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 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 GameID references Game Information FK AwardID references Award Table
Winners Table WinnerID NomineeID, WinnerYear, AwardID, GameID, AwardCategory, Result, Winner
FK NomineeID references Nominee Table FK AwardID references Award Table FK GameID References Game InformationFor my idea Im planning on creating a database that manages the numerous winners of the Game
Awards over the past 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 eg 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 GameID references Game Information FK AwardID references Award Table
Winner's Table WinnerID NomineelD, WinnerYear, AwardID, GameID, AwardCategory, Result, Winner
FK NomineelD references Nominee Table FK AwardID references Award Table FK GameID
References Game Information
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
