Register

Relational algebra and SQL

844 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.
User Avatar

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
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
khushtak asked Jan 20, 2016
843 views
Sql and relational algebra
Can anyone suggest me how to learn about sql and relational algebra and calculus for gate? as i feel this is an important topic and one 2 marks ques will be asked. I can understand easy problems and problems with solutions. Anything worth regarding this topic?
Can anyone suggest me how to learn about sql and relational algebra and calculus for gate?as i feel this is an important topic and one 2 marks ques will be asked. I can u...
User Avatar
1 votes
1 votes
2 answers
3
aditi19 asked May 8, 2019
1,254 views
Raghuramkrishnan Exercise-4.3 question 11 page no-127 Relational Algebra
Suppliers(sid, sname, address) Parts(pid, pname, color) Catalog(sid, pid, cost) Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
Suppliers(sid, sname, address)Parts(pid, pname, color)Catalog(sid, pid, cost)Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
User Avatar
Link Copied!