May an entity can be an attribute to another entity? We have 2 entities STADIUM and MATCH. In entity

May an entity can be an attribute to another entity? We have 2 entities STADIUM and MATCH. In entity match, there isone attribute Stadium. The SOCCER database shall keep information about the stadiumsused 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 thefollowing information: match/game id (GId – a surrogate key), gametype (GType – see description below in item 7), date the match wasplayed (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 Attached

"Is this question part of your assignment? We can help"

ORDER NOW