Computers and Technology

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.

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 23.06.2019 13:30, alannaamarriee
Jace needs to answer a question on square roots to win a quiz. how can he use a spreadsheet to find the square root of 786? a. use the functions round and count b. create a table and chart c. use the function sqrt d. use the function now
Answers: 3
image
Computers and Technology, 24.06.2019 11:00, maddiiie128
Why is it uncommon for users to perform searches directly in database tables? a.)users are discouraged from interacting directly with tables because they might confuse tables with spreadsheets. b.) users are discouraged from interacting directly with tables because this may result in unintended changes to source data. c.)users do not have the technical skills required to perform searches directly in database tables. d.)users do not have the permissions required to perform searches directly in database tables.
Answers: 1
image
Computers and Technology, 25.06.2019 12:50, mmaglaya1
Which of the following activities is an example od gathering data by observation
Answers: 3
image
Computers and Technology, 25.06.2019 14:00, meganwintergirl
Suppose we are performing a binary search on a sorted array called numbers initialized as follows: // index 0 1 2 3 4 5 6 7 8 9 10 11 12 13 int[] numbers = {-2, 0, 1, 7, 9, 16, 19, 28, 31, 40, 52, 68, 85, 99}; // search for the value 5 int index = binarysearch(numbers, 5); write the indexes of the elements that would be examined by the binary search (the mid values in our algorithm's code) and write the value that would be returned from the search. assume that we are using the binary search algorithm shown in lecture and section.
Answers: 3
Do you know the correct answer?
Given the following banking database, formulate a relational algebra expression for each of the foll...

Questions in other subjects:

Konu
History, 01.12.2021 17:30