# Thread: Student needs some help (lots actually!)

1. Registered User
Join Date
Mar 2004
Posts
2

## Student needs some help (lots actually!)

Hi all,

I'm just learning about relational algebra & I'm trying to figure out what the purpose of all the operations is. I have the answer for some of them but not all - can you help me fill the blanks please?

Here's what I have so far:

Select to select tuples that satisfy a given predicate
Project to pick/eliminate specified attributes, eg. to eliminate duplicate columns
Union to find tuples that appear in either or both of two relations
(use Projection first, to get required columns from each relation, then Union on the two resulting relations)
Difference to find tuples that are in one relation but are not in another
(use Projection first, to get the required columns from each relation, then Difference on the two resulting relations)
Intersect to find tuples that are in both relations
(is not a fundamental operation, but is a more convenient way to write r - (r - s) )
(use Projection first, to get the required columns from each relation, then Intersect on the two resulting relations)
Product to pair up rows from two relations (to find what?)
Join to combine information from two or more relations so data from the relations can be used to extract information
Natural Join (what for?)
Theta Join (what for?)
Equi-Join (what for?)
Outer Join (what for?)
Semi-Join (what for?)
Divide (what for?)

Thanks,

Wannabe

2. Registered User
Join Date
Mar 2004
Posts
6
Are you not atually learning on a course with a tutor to ask??

3. Registered User
Join Date
Mar 2004
Posts
2
Originally posted by I, Brian
Are you not atually learning on a course with a tutor to ask??
Yes it is a University course but it's by correspondence & I can't get the tutor to reply to my e-mails.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•