Relational Algebra Purpose The purpose of this assignment is to help you learn m

Question

Relational Algebra

Purpose

The purpose of this assignment is to help you learn more about the relational algebra.

Brief Introduction

Relational Algebra Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yield relations as their output..

Action Items

You are requested to submit one example of relational algebra i need example without photos also in tables

Explanation / Answer

Suppose there is a relation - R which consists of 5 columns and 5 rows

R

(A B C D E)

--------------------

1 2 3 4 5

3 4 5 6 7

2 6 8 9 1

5 3 6 8 9

8 1 2 3 4

Now i will perform select () and projection() operation on this relation R

1. ((D>5)R)

Output:

R

A B C D E

-----------------

3 4 5 6 7

2 6 8 9 1

5 3 6 8 9

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects