ntelligence. OLTP systems often provide the transactional data which is used as an input for

OLAP system$$s multi$-$dimensional reports.

Your task is to suggest to Robert Jones what type of systems $($OLTP or OLAP$)$ he can use to

find answers to these questions:

# Process Systems $($OLTP or OLAP$)$

$1$ Who purchased a particular product?

$2$ How much did an employee get paid?

$3$ How many of a product was manufactured?

$4$ What are the total sales for each product?

$5$ What are the total sales for each department?

$6$ Which salesperson has sold the most?

$7$ Which products does each salesperson sell the most

of$?$

$8$ In which month did most of the sales occur?

$9$ Which customer spent the least amount of money

in February?

$10$ Which customer spent the most in February and

which sales person was responsible for the majority

of these sales?

$2$