Data Warehousing and Data Mining20785 marksA multidimensional data model
Differentiate between star schema and snow flake schema. List any two methods for data normalization.
Differentiate between star schema and snow flake schema. List any two methods for data normalization. [5]
Basis Star Schema Snowflake Schema --------- Structure A central fact table is connected directly to dimension tables, forming a star shape A variant of star schema where some dimension tables are further normalized and split into additional tables, forming a snowflake shape Normalization Dimensi...