Course Solutions Uncategorized (Solved) : Course Database Please Hand Writing Picture Accepted Write Following Queries Relational Al Q32770465 . . . .

(Solved) : Course Database Please Hand Writing Picture Accepted Write Following Queries Relational Al Q32770465 . . . .

 

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. . . . .

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post