Relational Algebra
From: Zubair <zubairusman_at_yahoo.com>
Date: Tue, 4 Nov 2003 15:23:12 -0000
Message-ID: <3fa7c45d$0$12704$fa0fcedb_at_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.
Date: Tue, 4 Nov 2003 15:23:12 -0000
Message-ID: <3fa7c45d$0$12704$fa0fcedb_at_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 - 16:23:12 CET