COURSE:DATABASE
PLEASE: HAND WRITING AND PICTURE NOT ACCEPTED
Write the following queries in Relational Algebra, for thefollowing bank schema: account (ano, bname, balance) branch (bname,bcity, assest) customer (Cname, cstreet, ccity) loan (lno, bname,amount) deposit (cname, ano) borrower (cname, ino)
a) Select all loan tuples where branch name is Abha.
b) Select all loan tuples where branch name is Abha and loanamount less than 200000.
Expert Answer
An answer will be send to you shortly. . . . .