Relational Algebra

From: Zubair <zubairusman_at_yahoo.com>
Date: Tue, 4 Nov 2003 15:23:12 -0000
Message-ID: <3fa7c45d$0$12704$fa0fcedb@lovejoy.zen.co.uk>

I'm not sure if this is the right place to post this but could someone help me out with some relational algebra.

I have three tables

Student(Student#, sname, saddress, dob, degreetype) Course(Course#,cname, syllabus, day, time) Attendance(Student#,Course#, Year)

I need to represent the following query in Relational Algebra

SELECT sname
FROM Student, Course, Attendance
WHERE Student.Student# = Attendance.Student# AND

               Course.Course# = Attendance.Course# AND
               Course.cname = "DB" AND
               Student.degreetpe = "PP"

Thanks for your help Received on Tue Nov 04 2003 - 09:23:12 CST