The Following Questions Citing STATEWIDE HEALTH Assume That a Single-Source

question 62

Multiple Choice

The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescription is prescribed for one patient by one doctor, and it contains one medication.

STATEWIDE HEALTH PRESCRIPTIONS DATABASE





-Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS database,if we created an aggregated fact table that contains data about daily prescribed quantities of each medication per each patient,such an aggregated table would have ________ records in the fact table.

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

---

Definitions:

Learn

The act or process of acquiring knowledge or skill through study, experience, or instruction.

University Of Michigan

A prestigious public research university in Ann Arbor, Michigan, known for its rigorous academic programs and significant contributions to research.

Admission Points

Criteria or scores used by educational institutions to determine an applicant's eligibility for entrance.

Minority Status

The position of being part of a group that is smaller in number within a society and often has less power, representation, or privilege.