Make a SQL file, and use it to do the following:1) Create a University ERD using data in university_data.pdf (Links to an external site.) All the data in this file is not already set up into entities (tables). These are actually what query result sets might look like, not necessarily just tables themselves.2) Forward engineer the University database and copy the code used during that forward engineer into an sql file. This is the same file you will be adding the insert statements to.3) Insert the University data found in university_data.pdf. Use Insert statements and save as one file with the forward engineer code.University Data: Catalog View (3 different entities) college department department code course_num course credits CIT 111 3 Intro to Databases ECON 388 Econometrics 4 College of Physical Computer Science and Information Engineering Technology College of Business Economics and Communication College of Business Economics and Communication College of Language Humanities and and Letters Philosophy ECON 150 3 Micro Economics Classical Heritage HUM 376 2 Section View (4 different entities) course year term section capacity 2019 Fall 1 30 2019 Fall 1 50 2 50 1 Fall Fall Fall Winter faculty fname Marty Nate Nate Ben John Marty Bill Nate Nate John 35 30 faculty Iname Morring Nathan Nathan Barrus Jensen Morring Barney Nathan Nathan Jensen CIT 111 ECON 150 ECON 150 ECON 388 HUM 376 CIT 111 CIT 111 ECON 150 ECON 150 HUM 376 1 2019 2019 2019 2018 2018 2018 2018 2018 2 30 3 35 1 50 Winter Winter Winter Winter 2 50 1 30 Student View (1 entity) fname state gender city M Dallas F Provo TX UT F Provo UT M Iname Miller Smith Jones Merrill Murdock Adams Carlson Larsen Madsen Sorensen Paul Katie Kelly Devon Mandy Alece Bryce Preston Julia Susan AZ KS dob 1996-02-22 1995-07-22 1998-06-22 2000-07-22 1996-11-22 1997-05-22 1997-11-22 1996-09-22 Mesa Topeka Rigby Bozeman Decatur Rexburg Mesa F F M ID MT TN M F ID 1998-09-22 1998-08-09 F AZ Enrollment View (linking table with a composite key – 2 values) Winter 2018 Section 3 Winter 2018 Section 2 Winter 2018 Section 1 Winter 2018 Section 1 Fall 2019 Section 1 Winter 2018 Section 2 Here's the logic of the linking table: Alece enrolling in CIT 111 Bryce enrolling in CIT 111 Bryce enrolling in ECON 150 Bryce enrolling in HUM 376 Devon enrolling in HUM 376 Julia enrolling in ECON 150 Katie enrolling in ECON 388 Kelly enrolling in ECON 388 Mandy enrolling in ECON 388 Mandy enrolling in enrolling in HUM 376 Paul enrolling in CIT 111 Paul enrolling in ECON 150 Preston enrolling in ECON 150 Susan enrolling in CIT 111 Fall 2019 Section 1 Fall 2019 Section 1 Fall 2019 Section 1 Fall 2019 Section 1 Fall 2019 Section 1 Fall 2019 Section 2 Winter 2018 Section 2 Winter 2018 Section 2