MIS 430 Midterm GUIDE — Part 2: Data Warehouse Modeling (2.1-2.4)

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/19

encourage image

There's no tags or description

Looks like no tags are added yet.

20 Terms

1
New cards

What is a fact table?

A table that stores quantitative measures of a business event. Each row represents an occurrence of that event.

2
New cards

What are the key characteristics of a fact table?

Measures are typically numeric; it contains foreign keys to dimension tables; the grain must be clearly defined.

3
New cards

What are the three types of measures in a fact table?

Additive, semi-additive, and non-additive.

4
New cards

What is an additive measure?

A measure that can be summed across all dimensions.

5
New cards

What is a semi-additive measure?

A measure that can be summed across some dimensions, but not all dimensions.

6
New cards

What is a non-additive measure?

A measure that cannot be meaningfully summed across dimensions.

7
New cards

Can a fact table contain a transaction identifier?

Yes. A fact table may contain a transaction identifier in addition to foreign keys and measures.

8
New cards

Does a fact table contain only one numeric value?

No. The statement that a fact table contains only one numeric value is FALSE.

9
New cards

What is a dimension table?

A table that provides descriptive context—the who, what, where, when, and how—surrounding a business event.

10
New cards

What are the key characteristics of dimension attributes?

They are primarily descriptive and categorical and support filtering, grouping, and drill-down.

11
New cards

What type of keys should dimension tables use?

Surrogate keys rather than natural/business keys.

12
New cards

How are numeric values typically handled in dimensions?

Numeric values in dimensions are often converted into categorical ranges.

13
New cards

Do dimensions contain strategies or decisions under management control?

No. Dimensions do NOT contain strategies or decisions that are under management control.

14
New cards

What is a star schema?

One central fact table surrounded by denormalized dimension tables.

15
New cards

Why are dimensions denormalized in a star schema?

To optimize query performance at the cost of some data redundancy.

16
New cards

What type of primary key should every dimension have in a star schema?

A surrogate, system-generated integer primary key—not a natural/business key.

17
New cards

What typically forms the primary key of the fact table in a star schema?

A composite key made up of the foreign keys to the dimension tables, optionally including a degenerate dimension such as a transaction ID.

18
New cards

What is a constellation schema (galaxy schema/fact constellation)?

Multiple fact tables that share common dimension tables, enabling cross-subject analysis.

19
New cards

What is an example of a constellation schema?

A Sales fact table and Purchasing fact table sharing DimProduct and DimDate.

20
New cards

What is a snowflake schema?

A schema that normalizes dimension tables by factoring repeating groups into separate related tables, reducing redundancy but increasing joins and potentially hurting query performance.