1 / 14

Relational Algebra

ASADVBASDFCBVAWFESDGV

shakshi
Download Presentation

Relational Algebra

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. RELATIONAL ALGEBRA

  2. What is relation algebra • It is a procedural language. • It takes relations as input and yields instances of relations as output. It uses operators to perform queries. • We use operators for performing operations on the relations. • RDBMS (SQL) is an implementation of relational algebra

  3. Operations in relational algebra • They accept the relations as input and yield relations as output.  • They can be unary and binary • There are 6 basic operations in Relational Algebra • 1. Selection        2. Projection        3. Rename • 4. Union        5. Set Difference        6. Cartesian Product • There are 2 derived operations in Relational Algebra • 1. Intersection        2. Division

  4. SELECTION OPERATOR

  5. PROJECTION OPERATOR

  6. RENAME OPERATOR

  7. UNION OPERATOR

  8. SET difference OPERATOR

  9. Cartesian product OPERATOR

  10. intersection OPERATOR

  11. division OPERATOR

More Related