Question: Convert the following SQL statements to relational algebra: 1 . select * from students; 2 . select city from students; 3 . select major from
Convert the following SQL statements to relational algebra:
select from students;
select city from students;
select major from students where gpa ;
select name, age from students where gpa and dept CS;
select Sname, TcourseId
from students as S takes as T
where Ssid Tsid and Sdept CS;
select Sname, Sdept, TcName
from student as S takes as T
where Sgpa ;
select name
from student
where dept CS
intersect
select name
from student
where gpa ;
select name
from student
where dept CS
except
select name
from student
where gpa ;
select Sname, Tname
from student as S student as T
where Sgpa Tgpa;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
