Question: PLEASE ANSWER USING RELATIONAL ALGEBRA INTERPRETER ON THE WINDOWS COMMAND PROMPT. Consider the following GRADEBOOK relational schema describing the data for a grade book of
PLEASE ANSWER USING RELATIONAL ALGEBRA INTERPRETER ON THE WINDOWS COMMAND PROMPT.

Consider the following GRADEBOOK relational schema describing the data for a grade book of a particular instructor (Note: The attributes A, B, C, and D store grade cutoffs.) catalog (cno,ctitle) students (sid, fname, lname, minit) courses (term, secno, cno, A, B,C, D) enrolls (sid,term, secno) Specify and execute the following queries using the RA interpreter on the GRADEBOOK database schema. a. Retrieve the names of students enrolled in the Automata, class in the term of Fall 1996 b. Retrieve the SID values of students who have enrolled in CSc226 as well as CSc227. c. Retrieve the SID values of students who have enrolled in CSc226 or CSc227. d. Retrieve the names of students who have not enrolled in any class. e Retrieve the names of students who have enrolled in all courses in the cataloa table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
