Database - Data Warehousing - Discussion

@Bhavana, because a typical fact table conforms to 3NF. Each non-key is not typically functionally dependent on any other other non-key, hence adheres to 3NF.

Most fact tables are not and don't require further normalization beyond this normal form, so in that sense, a fact table is 'completely normalized'.

I'think the answer is B.

In snowflake schema dimension tables are in normalized form but Fact Table is in De-Normalized form.

In star schema both dimension and Fact Tables are in De-Normalized form.

A fact table is the central table in a star schema of a data warehouse. A fact table stores quantitative information for analysis and is often de-normalized.

Fact table contains the name of facts or measures as well as keys to each of the related dimensional tables.

Basically the fact table consists of the Index keys of the dimension/look up tables and the measures.

So when ever we have the keys in a table, that itself implies that the table is in the normal form.

Can you please explain me how fact tables are completely normalized?