I was wondering if someone can help me..

I need to find 3 differnt ways of writing the following SQL in relational algebra:

SELECT sname
From Student, Course, Attendance
WHERE Student.Student# = Attendance.Student# and
Course.Course# = Attendance.Course# and
Course.cname = "advance database" and
Student.degreetype = "professional Pathway"

The query is : find student names that are taking professional pathway degree and are attending the advance database course.

Student (Student#, sname, address, dob,degreetype)
Course(Course#, cname, syllabus, day, time)
Attendance(Student#, Course#, year)

Hi,

I hope this will work out for U,

1. SELECT sname
From Student
, Course
, Attendance
WHERE
Student.Student# = Attendance.Student# and
Course.Course# = Attendance.Course# and
Course.cname Like 'advance database' and
Student.degreetype like 'professional Pathway';


2. SELECT sname
From Student
, Course
, Attendance
WHERE
Student.Student# = Attendance.Student# and
Course.Course# = Attendance.Course# and
Course.cname in ('advance database') and
Student.degreetype in ('professional Pathway');

Hi Satish,

I actaully want to SQL written in relational algebra!!

Sorry for my lack of knowledge, but what is relational algebra like ?