Deck 8: Data Warehouse and Data Mart Modeling

Question 1

In a typical,properly designed star schema,the number of records (rows)in any of the dimension tables is:

A)Larger than in the fact table
B)Same as in the fact table
C)Smaller than in the fact table
D)No typical rule-there is an even number of dimension tables with larger,smaller and same number of records as in the fact table

Answer 1

C

Question 2

Which of the following allows reusing (instead of duplication)of dimensions?

A)Time column
B)Snowflaking
C)Galaxy of stars
D)Degenerate dimension

Answer 2

C

Question 3

The ________ slowly changing dimension approach involves creating a previous and current column in the dimension table for each column where changes are anticipated.

A)Type 1
B)Type 2
C)Type 3
D)Type 0

Answer 3

C

Question 4

Typically,in a star schema all ________ are given a simple,non-composite system-generated key,also called a surrogate key.

A)Fact tables
B)Dimension tables
C)Time columns
D)Transaction identifiers

Question 5

Including a transaction identifier in the fact table is often referred to as:

A)Aggregated fact table
B)Snowflaking
C)Galaxy of stars
D)Degenerate dimension

Question 6

STATEWIDE HEALTH
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
The value Family Medicine from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

A)1
B)2
C)3
D)5

Question 7

STATEWIDE HEALTH
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
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

Question 8

STATEWIDE HEALTH
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
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
D)5

Question 9

Due to multiple subjects of analysis sharing dimensions,the following occurs:

A)A star schema is composed strictly of fact tables
B)A dimensional model contains more than one fact table
C)Some dimensions are eliminated
D)All dimensions are reduced

Question 10

STATEWIDE HEALTH
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
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

Question 11

________ contain measures related to the subject of analysis.

A)Fact tables
B)Dimension tables
C)Both dimension and fact tables
D)None of the above

Question 12

________ contain analytically useful information.

A)Fact tables
B)Dimension tables
C)Both dimension and fact tables
D)None of the above

Question 13

The dimensional schema is often referred to as the:

A)Fact table
B)Dimension table
C)Star schema
D)Transaction schema

Question 14

The ________ slowly changing dimension approach creates a new additional dimension record using a new value for the surrogate key every time a value in a dimension record changes.

A)Type 1
B)Type 2
C)Type 3
D)Type 0

Question 15

STATEWIDE HEALTH
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
The detailed fact table in the STATEWIDE HEALTH star schema has ________ records.

A)0
B)5
C)9
D)82

Question 16

The ________ slowly changing dimension approach changes the old value in the dimension's record with the new value.

A)Type 1
B)Type 2
C)Type 3
D)Type 0

Question 17

STATEWIDE HEALTH
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
The value 250lb from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

A)1
B)2
C)3
D)5

Question 18

STATEWIDE HEALTH
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
Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE,the dimension PATIENT in the STATEWIDE HEALTH star schema has ________ record(s).

A)0 (the dimension PATIENT does not exist)
B)1
C)3
D)4

Question 19

STATEWIDE HEALTH
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
Based on the data shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE,the dimension PRESCRIPTION in the STATEWIDE HEALTH star schema has ________ records.

A)0 (the dimension PRESCRIPTION does not exist)
B)5
C)9
D)82

Question 20

________ contain descriptions of the business,organization,or enterprise to which the subject of analysis belongs.

A)Fact tables
B)Dimension tables
C)Both dimension and fact tables
D)None of the above

Question 21

The value 60611 from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

A)1
B)2
C)5
D)8

Question 22

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension SPAEMPLOYEE in the CUSTOM SPA star schema has ________ records.

A)0 (the dimension SPAEMPLOYEE does not exist)
B)2
C)5
D)8

Question 23

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension PROCEDURE in the CUSTOM SPA star schema has ________ records.

A)0 (the dimension PATRON does not exist)
B)3
C)5
D)8

Question 24

STATEWIDE HEALTH
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
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
D)5

Question 25

STATEWIDE HEALTH
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
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 be connected to ________ dimensions.

A)2
B)3
C)4
D)5

Question 26

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension VISITPROCEDURE in the CUSTOM SPA star schema has ________ records.

A)0 (the dimension VISIT does not exist)
B)3
C)5
D)8

Question 27

The value Mani from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

A)1
B)3
C)5
D)8

Question 28

The detailed fact table in the CUSTOM SPA star schema has ________ records.

A)0
B)5
C)8
D)50

Question 29

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

A)2
B)3
C)4
D)5

Question 30

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension PATRON in the CUSTOM SPA star schema has ________ records.

A)0 (the dimension PATRON does not exist)
B)4
C)5
D)8

Question 31

STATEWIDE HEALTH
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
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 patient,such an aggregated table would be connected to ________ dimensions.

A)2
B)3
C)4
D)5

Question 32

STATEWIDE HEALTH
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
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
D)5

Question 33

The fact table in the CUSTOM SPA star schema is a ________ fact table.

A)constellation
B)degenerate
C)transaction-level detailed
D)line-item detailed

Question 34

The value Daisy from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

A)1
B)3
C)5
D)8

Question 35

STATEWIDE HEALTH
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
The value 10 from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

A)0
B)1
C)2
D)3

Question 36

The value Claire from the CUSTOM SPA DAILY VISITS DATABASE appears altogether ________ time(s)in CUSTOM SPA star schema.

A)1
B)3
C)5
D)8

Question 37

STATEWIDE HEALTH
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
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 be connected to ________ dimensions.

A)2
B)3
C)4
D)5

Question 38

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension CALENDAR in the CUSTOM SPA star schema has ________ record(s).

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

Question 39

STATEWIDE HEALTH
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
The value 2mg from the STATEWIDE HEALTH PRESCRIPTIONS database appears all together ________ time(s)in the populated tables of the STATEWIDE HEALTH star schema.

A)1
B)2
C)3
D)5

Question 40

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
Based on the data shown in the CUSTOM SPA DAILY VISITS DATABASE,the dimension VISIT in the CUSTOM SPA star schema has ________ records.

A)0 (the dimension VISIT does not exist)
B)3
C)5
D)8

Question 41

Aggregated fact tables have a finer level of granularity than detailed tables.

Question 42

Analytical queries on the dimensionally modeled database can be significantly simpler to create than on the equivalent nondimensional database.

Question 43

In addition to giving each record of a dimension a new value that serves as a primary key within the dimensional model instead of the operational key value,surrogate key values contain additional information about each record in the dimension.

Question 44

Normalized data warehouse approach can be used for designing an enterprise-wide analytical data warehouse.

Question 45

Independent data marts approach results in multiple unrelated ETL infrastructures.

Question 46

Independent data marts approach can be used for designing an enterprise-wide analytical data warehouse.

Question 47

Dimensionally modeled data warehouse approach results in multiple unrelated ETL infrastructures.

Question 48

Dimensionally modeled data warehouse approach can be used for designing an enterprise-wide analytical data warehouse.

Question 49

The ER modeling and dimensional modeling methods cannot be combined and used within the same data warehousing project.

Question 50

STATEWIDE HEALTH
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
The STATEWIDE HEALTH star schema contains the dimension PATIENT.

Question 51

A dimensional model can contain more than one fact table.

Question 52

STATEWIDE HEALTH
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
The STATEWIDE HEALTH star schema contains the dimension MEDICATION.

Question 53

When a data warehouse is normalized,its dependent data marts also must be normalized.

Question 54

Dimensional modeling can be employed as a relational data modeling technique.

Question 55

All sources for a dimensional model must be operational data sources from the company that is building the dimensional model.

Question 56

STATEWIDE HEALTH
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
The STATEWIDE HEALTH star schema contains the dimension DOCTOR.

Question 57

A dimensional model cannot be based on a single source.

Question 58

Normalized data warehouse approach results in multiple unrelated ETL infrastructures.

Question 59

Transaction time is typically included as a column in the fact table.

Question 60

The relational model is the only way through which dimensionally modeled databases can be implemented.

Question 61

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column MedicationName provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 62

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column DoctorSpecialty provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 63

STATEWIDE HEALTH
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
The detailed fact table in the STATEWIDE HEALTH star schema is a line-item detailed fact table.

Question 64

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA star schema contains the dimension VISIT.

Question 65

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column MedicationDosage provides the data for the fact table in the STATEWIDE HEALTH star schema.

Question 66

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column PatientWeight provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 67

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA DAILY VISITS DATABASE column PatronZip provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 68

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA star schema contains the dimension PATRON.

Question 69

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA star schema contains the dimension SPAEMPLOYEE.

Question 70

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA DAILY VISITS DATABASE column AmountCharged provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 71

STATEWIDE HEALTH
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
The STATEWIDE HEALTH star schema contains the dimension PRESCRIPTION.

Question 72

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA DAILY VISITS DATABASE column ProcedureName provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 73

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA star schema contains the dimension VISITPROCEDURE.

Question 74

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA DAILY VISITS DATABASE column VisitTimeOfDay provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 75

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA DAILY VISITS DATABASE column VisitID provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 76

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA star schema contains the dimension PROCEDURE.

Question 77

CUSTOM SPA
The following questions citing CUSTOM SPA assume that a single-source star schema is created.The purpose of this star schema is to analyze procedure revenue by all dimensions provided by its source: the CUSTOM SPA DAILY VISITS DATABASE,shown below.In
The CUSTOM SPA DAILY VISITS DATABASE column SEYearOfHire provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 78

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column PrescTimeOfDay provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 79

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column PrescQuantity provides the data for a dimension in the STATEWIDE HEALTH star schema.

Question 80

STATEWIDE HEALTH
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
The STATEWIDE HEALTH PRESCRIPTIONS database column PrescID provides the data for a dimension in the STATEWIDE HEALTH star schema.