Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started