given a system ERD Design and tables of sample data, you'll need to Know how to write and run SQL commands to: 1- Create Schema 2- Create Tables with attributes (columns/fields) and selecting suitable data types for the attributes 3- Add Primary Keys to tables 4- Map relationships between tables using Foreign Keys 5- Write SQL INSERT INTO statements to add data tables Requirements & Submission: 1. You need to submit TWO MySQL script files: a) SQL script file (NSLStructure.sql) contains all your SQL DDL to create the schema and the tables of the given system b) SQL script file (DataInputs.sql) contains INSERT INTO statement to add the given data to your database Tasks: Using The following physical (implementation) ERD model of the NSL database system described in assignment #1: Goal PK Number PK,FK1 Match D PK,FK2 Player_ID Time Scored by scored in H HPK ID PK FK1 FK2 FK3 Player FK Team ID Name Position Skills ID PK FK2 Field_ID FK2 Player_ID (Captain) Team Name City Coach ID Match Team ID[Host] Team_ID[Guest] Field_ID Date Score Winner Has Associated with History PK Number PK.FK Player ID Description Start Date Played on End Date Field PK ID Name Location 1. Create MySQL script file contains SQL DDL commands to implement this NSL database. Name the script file NSLStructure.sql. 2. Create another MySQL script file contains SQL INSERT INTO commands to add the data form the tables below into the corresponding database tables. Name the script file DataInputs.sql. 1-Players ID Position 1 Midfielder 7 Forward 19 Midfielder 3 Defender 9 Forward 10 goalkeeper 6 Midfielder Bryce Duke 2-History Records Number Player ID 3 1 2 3 3-Teams ID 2 1 3 3 19 Name Paxton Pomykal Jonathan Lewis Jack Price Drew Moor Jess Ferreira Kenneth Vermeer Name Colorado Rapids FC Dallas Los Angeles FC Description US U-20 squad for the 2003 World Youth Championship Eastern Conference Championship: 2010. Colorado rapids US U20 at the 2019 FIFA U-20 World Cup in Poland. Field ID City Denver, CO Dallas, TX 1 2 Los Angeles, CA 3 TeamID Skills 7.5 8.0 7.0 8.0 7.0 7.0 7.5 Captain ID 3 1 10 1 2 2 2 1 3 3 End Date Start Date 11/27/2003 12/19/2003 11/13/2010 11/13/2010 05/23/2019 6/15/2019 Coach Robin Fraser Luchi Gonzalez Bob Bradley 1-Players ID Position 1 Midfielder 7 Forward 19 Midfielder 3 Defender 9 Forward 10 goalkeeper 6 Midfielder Bryce Duke 2-History Records Number Player ID 3 1 2 3 3-Teams ID 2 1 3 3 19 Name Paxton Pomykal Jonathan Lewis Jack Price Drew Moor Jess Ferreira Kenneth Vermeer Name Colorado Rapids FC Dallas Los Angeles FC Description US U-20 squad for the 2003 World Youth Championship Eastern Conference Championship: 2010. Colorado rapids US U20 at the 2019 FIFA U-20 World Cup in Poland. Field ID City Denver, CO Dallas, TX 1 2 Los Angeles, CA 3 TeamID Skills 7.5 8.0 7.0 8.0 7.0 7.0 7.5 Captain ID 3 1 10 1 2 2 2 1 3 3 End Date Start Date 11/27/2003 12/19/2003 11/13/2010 11/13/2010 05/23/2019 6/15/2019 Coach Robin Fraser Luchi Gonzalez Bob Bradley 4-Fields Id 1 2 3 Name Dick's Sporting Goods Park Toyota Stadium Banc of California Stadium 5-Matches ID 1 2 6-Goals Host Team ID 1 1 Number 1 2 3 4 Match ID 1 2 222 Location Commerce City, CO Player ID 19 6 9 9 Frisco, TX Los Angeles, CA Guest Team ID 2 3 Time 32 22 45 87 Field ID 1 1 Date 01/08/2019 0-1 12/09/2019 2-1 Score Winner 2 1