Question

Given the following business scenario, create a Crow’s Foot ERD

The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents. The team has an ID, name, and colors. Data stored for each player consists of the id, first name, last name, and age. Also, data needs to be kept on the coaches for each team. Each player can only play on one team but a team may have many players. A team may also have many coaches but a coach has only one team. A parent can have many parents and a parent can have many players.

Answer 1

Please find below the steps to create the ERD for the given system:

Step 1: Identify the entities:

1. Team: To handle team details

2. Player: To handle player details

3. Parent: To handle parent details

4. Coach: To handle coach details

Step 2: List relationship between the entities:

1. A team has many Player, but a player plays in one team only. This is a Many to One relationship.

2. A player can have many players similarly a parent can have many players, thus it is a Many to Many relationship.

3. A team has many Coaches, but a coach coaches one team only. This is a Many to One relationship.

Step 3: Assign attributes to the entities:

**Primary key is bold and highlighted

1. Team(team_id, name, colors)

2. Player( player_id, first_name, last_name, age)

3. Parent(parent_id, relation, name, contact_number)

4. Coach(coach_id, name, contact_number)

Step 4: ERD in crow’s foot notation:

name age team_id player_id name TH Team color playes in Player coached by has Parent Coach parent_id contact_number contact_number name coach_id relation name