By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,514 Members | 836 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,514 IT Pros & Developers. It's quick & easy.

relational algebra question - please help!

P: n/a
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)

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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.