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:
List the name, SSN , the number of courses the student hastaken, and the number of courses completed(courses with the sameCourseNumber taken in different quarters are counted as differentcourses)
Expert Answer
An answer will be send to you shortly. . . . .