Consider the following University Database schemas. Primary keys are underlined Relational Schemas department (dade dame, chair) course Idade.com ile preredkode.co, prodo) class class diode, che, instr) Meaning and additional information Department identified by dois named and has department chair with ssa chair (this ssa must appear in the table why below) Course identified by dead.co has ile andmisel. 3 units credits) Course Idrade, cho has a prerequisite course podle Class identified by classid is offered by department dode has course number Cho, and is act by instructor with son this sont appear in the table for below) Faculty identified by has a comanda and belongs to department drade (which must appear in the table Student identified by ssw has a name, major and status Student identified by s is enrolled in the class identified by class no ( s ust appear in the table and ca st appear in the ble class Student identified by swtook the course identified by dead, Cho) and received the grade. Assume that the only grades available are A. BC and F. faculty me, decode, rank students enrollment class transcript dead. c g rade) Implement the following queries using: A. Tuple relational calculus a. Find students (ssn, name, major, status) who have taken the course "cs530" (must be in transcripts) b. Find students (ssn, name, major, status) named "John" (.e., name John" in student) who have taken the course "CS 530" (must be in transcripts) c. Find students (ssn, name, major, status) who satisfied all prerequisites of each class they are enrolled in. d. Find students (ssn, name, major, status) who are enrolled in a class for which they have not satisfied all its prerequisites. Find students (ssn, name, major, status) named "John" who are enrolled in a class for which they have not satisfied all its prerequisites. f. Find courses (dcode, cno) that do not have prerequisites g. Find courses (dcode, cno) that do have some prerequisites h. Find classes (class, dcode, cno, instr) that are offered this semester and have prerequisites. 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) 1. Find students (ssn, name, major, status) who are currently enrolled in a class taught by professor Brodsky (name = "Brodsky" in faculty)