1 / 10

Chapter 6

Chapter 6. The Relational Algebra and Relational Calculus. Unary Relational Operations: SELECT and PROJECT. The SELECT Operation The PROJECT Operation Sequences of Operations and the RENAME Operation. Relational Algebra Operations from Set Theory.

vmoon
Download Presentation

Chapter 6

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 6 The Relational Algebra and Relational Calculus

  2. Unary Relational Operations: SELECT and PROJECT • The SELECT Operation • The PROJECT Operation • Sequences of Operations and the RENAME Operation

  3. Relational Algebra Operations from Set Theory • The UNION, INTERSECTION, and MINUS Operations • The CARTESIAN PRODUCT (or CROSS PRODUCT) Operation

  4. Binary Relational Operations: JOIN and DIVISION • The JOIN Operation • The EQUIJOIN and NATURAL JOIN Variations of JOIN • A Complete Set of Relational Algebra Operations • The DIVISION Operation

  5. Additional Relational Operations • Aggregate Functions and Grouping • Recursive Closure Operations • OUTER JOIN Operations • The OUTER JOIN Operation

  6. Examples of Queries in Relational Algebra

  7. The Tuple Relational Calculus • Tuple Variables and Range Relations • Expressions and Formulas in Tuple Relational Calculus • The Existential and Universal Quantifiers • Example Queries Using the Existential Quantifier • Transforming the Universal and Existential Quantifiers • Using the Universal Quantifier • Safe Expressions

  8. The Domain Relational Calculus

  9. Summary

More Related