Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourse

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Given the following relational database schema: Student = (SSN, Name, Major) Course = ( CourseNumber, PrerequisiteCourse

Post by answerhappygod »

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply