Question: ASSIGNMENT: The following relations are part of a school database: tbIStudent(STUDENTID, STUDENT_NAME, MAJOR, YEAR, GPA) tbIFaculty(FACULTYID, DEPARTMENT, TEACHERNAME) tbIStudentEnrollment(STUDENTID, COURSE#, GRADE) tbIFacultyResponsibility(FACULTYID, COURSE#) Using PROJECT,

ASSIGNMENT: The following relations are part of a school database: tbIStudent(STUDENTID, STUDENT_NAME, MAJOR, YEAR, GPA) tbIFaculty(FACULTYID, DEPARTMENT, TEACHERNAME) tbIStudentEnrollment(STUDENTID, COURSE\#, GRADE) tbIFacultyResponsibility(FACULTYID, COURSE\#) Using PROJECT, SELECT and JOIN, write the sequence of operations to answer each of the following questions: 1. What are the names and IDs of students who are enrolled in courses taught by teachers whose name is 'GEORGE'? (2.5 pts) 2. What are the names and GPA's of students who are enrolled in courses that are the responsibility of teachers in the ComputerScience department and who have grades of ' B ' in those courses? (2.5 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
