Relational Algebra

Question 1

What is it

Answer 1

Relational algebra is a procedural query language.

Question 2

Select(sigma)

Answer 2

Sigma customer_city = ‘agra’ (Table name)

Question 3

Project

Answer 3

Project operator is denoted by a symbol. It is used to select desired columns.

Project custname,custcity (Table name)

Question 4

Union U

Answer 4

It is used to select all the rows from two tables.

project studentname(s1) U project studentname(s2)