Question: Explain and write the pseudocode for a Mapper/Reducer that takes as input a large file (possibly split into chucks) of integers and outputs: a. The
Explain and write the pseudocode for a Mapper/Reducer that takes as input a large file (possibly split into chucks) of integers and outputs:
a. The sum of the squares of each integer
b. The maximum integer
c. Assume you have a database with two relations (i.e. tables): customers and accounts.
The schema for customers is composed of the following attributes:
customerID (integer)
name (string)
address (string)
phone (string)
The schema for accounts is composed of the following attributes:
customerID (integer)
accountNumber (integer)
balance (float)
Write the following queries using SQL:
A. Find the customer name with account number 12345.
B. Find all customer names who have at least one account with balance >$100,000 Write the following queries using Relational Algebra:
C. Find all account numbers with balance <$20,000 D. Calculate the sum of all accounts for customer with ID=432
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
