Please download the Exercise 06 DB Script from the following link:

https://drive.google.com/drive/folders/1y4p4YFL66MOOFjlZoD4UxPaiiztLZMSp

Question: You have been provided a script to create a few tables in a student information system. The exercise is to show all sections and all students, regardless of whether there are students enrolled in a section, or whether the student has enrolled in any sections. 1. Use the provided script to create and populate a database. This is NOT the same script as previous exercises. 2. Write a query to display the information listed below (2 point). 3. The query must use the UNION construct (1 point). 4. The results must be sorted by the academic year, semester, credits, course, enrolled students (1 point). 5. You must turn in a single, well formatted .sql file (1 point). 6. The solution must not reference the literal names, ids, row numbers, etc. It should work for the current data and for future, unknown data. Failure to follow this direction will result in a deduction of 2 points.

| Results a Messages Enrolled Students Mitchel. Jason Wiebe, Aaron AcademicYear Semester Credits Course 1NULL 2 NULL 3 2016 4 2016 5 2016 62016 7 2016 8 2017 9 2017 10 2017 11 2018 12 2018 NULL Enrollment NULL Enrollment Fal Fal Fal Fal Fal Spring 2 Spring 2 Spring 2 Fal Fal INFS 720 Systems Analysis and Design Donaldson. Anthony INFS 720- Systems Analysis and Design Jones, Creed INFS 734-Service Oriented Architectures Donaldson, Anthony NFS 734 Service Orented Architectures Han, Mkyung INFS 734 Service Oriented Architectures Jones, Creed INFS 766 - Advanced Database INFS 766- Advanced Database INFS 766 Advanced Database CIS 32-Systems Analysis and Design Enrollment CIS 487 Database Programming Donaldson, Anthony Han, Mkyung Jones, Creed No Enrollment