A typical SQL query has the form

select A1, A2,..., An 

from r1, r2,...,rm 

where P;

Each Arepresents an attribute, and each ri a relation. P is a predicate.

What is the relational algebra expression for the given query?

1
\(Π_{r_1×r_2×………×r_m } (σ_P (A_1,A_2…..A_n ))\)
2
\(σ_{A_1,A_2…..A_n } (Π_P (r_1×r_2×………×r_m ))\)
3
\(Π_{A_1,A_2…..A_n } (σ_P (r_1×r_2×………×r_m ))\)
4
None of the above

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation