Question

Advantages and disadvantages of relational algebra

Answer 1

Answer:

advantages of relational algebra

Answer 2

Answer:

Relational algebra

• Each operator has one or two relations

instance

• A relational algebra expression is recursive

defined as a relationship

Disadvantages of Relational Algebra

• Relational algebra cannot perform arithmetic operations.

• It is unable to perform aggregation operations, although it cannot compute a transitive closure.

• It cannot change the data present in the database.

Advantages of Relational Algebra

• Relational algebra has a solid mathematical background.

• The mathematical background of relational algebra is the basis of many interesting developments and theorems.

• If we have two expressions for the same operation, and if the expressions prove to be equivalent, then the query optimizer can automatically substitute the more efficient form.

#SPJ3