Question

Q 17 Consider the given relations:
Branch_Scheme (Branch_name, assets, Branch_city)
Customer_Scheme (Customer_name, street, Customer_city)
Deposit_Scheme (Branch_name, account_number, Customer_name, balance)
Borrow_Scheme (Branch_name, loan_number, Customer_name, amount)
Client_Scheme (Customer_name, banker_name)
By using relational algebra, determine the query that finds the customer's name who have a balance more than 10,000.
Ops: A.
Customer_name
Σ
balance > 10000
(Deposit))
° Σ
(
Customer_name
balance > 10000
(Borrow))
(
Customer_name
Σ
(Borrow))
balance > 10000
ΟΣ
(
Customer_name
balance > 10000 (Deposit))​

Answer 1

Answer:

Branch_Scheme (Branch_name, assets, Branch_city)

Customer_Scheme (Customer_name, street, Customer_city)

Deposit_Scheme (Branch_name, account_number, Customer_name, balance)

Borrow_Scheme (Branch_name, loan_number, Customer_name, amount)

Client_Scheme (Customer_name, banker_name)

By using relational algebra, determine the query that finds the customer's name who have a balance more than 10,000.

Ops: A.

Customer_name

Σ

balance > 10000

(Deposit))

° Σ

(

Customer_name

balance > 10000

(Borrow))

(

Customer_name

Σ

(Borrow))

balance > 10000

ΟΣ

(

Customer_name

balance > 10000 (Deposit))

Explanation:

Branch_Scheme (Branch_name, assets, Branch_city)

Customer_Scheme (Customer_name, street, Customer_city)

Deposit_Scheme (Branch_name, account_number, Customer_name, balance)

Borrow_Scheme (Branch_name, loan_number, Customer_name, amount)

Client_Scheme (Customer_name, banker_name)

By using relational algebra, determine the query that finds the customer's name who have a balance more than 10,000.

Ops: A.

Customer_name

Σ

balance > 10000

(Deposit))

° Σ

(

Customer_name

balance > 10000

(Borrow))

(

Customer_name

Σ

(Borrow))

balance > 10000

ΟΣ

(

Customer_name

balance > 10000 (Deposit))