$20$pts: ERD $($connectivities$,$ PKs$,$ FKs$,$ relationship participation$)$

$10$pts: Each table must include five rows$/$records$/$date entries

$20$pts: Be able to forward$-$engineer

$25$pts: Data dictionary as an Excel spreadsheet file

$-$ Data Dictionary Project $1.$xlsx

$25$pts: SQL queries and query result sets in a Word document

$-$ SQL Query Statements & Results Project $1.$docx

List all parents$$ first and last names, and full addresses;

List all players' first and last names, as well as their parent ID using only one SQL statement;

Update coach ID #$2$s first and last names to $$John Doe.$$ Display coach ID #$2$s first and last names to verify that it has been updated;

Add two new teams, using only one SQL statement $($include attributes$).$ Then, display only the team IDs and names to verify that two records have been added;

Remove the first $3$ colors; after which, display the remaining color names to verify that they have been removed.

Submission

Upload one $.$zip file $($include a mwb$.$ file, an Excel spreadsheet, and a Word document$).$

Business Rules

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 and their parents. Also, data needs to be kept on the coaches for each team. And, each team may use colors, but the colors can be assigned to only one team. Once a color is used, that color cannot be used by other teams. Draw the data model described below.

Entities required: Team, Color, 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, Player age, and Player phone number.

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$).$

Color: ColorID, Color name

The following relationships must be defined:

Team is related to Player.

Team is related to Coach.

Team is related to Color

Player is related to Parent.

Connectivities and participations are defined as follows:

A Team may have no or many Players.

A Player has one and only one Team.

A Team may have no or many Coaches.

A Coach is coaching one and only one Team.

A Team may have no or many Colors.

A Color is assigned to only one Team.

A Player may have one or many Parents.

A Parent may have one or many Players.

$*$ Forward engineering error: If the error is made by the syntax VISIBLE, delete all the VISIBLE occurrences in the scripts. Make sure to Disable Safe Model $($see assignment $1$ instructions$).$