Banner

 

9 - The Relational Model and Relational Algebra
Skill Builders

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 (open edition) by Richard T. Watson
For questions and comments please contact the author

Date revised: 02-Dec-2022