a. Find students (ssn, name, major, status) who have taken thecourse cs530 (must be in transcripts). Order
Question:
a. Find students (ssn, name, major, status) who have taken thecourse “cs530” (must be in transcripts). Order the result by ssn.b. Find students (ssn, name, major, status) named “John” (i.e.,name = "John" in student) who have taken the course “CS 530” (mustbe in transcripts). Order the result by ssn. c. Find students (ssn,name, major, status) who satisfied all prerequisites of each classthey are enrolled in. Order the result by ssn. d. Find students(ssn, name, major, status) who are enrolled in a class for whichthey have not satisfied all its prerequisites. To satisfy theprerequisite, the student needs to have obtained grade “B” orhigher. Order the result by ssn. e. Find students (ssn, name,major, status) named “John” who are enrolled in a class for whichthey have not satisfied all its prerequisites. To satisfy theprerequisite, the student needs to have obtained the grade “B” orhigher. Order the result by ssn. f. Find courses (dcode, cno) thatdo not have prerequisites. Order the result by dcode, cno. g. Findcourses (dcode, cno) that do have some prerequisites. Order theresult by dcode, cno. h. Find classes (class, dcode, cno, instr)that are offered this semester and have prerequisites. Order theresult by class. i. Find students (ssn, name, major, status) whoreceived only the grades “A” or “B” in every course they have taken(must appear in Transcripts). Order the results by ssn. j. Findstudents (ssn, name, major, status) who are currently enrolled in aclass taught by professor Brodsky (name = “Brodsky” in faculty).Order the result by ssn. k. Find students (ssn) from the enrollmenttable who are enrolled in all classes. Order the result by ssn. l.Find CS students (ssn) from the enrollment table who are enrolledin all math classes (dcode = “MTH”). Order the result by ssn.
please provide queries in relational calculus.
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel