Consider the following G RADEBOOK relational schema describing the data for a grade book ofa particular instructor. (Note: The attributes A, B, C, and D of COU RSES store grade cutoffs.)
CATALOG(Cno, Ctitle)
STU DENTS(Sid, Fname, Lname, Minit)
COU RSES(Term, Sec_no, Cno, A, B, C, D)
EN ROLLS(Sid, Term, Sec_no)
Specify and execute the following queries using the RA interpreter on the G RADEBOOK database schema.
a. Retrieve the names ofstudents enrolled in the Automata class during the fall 2009 term.
b. Retrieve the Sid values of students who have enrolled in CSc226 and CSc227.
c. Retrieve the Sid values of students who have enrolled in CSc226 or CSc227.
d. Retrieve the names ofstudents who have not enrolled in any class.
e. Retrieve the names of students who have enrolled in all courses in the CATALOG table.
Output of the givin relational schema.
Systems such as Oracle, MS SQL, DB2, or Access are all acceptable if they can handle the capability to handle these questions