Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourse
Posted: Fri Jul 08, 2022 6:43 am
Given the following relational database schema:
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 iseither Null or a letter grade.
1.List the name of every student and SSN who earned an A in allcourses he or she has completed, i.e. every grade is either Null oran A)
2.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
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 iseither Null or a letter grade.
1.List the name of every student and SSN who earned an A in allcourses he or she has completed, i.e. every grade is either Null oran A)
2.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