Question
What is the relational algebra from the question below. I already have the SQL and need it in relational algebra. Student (snum: integer, sname: string,
What is the relational algebra from the question below. I already have the SQL and need it in relational algebra.
Student (snum: integer, sname: string, major: string, level: string, age: integer)
Class (name: string, meets_at: time, room: string, fid: integer)
Enrolled (snum: integer, cname: string)
Faculty (fid: integer, fname: string, deptid: integer)
2. Find the age of the oldest student who is either a History major or enrolled in a course taught by I. Teach.
SQL:
SELECT MAX(S.age)
FROM Student S
WHERE (S.major = History)
OR S.snum IN (SELECT E.snum
FROM Class C, Enrolled E, Faculty F
WHERE E.cname = C.name AND C.fid =F.fid AND F.fname =I.Teach);
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started