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

question 2

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

• A)0 (the dimension DOCTOR does not exist)
• B)3
• C)4

---

Definitions:

Santa Susanna

A historic Catholic church in Rome, Italy, known for its Late Renaissance architecture and considered a titular church with a long history.

Pope Paul V

The head of the Roman Catholic Church and ruler of the Papal States from 1605 to 1621, known for his role in the Counter-Reformation and his support of the arts.

Maderno

A reference to Carlo Maderno, an Italian architect who is considered one of the pioneers of Baroque architecture in the early 17th century.

Three Nave Bays

Architectural term describing the division of space in a church or cathedral, split into three longitudinal areas separated by columns or piers.