Consider the following schemasBranch = (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_______

Question

TuteeHUB · Accepted Answer

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

TuteeHUB · Answer

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

TuteeHUB · Answer

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

TuteeHUB · Answer

σcustomer-name (σbalance > 1000(Borrow))

1.	Consider the following schemasBranch = (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» B. σcustomer-name (σbalance > 1000(Deposit))

Discussion

No Comment Found

Related MCQs

Reply to Comment