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" P 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" P