Student Ssn Name Major Course Coursenumber Prerequisitecoursenumber Course Title Number Units Section Cour 1 (8.85 KiB) Viewed 58 times
Student Ssn Name Major Course Coursenumber Prerequisitecoursenumber Course Title Number Units Section Cour 2 (12.09 KiB) Viewed 58 times
Student (SSN, Name, Major) Course = (CourseNumber, PrerequisiteCourseNumber, Course Title, Number Units) 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 statements with a minimum number of operations:
3. List the name, SSN and number of courses the student has taken and completed , i.e. received a letter grade (courses with the same CourseNumber taken in different quarters are counted as different courses). 4. List the name, SSN and number of courses the student has taken and completed. with a letter grade C or better (courses with the same CourseNumber taken in different quarters are counted as different courses). 5. List the Course Title and CourseNumber which does not have any prerequisite. 6. List the name of every student and SSN who earned an A in all courses he or she has completed, i.e. every grade is either Null or an A)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!