Relational Algebra
DESCRIPTION
ASADVBASDFCBVAWFESDGV
1 / 14
Télécharger la présentation
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
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
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
More Related