(Solved) : 5 Give Listing Students Enrolled Classes Note Use Exists Exists 6 Create New Table Contain Q38013004 . . . .

5

Give a listing of all the students who are not enrolled inany

classes (Note: Use Exists or not Exists)

6

create a new table that contains the list of all thestudents

and class_descriptions. Include In this table the list ofall

students who are not enrolled in any classes (display noclasses). If there are no class descriptions then display ‘nodescription’

(Use combination of inner join, union and minus)

(Note: minus will deal with the students who are not enrolled inany classes)

7

repeat question 6 using a combination of inner join, union andnot exists

(Note: Not exists will deal with the students who are notenrolled in any classes)

8

create a view. We