O'Reilly logo

Introduction to Database Systems by ITL Education Solutions Limited

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 4

RELATIONAL ALGEBRA AND CALCULUS

After reading this chapter, the reader will understand:

  • Different query languages used to extract data from the database
  • Difference between relational algebra and relational calculus
  • Various unary relational algebra operations like select, project, and rename
  • Various binary relational algebra operations like set operations, joins, and division operation
  • Various set operations like union, intersection, difference, and cartesian product operation
  • Different types of joins like equijoin, natural, and outer joins (left, right, and full outer join)
  • The aggregate functions that are used to perform queries, which are mathematical in nature
  • Two forms of relational calculus, namely, tuple relational calculus ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required