Define Erd Diagram & Read the case study and find the entities and attribute and make ERD Diagram? Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following:We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs.Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses.Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team.For each match we need to keep track of the following:The date on which the game is playedThe final result of the matchThe players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card.

Assumptions:1A In!MatchAPlayer!entity!set,!we!added!a!unique!identifier!for!each!record!ID.2A…

Answered: Define Erd Diagram & Read the case…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Define Erd Diagram & Read the case study and find the entities and attribute and make ERD Diagram?

Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following:

We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs.
Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses.
Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team.
For each match we need to keep track of the following:
The date on which the game is played
The final result of the match
The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card.

Expert Solution