Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Systems Analysis And Design

Authors: Joseph Valacich, Joey George

8th Edition

0134204921, 978-0134204925

More Books

Students also viewed these Databases questions

Question

How should textual information be formatted on a help screen?

Answered: 1 week ago