Describe snow flake system design in database

Question

Briefly describe snow flake system design in database?

Answer 1

Snow flake system is one of the designs that are exists in database design. Snow flake system serves up the reason of dimensional modeling in the data warehousing. If the dimensional table is dividing into numerous tables, where the system is inclined vaguely towards normalization, then the snow flake design is employed. It holds joins in depth. The basis is that, the tables divide additional.