Figure:
Table1 Table2 The Numeric Values in Table2 Indicate the Number of Customers

question 4

Multiple Choice

Figure:
Table1
$$\begin{array} { | l | l | l | } \hline \text { Bank product } & \text { Location } & \text { Number-of-customers } \\\hline \text { Checking } & \text { USA } & 1,000,000 \\\hline \text { Checking } & \text { Europe } & 500,000 \\\hline \text { Checking } & \text { SE Asia } & 1,100,000 \\\hline \text { Checking } & \text { India } & 300,000 \\\hline \text { Savings } & \text { USA } & 700,000 \\\hline \text { Savings } & \text { Europe } & 400,000 \\\hline \text { Savings } & \text { SE Asia } & 900,000 \\\hline \text { Savings } & \text { India } & 800,000 \\\hline \text { Mutual funds } & \text { USA } & 300,000 \\\hline \text { Mutual funds } & \text { Europe } & \\\hline \text { Mutual funds } & \text { SE Asia } & 300,000 \\\hline \text { Mutual funds } & \text { India } & 80,000 \\\hline\end{array}$$
Table2
$$\begin{array} { | l | l | l | l | } \hline \text { Location } & \text { Checking } & \text { Savings } & \text { Mutual Funds } \\\hline \text { USA } & 1,000,000 & 700,000 & 300,000 \\\hline \text { Europe } & 500,000 & 400,000 & 200,000 \\\hline \text { SE Asia } & 1,100,000 & 900,000 & 300,000 \\\hline \text { India } & & & \\\hline\end{array}$$
The numeric values in Table2 indicate the number of customers.
-We add the following two dimensions to Table2: age groups (20-39,40-60,over 60) and revenue groups (less than $10,000,$10,000-$30,000,over $30,000) .The star schema consists of the following number of tables:

• A) 2
• B) 3
• C) 4
• D) 5

---

Definitions:

Economic Order Quantity

Economic Order Quantity (EOQ) is a formula used to determine the optimal quantity of inventory to order that minimizes total inventory costs, including holding and ordering costs.

Inventory System

A process or software used for tracking goods and materials held by a business, managing stock levels, orders, sales, and deliveries.

Productivity

The measure of the efficiency of a person, machine, factory, system, etc., in converting inputs into useful outputs.

Small Business Owner

An individual who owns and operates a small business, typically taking on considerable financial risks in the hope of profit.