Question: Download the Exercise 04 - DB Script.sql from the following link:

https://drive.google.com/drive/folders/14obQzy8AIaZ3ohTp6H9f5AbTrbeyQjJX

Once you downloaded the 04-DB Script.sql, then complete and answer the following steps.

1. Use the provided script to create and populate a database.

2. Write a query to display the information listed below.

3. The query must use the NOT EXISTS construct.

4. The query must use a subquery in the WHERE clause.

5. The results must be sorted by academic year, semester and course.

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.

AcademicYear Semester Course 2018 Fall Fall CIS 332 Systems Analysis and Design CIS 487- Database Programming 2018