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

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,the dimension MEDICATION in the STATEWIDE HEALTH star schema has ________ records.

A) 0 (the dimension MEDICATION does not exist)
B) 2
C) 3
D) 5