Question

True or False: Relational algebra cannot perform aggregate function

Answer 1

False. Average, count, max, min are all in relational algebra.

Comments

but you cannot sum and find average in relational algebra.

Relational Algebra cannot perform all aggregation functions and since it is not true for all that aggregation function can be implemented in relational algebra hence the ans should be TRUE.,

---

RELATIONAL ALGEBRA CANNOT FIND AGGREGATE FUNCTIONS SO THE GIVEN STATEMENT IS TRUE

---

but when we use these functions in relational algebra? can u give some examples...

---

its true

Answer 2

TRUE .

If u are saying False , then plz correct me and give some counter example for satisfy False.

According to me and navate book along with some previous year questions of Gate .It is clear above statements is True.

Answer 3

Basic Relational Algebra doesn't have features like arithmetic operations, string concatenation, aggregate functions, Group by etc.

But later it was extended and all the features have been added and it is called extended relational algebra.

Since here it is not specifically mentioned extended relational algebra so assuming the basic relational algebra, the statement is True.

Comments

Does it is anywhere mentioned that or there is  any logic behind it so we are referring relational algebra as basic relational algebra not as extended relational algebra operation

Answer 4

TRUE,

Below are some operations those are beyond the capabilities of Relational Algebra 

1. Finding Transitive Closure,

2. Aggregate Computation,

3. Multiplication,

4. Grouping of records,

5. Ordering/Sorting of records
6. Counting of number of attributes