Complex 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 the data model described below. Entities required: Team, Player, Coach, and Parent. Attributes required: Team: Team_ID number, Team name, and Team colors. Player: Player_ID number, Player first name, Player last name, and Player age. Coach: Coach_ID number, Coach first name, Coach last name, and Coach home phone number. Parent: Parent_ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and ZIP Code). Further requirements: Team is related to Player. Team is related to Coach. Player is related to Parent. Specifically: A Team may or may not have a Player. A Player must have a Team. A Team may have many Players. A Player has only one Team. A Team may or may not have a Coach. A Coach must have a Team. A Team may have many Coaches. A Coach has only one Team. A Player must have a Parent. A Parent must have a Player. A Player may have many Parents. A Parent may have many Players.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Complex 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 the data model described below.

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

Attributes required:

Team: Team_ID number, Team name, and Team colors.
Player: Player_ID number, Player first name, Player last name, and Player age.
Coach: Coach_ID number, Coach first name, Coach last name, and Coach home phone number.
Parent: Parent_ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and ZIP Code).

Further requirements: