A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. Consider the following schemas
Branch = (Branch-name, Assets, Branch-city)
Customer = (Customer-name, Bank name, Customer-city)
Borrow = (Branch~name, loannumber, customer account-number)
Deposit = (Branch-name, Accountnumber,
Customer-name, Balance)
Using relational Algebra, the Query that finds customers who have balance more than 10,000 is_______
a. πcustomer-name (σbalance > 1000(Deposit))
b. σcustomer-name (σbalance > 1000(Deposit))
c. πcustomer-name (σbalance > 1000(Borrow))
d. σcustomer-name (σbalance > 1000(Borrow))
Answer:πcustomer-name (σbalance > 1000(Deposit))
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: