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

question 21

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 doctor,such an aggregated table would have ________ records in the fact table.

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

---

Definitions:

Vitreous Humor

A transparent, gel-like substance filling the eyeball behind the lens, maintaining eye shape and optical properties.

Intraocular Pressure

The fluid pressure inside the eye, important for the eye's health and function.

Viscous

Having a thick, sticky consistency between solid and liquid; having a high resistance to flow.

Optic Disc

The point in the eye where the optic nerve meets the retina, also known as the blind spot, as it contains no photoreceptor cells.