ERD for City Youth League Database

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 as well as their parents. Also, data needs to be kept on the coaches for each team.

Create an ERD with draw.io based on the details below. SUBMIT a PNG EXPORT (NOT "save as" PNG) of your draw.io diagram.

Remember to denote primary and foreign keys (PK, FK) as well as both cardinality (one/many) and participation (mandatory/optional) for relationships.

Note that there is a SINGLE many-to-many relationship in this model--and you must create a 'join' or 'bridge' table (click here for an example) to hold the foreign keys.

Also remember to use proper/valid field names(no spaces or special characters, except _)--and follow the convention of using all lowercase.

For an intro to many-to-many relationships, skip to the last part of the following recorded lecture video:

$CANVAS_COURSE_REFERENCE$/modules/items/gd79fd8e76fcc80d420460dfbbbd793d9

Entities required: Team, Player, Coach, and Parent.

Attributes required for each entity:

• Team: Team_ID number, name, and colors.
• Player: Player_ID number, first name, last name, and age.
• Coach: Coach_ID number, first name, last name, and home phone number.
• Parent: Parent_ID number, last name, first name, Home phone number, and Home Address (Street, City, State, and ZIP Code--to simplify for this exercise, just put all of these into a a single 'address' field).

Further requirements:

• Team is related to Player.
• Team is related to Coach.
• Player is related to Parent.

Specifically:

• A Team may have many Players.
• A Player has only one Team.
• A Team may or may not have a Player.
• A Player must have a Team.

• A Team may have many Coaches.
• A Coach has only one Team.
• A Team may or may not have a Coach.
• A Coach must have a Team.

• A Player may have many Parents.
• A Parent may have many Players.
• A Player must have a Parent.
• A Parent must have a Player.

SUBMIT a PNG EXPORT (NOT "save as" PNG) of your draw.io diagram.

ERD for City Youth League Database 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 as well as their parents. Also, data needs to be kept on the coaches for each team. draw.io Remember to denote primary and foreign keys (PK,FK) as well as both cardinality (one/many) and participation (mandatory/optional) for relationships. Note that there is a SINGLE many-to-many relationship in this model-and you must create a 'join' or 'bridge' table (click here for an example) to hold the foreign keys. Also remember to (no spaces or special characters, except_)-and follow the convention of using all lowercase. Submit Assignment Assignment Details (Spring 2023) TrD 256 (002N) - Advanced Database Management \$CANVAS COURSE REFERENCE\$/modules/items Lgd79fd8e76fcc80d420460dfbbbd793d9 Entities required: Team, Player, Coach, and Parent. Attributes required for each entity: - Team: Team_ID number, name, and colors. - Player: Player_ID number, first name, last name, and age. - Coach: Coach_ID number, first name, last name, and home phone number. - Parent: Parent_ID number, last name, first name, Home phone number, and Home Address (Street, City, State, and ZIP Code-to simplify for this exercise, just put all of these into a a single 'address' field). Further requirements: - Team is related to Player. - Team is related to Coach. - Player is related to Parent. Specifically: Submit Assignment 4 Previous Next : Assignment Details (Spring 2023) ITD 256(002N ) - Advanced Database Management Further requirements: - Team is related to Player. - Team is related to Coach. - Player is related to Parent. Specifically: - A Team may have many Players. - A Player has only one Team. - A Team may or may not have a Player. - A Player must have a Team. - A Team may have many Coaches. - A Coach has only one Team. - A Team may or may not have a Coach. - A Coach must have a Team. - APlayer may have many Parents. - AParent may have many Players. - A Player must have a Parent. - A Parent must have a Player. your draw,io diagram Submit Assignment 4 Previous Next