Using relational algebra, the query that finds customers, who have a balance…

PYQ RPSC Programmer 2013

1. A.

   $\pi_{\text{customer\_name}}(\sigma_{\text{balance}>3000}(\text{Deposit}))$

2. B.

   $\sigma_{\text{customer\_name}}(\sigma_{\text{balance}>3000}(\text{Deposit}))$

3. C.

   $\pi_{\text{customer\_name}}(\sigma_{\text{balance}>3000}(\text{Borrow}))$

4. D.

   $\sigma_{\text{customer\_name}}(\pi_{\text{balance}>3000}(\text{Borrow}))$

Attempted by 1 students.