subject

Given the following banking database, formulate a relational algebra expression for each of the following questions. select should be performed before any join operation. notation: use the symbol s for select, p for project, j for inner join, #for natural join, u for left join, rj for right join, r for rename, and f for function. type your answer; hand-writing is not acceptedbranch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer city) loan (loan_ borrower (customer_name, loan_number) account (account_number, branch_name, balance) depositor (customer_name, account_number) number, branch_name, amount) a. find the names of all borrowers who have a loan in branch "downtown" and whose loan values are higher than $20,000 b. among customers with loans, list each of the customer's name, the number of loans borrowed by the customer, and the average loan amount of the customer. a. b.

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 01:00, keasiabradley
Search the web for two examples of digital art that you like. the examples must be from different mediums (example: one digital photo and one computer animation not two computer animations). compose an essay for each example you choose about why the piece appeals to you, and identify the medium used.
Answers: 1
image
Computers and Technology, 22.06.2019 01:30, luje
Imagine that you have a friend who is starting a small business and is interested in using social media to spread the word. he is not certain that it is a good move, and has come to you for . would you advise him to use social media to advertise his business? why or why not? support you answer with information from the text.
Answers: 1
image
Computers and Technology, 22.06.2019 03:40, hussain34
Mary's manager told her she should insert a graphic into her documentwrite mary a brief note describing how to insert a graphicin a word processing document.
Answers: 1
image
Computers and Technology, 23.06.2019 09:00, paulusl19
The first screen you see when you open word2016 what is called?
Answers: 1
You know the right answer?
Given the following banking database, formulate a relational algebra expression for each of the foll...

Questions in other subjects: