Consider the following GRADEBOOKrelational schema describing the data for a grade book of a particular instructor. (Note: The attributes A,B,C, and DofCOURSESstore grade cutoffs.)
CATALOG(Cno, Ctitle)
STUDENTS(Sid, Fname, Lname, Minit)
COURSES(Term, Sec_no, Cno, A, B, C, D)
ENROLLS(Sid, Term, Sec_no)
Specify and execute the following queries using the RA interpreter on the GRADEBOOKdatabase schema.
a.Retrieve the names of students enrolled in the Automata class during the fall 2009 term.
b.Retrieve the Sidvalues of students who have enrolled in CSc226 and CSc227.
c.Retrieve the Sidvalues 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 CATALOGtable