It's a SQL question branch(branch name, branch city, assets) customer (customer name, customer street, customer city) lo

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

It's a SQL question branch(branch name, branch city, assets) customer (customer name, customer street, customer city) lo

Post by answerhappygod »

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?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply