I need assistance with loading data from the table bellow into an already created Schema using LOAD DATA INFILE statement. Can someone help with the queries. The tables bellow are copied from a doc x

I know the statement should look something like this ?

LOAD DATA INFILE '/Library/Application support/Users/username/My_Scripts_MYSQL/CS31A_The+University+Database.docx' INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY ' ' IGNORE 1 ROWS;

The University Database Tables for the University Database Course ID Title Credits Department ID Prerequisite Accounting AC 101 CIS253Database Systems3 AC265 Systems Analysis 3 EN100 LA123 English Literature MA150 College Algebra 3 EN100 CIS253 Basic English 0 EN100 4 EN100 The course table Faculty ID NameRoom ID Department ID Salary 63395 78699 96895 79653 97302 57180 74420 35579 98377 Jones Mobley 11 Williams 20 Vajpayee 12 Collins 17 Sen Rivera21 Chang Brad 94333.99 59303.62 119921.41 88791.45 61387.56 32570.50 89805.83 108011.81 35570.50 12 4 17 12 The faculty table Major ID 100 200 300 400 500 600 Major Description AAS-Accounting AAS-Computer Science AAS-Telecommunications BS-Accounting BS-Computer Science BS-Telecommunications The major table Department Name Computer Science Telecommunications Accounting Math and Science Liberal Arts English Budget 90000 100000 85000 120000 800000 70000 Department ID 4 The department table Term ID FL16 FL17 SP16 SP17 WN17 Term Description Fall 2016 Fall 2017 Spring 2016 Spring 2017 Winter 2017 Start Date 2016-09-08 2017-09-07 2016-04-28 2017-03-27 2017-01-05 End Date 2016-12-20 2017-12-19 2016-07-16 2017-07-15 2017-04-18 The term table Section Course Section Term Faclty Day Max Start Room Time 09:00 09:00 09:00 10:30 09:00 09:00 09:00 09:00 09:00 09:00 09:00 Time 10:30 10:30 12:00 12:00 10:30 10:30 10:30 10:30 10:30 12:00 10:30 Count 1101 1102 1103 1104 1205 1206 1207 1208 1209 1210 AC265 CIS253 MA150 02 AC 101 AC265 AC265 LA123 CIS253 CIS253 CIS253 EN100 WN17 97302 WN17 78699 WN17 74420 FL17 SP17 SP17 SP17 SP17 FL16 FL17 FL17 MW30 13 TR 40 57180 97302 97302 NULL 78699 63395 78699 98377 MW 3:5 MW 35 TR30 MW 30 TR40 MW40 01 14 18 15 14 18 19 14 MW50 The section table Student Last ID 24746Diaz FirstStreet CityState ZipBirth Date Major Phone Student Name Name Type 97355511 ugrad 7185552222 grad 7325553333 ugrad 7325554444 grad ID Jose 1 Ford Hill NJ 08863 1993-02-12 100 Avenue #/ 79352 Tyler Kee 12 Morris Bronx NY 10468 1994-03-18 500 Avenue 76672 iko Rajesh 25 RiverEdison NJ 088371995-12-12 400 Road #3 14182 Rickles Alex 100 Main Iselin NJ 08838 1990-10-20 500 Street 44985Lee 2845 First Hope NY 11373 1995-10-28 600 Lane 0 2125555555 grad 96052 Holn Amir213 Clifton NJ 07222 1994-07-07 200 2015556666 ugrad Broadway The student table Student ID Section IDMidterm Final Grade Grade 24746 24746 24746 24746 79352 76672 76672 76672 76672 76672 14182 14182 14182 14182 44985 44985 44985 96052 96052 96052 1102 1103 1104 1207 1205 1102 1103 1206 1207 1210 1101 1104 1206 1311 1206 1207 1210 1208 1209 1311 The registration table Room ID Building Room No. Capacity Room Type Room Description Gandhi 101 Gandhi 103 Kennedy 202 Kennedy 204 Nehru 301 Nehru 309 Gandhi 105 Kennedy 206 Kennedy 210 Gandhi107 Gandhi109 Office Office 12 13 14 15 16 35 50 50 45 Lab Classroom Classroom Office Lab Classroom Office Office 40 30 19 20 21 The location table The University Database Tables for the University Database Course ID Title Credits Department ID Prerequisite Accounting AC 101 CIS253Database Systems3 AC265 Systems Analysis 3 EN100 LA123 English Literature MA150 College Algebra 3 EN100 CIS253 Basic English 0 EN100 4 EN100 The course table Faculty ID NameRoom ID Department ID Salary 63395 78699 96895 79653 97302 57180 74420 35579 98377 Jones Mobley 11 Williams 20 Vajpayee 12 Collins 17 Sen Rivera21 Chang Brad 94333.99 59303.62 119921.41 88791.45 61387.56 32570.50 89805.83 108011.81 35570.50 12 4 17 12 The faculty table Major ID 100 200 300 400 500 600 Major Description AAS-Accounting AAS-Computer Science AAS-Telecommunications BS-Accounting BS-Computer Science BS-Telecommunications The major table Department Name Computer Science Telecommunications Accounting Math and Science Liberal Arts English Budget 90000 100000 85000 120000 800000 70000 Department ID 4 The department table Term ID FL16 FL17 SP16 SP17 WN17 Term Description Fall 2016 Fall 2017 Spring 2016 Spring 2017 Winter 2017 Start Date 2016-09-08 2017-09-07 2016-04-28 2017-03-27 2017-01-05 End Date 2016-12-20 2017-12-19 2016-07-16 2017-07-15 2017-04-18 The term table Section Course Section Term Faclty Day Max Start Room Time 09:00 09:00 09:00 10:30 09:00 09:00 09:00 09:00 09:00 09:00 09:00 Time 10:30 10:30 12:00 12:00 10:30 10:30 10:30 10:30 10:30 12:00 10:30 Count 1101 1102 1103 1104 1205 1206 1207 1208 1209 1210 AC265 CIS253 MA150 02 AC 101 AC265 AC265 LA123 CIS253 CIS253 CIS253 EN100 WN17 97302 WN17 78699 WN17 74420 FL17 SP17 SP17 SP17 SP17 FL16 FL17 FL17 MW30 13 TR 40 57180 97302 97302 NULL 78699 63395 78699 98377 MW 3:5 MW 35 TR30 MW 30 TR40 MW40 01 14 18 15 14 18 19 14 MW50 The section table Student Last ID 24746Diaz FirstStreet CityState ZipBirth Date Major Phone Student Name Name Type 97355511 ugrad 7185552222 grad 7325553333 ugrad 7325554444 grad ID Jose 1 Ford Hill NJ 08863 1993-02-12 100 Avenue #/ 79352 Tyler Kee 12 Morris Bronx NY 10468 1994-03-18 500 Avenue 76672 iko Rajesh 25 RiverEdison NJ 088371995-12-12 400 Road #3 14182 Rickles Alex 100 Main Iselin NJ 08838 1990-10-20 500 Street 44985Lee 2845 First Hope NY 11373 1995-10-28 600 Lane 0 2125555555 grad 96052 Holn Amir213 Clifton NJ 07222 1994-07-07 200 2015556666 ugrad Broadway The student table Student ID Section IDMidterm Final Grade Grade 24746 24746 24746 24746 79352 76672 76672 76672 76672 76672 14182 14182 14182 14182 44985 44985 44985 96052 96052 96052 1102 1103 1104 1207 1205 1102 1103 1206 1207 1210 1101 1104 1206 1311 1206 1207 1210 1208 1209 1311 The registration table Room ID Building Room No. Capacity Room Type Room Description Gandhi 101 Gandhi 103 Kennedy 202 Kennedy 204 Nehru 301 Nehru 309 Gandhi 105 Kennedy 206 Kennedy 210 Gandhi107 Gandhi109 Office Office 12 13 14 15 16 35 50 50 45 Lab Classroom Classroom Office Lab Classroom Office Office 40 30 19 20 21 The location table