Chapter 9
Skill Builders

Page 243

Write relational algebra statements for the following queries:

1. Report a firm's name and dividend.

shr [shrfirm, shrdiv]

2. Find the names of firms where the holding is greater than 10,000.

 shr [shrfirm] where shrqty > 10000

This page is part of the promotional and support material for Data Management (fifth edition) by Richard T. Watson
For questions and comments please contact the author

Revised: Mon, Sep 5, 2005