1. State the 3 stages of queries written in SQL are processed by Relational Database Management Systems and explain your own words and with detail the purpose of each.
2. Using the generic relational algebra expression translated directly from a typical SQL statement: Argue and explain in detail why query optimization is needed especially when the tables in question in the query have a large number of rows

Answer rating: 100% (QA)

SQL queries are processed by Relational Database Management Systems RDBMS in several stages to retrieve the requested data efficiently The three main stages are 1 Parsing and Translation Purpose This ... View the full answer