(Solved) : Given Following Relational Database Schema Student Ssn Name Major Course Coursenumber Prer Q32006211 . . . .

Given the following relational database schema:

Student = (SSN, Name, Major)

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

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

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

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

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

b)List the name of every student and SSN who has completed allthe courses he/she has taken and earned an A in each course, i.e.every grade is an A and no NULL value

c)List the name of every student and SSN