relation algebra query
From: Nick <nparfait_at_hotmail.com>
Date: 21 Apr 2002 23:45:39 -0700
Message-ID: <1016c570.0204212245.3ce693b0_at_posting.google.com>
Assuming u have the following relations
student(sid, sname)
subject(subid, subname)
enrolled(subid, sid, year)
Date: 21 Apr 2002 23:45:39 -0700
Message-ID: <1016c570.0204212245.3ce693b0_at_posting.google.com>
Assuming u have the following relations
student(sid, sname)
subject(subid, subname)
enrolled(subid, sid, year)
how would you write the realational algebra for finding the subject name which is taken by all students in a particular year. ie. only subjects which have all students are displayed.
Received on Mon Apr 22 2002 - 08:45:39 CEST