It's a SQL question
branch(branch name,branch city, assets)
customer (customername, customer street, customer city)
loan (loan number,branch name, amount)
borrower (customername, loan number)
account (accountnumber, branch name, balance)
depositor (customername, account number)
Find an expression in the relationalalgebra of the following queries:
a. Find the name of customerswho have amount of loan less than 100,000.
b. Find the account numbers thathave a zero balance.
c. Find the name of customers whodeposits the account in branch name “KC”.
d. Find the name of customers whodeposit in account number = 100100.
e. Find the name of brancheswhere the customer names “John Smith” borrows the money?
It's a SQL question branch(branch name, branch city, assets) customer (customer name, customer street, customer city) lo
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am