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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!