Create/draw an ERD based on flowing requirements Each GAME has a GAME_TYPE, which is either F1 Racing or WRC Racing For each GAME, the GAME ID, GAME type ID, Arena ID, Game Name, Game Date and Game Fee must be tracked Each GAME is hosted by Arena. An ARENA cam host many different GAMEs. For each ARENA, the ARENA ID, name and address(address, city-state, zipcode ) need to be collect GAMES have many GAMER and each GAMER will participate in lot of GAMES. So there is an M: N exists between GMAE and GAMER EACH GAMER's Finish Time needs to be tracked so the GMAERs can be ranked at the end of GAME When GAMERs create their profile before their first game, they must provide an Email Address, and ideally as many Email addresses as possible. Therefore, Email is a multi-valued attribute. In addition to emails, Mike also wants to track the Gamer ID and first&last name of each GAMER Because WRCgamer organizes WRC Gaming and F1 Gaming, GAMERS can be WRC GAMERs, F1 GAMERs or both For WRC GAMERs, each GAMER is issued a race Number on a flexible yet durable piece of fabric that can be pinned to their shorts or shirts For F1 GAMERs, each GAMER is issued a drive number, which is must show on their suit Race number and Drive numbers are considered completely different attributes, as each GAMER can have both, and the numbers are not exclusive
Create/draw an ERD based on flowing requirements
Each GAME has a GAME_TYPE, which is either F1 Racing or WRC Racing
For each GAME, the GAME ID, GAME type ID, Arena ID, Game Name, Game Date and Game Fee must be tracked
Each GAME is hosted by Arena. An ARENA cam host many different GAMEs. For each ARENA, the ARENA ID, name and address(address, city-state, zipcode ) need to be collect
GAMES have many GAMER and each GAMER will participate in lot of GAMES. So there is an M: N exists between GMAE and GAMER
EACH GAMER's Finish Time needs to be tracked so the GMAERs can be ranked at the end of GAME
When GAMERs create their profile before their first game, they must provide an Email Address, and ideally as many Email addresses as possible. Therefore, Email is a multi-valued attribute.
In addition to emails, Mike also wants to track the Gamer ID and first&last name of each GAMER
Because WRCgamer organizes WRC Gaming and F1 Gaming, GAMERS can be WRC GAMERs, F1 GAMERs or both
For WRC GAMERs, each GAMER is issued a race Number on a flexible yet durable piece of fabric that can be pinned to their shorts or shirts
For F1 GAMERs, each GAMER is issued a drive number, which is must show on their suit
Race number and Drive numbers are considered completely different attributes, as each GAMER can have both, and the numbers are not exclusive
Step by step
Solved in 2 steps with 1 images
