A snowflake schema is an extended form of a star schema in which all of the tables have undergone full normalization.
A snowflake schema in computing is a logical setup of tables in a multidimensional database so that the entity relationship diagram looks like a snowflake. Centralized fact tables connected to various dimensions serve as the representation of the snowflake schema. A star schema's dimension tables can be normalized by a process called "snowflaking." When all of the dimension tables are fully normalized, the resulting structure resembles a snowflake with the fact table in the center. The basic idea behind snowflaking is to normalize dimension tables by splitting out low cardinality characteristics and creating new tables.
Similar to the star schema is the snowflake schema. In contrast, dimensions are standardized into numerous linked tables in the snowflake schema.
Learn more about snowflake schema here:
https://brainly.com/question/29676088
#SPJ4
