ALSETMAX COMPANY
Observe the Three Different Tables That Exist in the ALSETMAX

question 9

Multiple Choice

ALSETMAX COMPANY
Observe the three different tables that exist in the ALSETMAX COMPANY and contains the information about customers.Assume all the values in all tables are correct.All three tables will be used as the source tables for the dimension CUSTOMER in the ALSETMAX COMPANY dimensionally modeled data warehouse.
ALSE TMAX CUSTOMERS
$\begin{array} { c l l c } \text { SSN } & \text { Name } & \text { Gemder } & \text { CustBirthYear } \\ 111 - 11 - 1111 & \text { Ned } & \text { Male } & 1980 \\ 222 - 22 - 2222 & \text { Nelly } & \text { Female } & 1990 \\ 333 - 33 - 3333 & \text { Anna } & \text { Female } & 1989 \\ 444-44 - 4444 & \text { Ned } & \text { Male } & 1970 \end{array}$ \\
A-MAX CUSTOMER TABLE
$\begin{array} { c c c c } \text { GSN } & \text { Nane } & \text { Sex } & \text { YearOfBirth } \\ 111 - 11 - 1111 & \text { Ned } & \text { M } & 1980 \\ 222 - 22 - 2212 & \text { Nelly } & F & 1990 \\ 333 - 33 - 3333 & \text { Anna } & F & 1989 \\ 555 - 55 - 5555 & \text { Anna } & F & 1970 \end{array}$ \\
AM CUSTOMER ZIPCODE INFO
$\begin{array} { c c } \text { SSN } & \text { ZipCode } \\ 111 - 11 - 1111 & 60611 \\ 222 - 22 - 2122 & 60655 \\ 333 - 33 - 3333 & 60601 \\ 444 - 44 - 4444 & 60611 \\ 555 - 55 - 5555 & 60655 \end{array}$

This scenario will be used for the following questions citing ALSETMAX COMPANY.
-Based on the data in the three source tables,how many records in the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY represent a female customer?

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

---

Definitions:

Self-Determination Theory

The theory that three basic psychological needs including autonomy, competence, and relatedness motivate our adaptation efforts at any age.

Life Satisfaction

A measure of how content people are with their life as a whole, reflecting one's overall well-being and quality of life.

Autonomy

The capacity and right of individuals to make their own choices and decisions, free from external constraint.

Post-Traumatic Growth

Positive psychological change experienced as a result of the struggle with highly stressful or traumatic events.