e Manonyane Football Club (MFC) is an amateur soccer association playing in the premiere soccer league. Each city in the country has a number of teams represented. A city has several locations where a number of games can be played. Each location belongs to one city. Each team has a maximum of 18 players and a minimum of 10 players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). During the season, each team plays two games (home and visitor) against each of the other teams. Statistics such as no. of fouls, in which a player features in a particular game are recorded. A game involves many players and a player can play in many games. A team can be expected to play in many games and a game involves more than one team. Given those conditions, do the following; draw an ERD to represent the MFC database. Assume that all relationships are strong or regular.
The Manonyane Football Club (MFC) is an amateur soccer association playing in the premiere soccer league. Each city in the country has a number of teams represented. A city has several locations where a number of games can be played. Each location belongs to one city. Each team has a maximum of 18 players and a minimum of 10 players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). During the season, each team plays two games (home and visitor) against each of the other teams. Statistics such as no. of fouls, in which a player features in a particular game are recorded.
A game involves many players and a player can play in many games. A team can be expected to play in many games and a game involves more than one team.
Given those conditions, do the following; draw an ERD to represent the MFC
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
