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.

PLEASE ANSWER USING RELATIONAL ALGEBRA INTERPRETER ON THE WINDOWS COMMAND PROMPT. Consider

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!