(Solved) : Consider Following Relational Schemas Student Studentid Name Age Gender Course Courseld Co Q27399076 . . .
Consider the following relational schemas: Student (studentID, name, age, gender) Course (courselD, courseName, faculty) Enrolment (courselD studentID) JobRequirement (iob,courselD Write relational algebra expression to answer the following questions: 1) Find the name of female students who have enrolled in at least one course required by the “designer” job. 2) Find the name of students who have enrolled in all the courses needed by the “designer” 3) Find the name of courses in which the students are all male students or all female students. Note that, only the following operators can be used in your answer: Select, Project, Union, ob and never enrolled in any courses offered by the “law” faculty. Cartesian Product, Join, and Divide. Show transcribed image text
Expert Answer
Answer to Consider Following Relational Schemas Student Studentid Name Age Gender Course Courseld Co Q27399076 . . .
OR