Banner

 

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

Date revised: October 31, 2011