Advantages and disadvantages of relational algebra
Answers
Answered by
2
Answer:
advantages of relational algebra
Answered by
7
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
Similar questions