Question: model the entities, attributes and relationships for this assignment (you can make a quick handwritten work or just write them and I will do the

model the entities, attributes and relationships for this assignment (you can make a quick handwritten work or just write them and I will do the modeling)

Directions:

I am a volunteer soccer coach for Richmond Strikers
 Strikers reached out to me about building a database to help me manage the season.
 Your assignment - build me the model so that I can implement the database in MySQL
Rules:
 Richmond Strikers organizes leagues by gender (Co-Ed or Female) and Age Group
 Players register to play soccer. They submit their gender and birthday to be assigned to
a league.
 Teams are formed based on registered players. Each player is assigned to one team,
each team has at least 10 players.
 Each team is given a name and assigned to a league.
 Each team has a head coach. A team may have multiple assistant coaches, but some
teams will not have an assistant.
 Strikers conducts background checks on all coaches. The date of the background check
needs to be retained for legal purposes.
 Head coaches must take a class. Strikers needs to track the completion date of the
class.
 Strikers needs to track the name, emergency contact name, emergency contact phone
number, age, email address and gender of all players.
 Strikers needs to track the name, role (assistant or head coach), phone number, and
email address of all coaches.

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!