Question: May an entity can be an attribute to another entity? We have 2 entities STADIUM and MATCH. In entity match, there is one attribute Stadium.
May an entity can be an attribute to another entity?
We have 2 entities STADIUM and MATCH. In entity match, there is one attribute Stadium.
The SOCCER database shall keep information about the stadiums used as venues for the matches. Each STADIUM has a stadium id (SId a surrogate key), stadium name (SName), City, and Capacity (max. no. of spectators).
For each MATCH (game) played, we will keep track of the following information: match/game id (GId a surrogate key), game type (GType see description below in item 7), date the match was played (GDate), the venue where the game was played (Stadium), first team (Team1), second team (Team2), first team score (Score1), and second team score (Score2).
2) Show above things in ER or EER diagram
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
