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

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 CoursaeNumber and Quarter which has the highestenrollment.

b)List every CourseNumber and CourseTitle which has the highestenrollment based on all quarters.

c)List the name and major of every student who has completed thehighest number of units.

Expert Answer

An answer will be send to you shortly. . . .