(Solved) : Please Carefully Student Ssn Name Major Course Coursenumber Prerequisitecoursenumber Cours Q35888036 . . . .

Please do these carefully.

Student = (SSN, Name, Major)

Course = ( CourseNumber,PrerequisiteCourseNumber, Course Title, NumberUnits)

Section = ( CourseNumber, Quarter, RoomNumber,DayTime), where DayTime is of the form MW 1:0-2:00PM.

Enrollment = (SSN,CourseNumber, Quarter,Grade)// Grade is either Null or a letter grade.

Express the following queries using appropriate SQL statementswith a minimum number of operations:

1. List the name of every student and SSN who has not taken anycourse more than once.

2. List every two CourseNumber and their titles which have thesame prerequisites.

3. List the name and major of every student who has taken allthe courses that meet MW afternoon.

4. List the name and major of