Give an expression in the relational algebra for each of the

Give an expression in the relational algebra for each of the following queries:
a. Find all loan numbers with a loan value greater than $50,000.
b. Find the names of all depositors who have an account with a value greater than $9,000.
c. Find the names of all depositors who have an account with a value greater than $8,000 at the
“Uptown” branch.

Solution

Answer:

a)

SELECT loannumber FROM tablename WHERE loanvalue> $50,000;

b)

SELECT depositorname FROM tablename WHERE value> $9,000;

C)

SELECT depositorname  FROM tablename WHERE value> $9,000 AND branch=“Uptown”;

note: above statements tablename change to your require tablename(EX: deposittable)