a) Find students (ssn, name, major, status) who have taken the course "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" (must be in transcripts). Order the result by ssn. c. Find students (ssn, name, major, status) who satisfied all prerequisites of each class they are enrolled in. Order the result by ssn. d. Find students (ssn, name, major, status) who are enrolled in a class for which they have not satisfied all its prerequisites. To satisfy the prerequisite, the student needs to have obtained grade "B" or higher. Order the result by ssn. e. Find students (ssn, name, major, status) named "John" who are enrolled in a class for which they have not satisfied all its prerequisites. To satisfy the prerequisite, the student needs to have obtained the grade "B" or higher. Order the result by ssn. f. Find courses (dcode, cno) that do not have prerequisites. Order the result by dcode, cno. g. Find courses (dcode, cno) that do have some prerequisites. Order the result by dcode, cno. h. Find classes (class, dcode, cno, instr) that are offered this semester and haveprerequisites. Order the result by class. i. Find students (ssn, name, major, status) who received only the grades "A"or "B" in every course they have taken (must appear in Transcripts). Order the results by ssn.

pur-new-sol

Related Questions