When designing a Star Schema, which option does not apply?
A.
The facts are quantifiable.
B.
The fact has several foreign keys that are primary keys in the dimensional table
C.
Fact table is joined to the related dimensional tables.
D.
Dimensional tables are normalized.
E.
Dimensional tables have one attribute primary key as Product_ID for products.
Explanation:
In a Star Schema the dimensional tables does not need to be normalized.
A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.
A) quantifiable means those measures is quantifiable?
D
D