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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started