Multiple choice

Consider the given schemes (20 - 2) Branch scheme = (Branch name, assets, branch city) Customer scheme = (Customer name, street, Customer city) Deposit scheme = (Branch name, account name, customer name, balance) Borrow scheme = (Branch name, loan number, customer name, amount) Client scheme = (Customer name, banker name) Using the relational algebra the query that finds customers who have a balance of over 1000 is

  1. $\pi_{customer name} (\sigma_{balance} > 1000(Deposits)$
  2. $\sigma_{customer name} (\sigma_{balance} >1000(Deposits)$
  3. $\pi_{customer name} (\sigma_{balance} > 1000(Borrow)$
  4. $\sigma_{customer name} (\sigma_{balance} >1000(Borrow)$
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SQL statement isSelect customer name from deposit where (balance > 1000) $\therefore$Relational algebra query is $\pi_{customer name} (\sigma_{balance} > 1000(Deposits)$

Keep practicing — related questions