Chapter 6

Relational Algebra

Abstract

This chapter discusses the relational algebra operations that underlie both database design and SQL. The chapter emphasizes the procedural nature of relational algebra, and that the operations are used primarily by SQL command processors, rather than issued directly by a user.

Keywords

relational algebra
relational algebra project
relational algebra select
relational algebra restrict
relational algebra join
relational algebra difference
relational algebra intersect
relational algebra divide
relational algebra union
When we use SQL to manipulate data in a database, we are actually using something known as the relational calculus, a method for using a single command to instruct the DBMS to perform one or more ...

Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.