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 CALENDAR in the STATEWIDE HEALTH star schema has ________ record(s) .

A) 0 (the dimension CALENDAR does not exist)
B) 1
C) 2
D) 5