Consider the following schemas : Branch = (Branch-name, Assets, Branch-city)…

PYQ UGC NET 2013

Consider the following schemas : Branch = (Branch-name, Assets, Branch-city) Customer = (Customer-name, Bank name, Customer-city) Borrow = (Branch-name, loan number, customer account-number) Deposit = (Branch-name, Account-number, Customer-name, Balance) Using relational Algebra, the Query that finds customers who have balance more than 10,000 is ________

  1. A.

    π customer-name (σ balance > 10000 (Deposit))

  2. B.

    σ customer-name (σ balance > 10000 (Deposit))

  3. C.

    π customer-name (σ balance > 10000 (Borrow))

  4. D.

    σ customer-name (π balance > 10000 (Borrow))

Attempted by 431 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…