in Databases
596 views
0 votes
0 votes
SQL Aggregation is possible by extended relational algebra operators?

 

SQL grouping is possible in relational algebra.

 

Relational algebra is equivalent to safe relational calculus expressions, then grouping and aggregation possible in tuple relational calculus and domain relational calculus? What about ordering? Please explain how will we consider these questions from GATE point of view.
in Databases
596 views

2 Comments

is there any question in GATE on EXTENDED relational algebra concept ?

i hope NO, but i am not sure !
0
0
Hopefully the question will be locked if OUT of syllabus for gate
0
0

1 Answer

0 votes
0 votes

In Relational Algebra, Extended Operators are those operators that are derived from the basic operators. We already have discussed Basic Operators . Now let us discuss the Extended Operators and how they are beneficial in Relational Algebra.

There are mainly three types of Extended Operators, namely:

1.Divide 

2. Join

3. Intersection

many of the prectical language like SQL...etc have more power compare to relational algebra because grouping ,ordering .......etc

are not supported by Relational algebra but many of practical language are support.

 

edited by

Related questions