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

question 88

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

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

---

Definitions:

Complex Capital Structure

A financial structure that includes various forms of securities, such as different classes of stock and convertible securities, which can affect the computation of earnings per share.

Diluted Earnings

A measure of a company's profitability that accounts for all potential shares that could be outstanding, providing a worst-case scenario for earnings per share.

Basic Earnings

Net income divided by the number of outstanding shares, representing a company's profit allocated to each share of stock.

Convertible Bonds

Bonds issued by a corporation that can be converted into a predetermined number of shares of the company's stock.