Ques 56-III-D-13

56. Consider the following schemas:

Branch = (Branch_name,  Assets, Branch_city)

Customer = (Customer-name, Bank-name,Customer-city)

Borrow = (Branch-name, loan-number, customer-name, Balance)

Deposit = (Branch-name, Account-number, Customer-name, Balance)

Using relational Algebra, the query that finds customers who have balance

More than 10,000 is ________

(A) π_{customer-name}(σ_{balance > 10000}(Deposit))

(B)  σ_{customer-name}(σ_{balance > 10000}(Deposit))

(C) π_{customer-name}(σ_{balance > 10000}(Borrow))

(D)σ_{customer-name}(σ_{balance > 10000}(Deposit))

ANS-(A)

Description is coming soon--