470,614 Members | 1,505 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

relational algebra question - please help!

I need to write a relational algebra query for the following:

Show the item_ID, item description and category description for all items
where the supplier uses "rail" as the delivery_method.

The relations (tables) and attributes are as follows:

Item (item_ID, description, category, price, qty_on_hand)
Category (code, description, tax_rate)
Supplied_by (item_ID, supplier, date, delivery_method)

notes:
1. "Item" and "Supplied_by" tables are linked by their primary keys.
2. The primary key for the "Category" table (code) is linked to the category
attribute of the "Item" table.

Any help with this would be highly appreciated.
Jul 19 '05 #1
0 2408

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by muniba | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.