Relative Expressive Power

• Safe TRC and DRC are as powerful as (basic) relational algebra

• Extended relational algebra is

  • more powerful than TRC/DRC

  • useful for defining SQL semantics

  • useful for designing SQL queries

  • useful for understanding SQL execution

• Relational calculus is

  • useful for designing SQL queries