Here’s an article called Star Schema vs. Snowflake Schema.
Have a look at data modelling.
Learn from YouTube
What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table? This video uses the example of a grocery store’s sales table and the related tables and is by codebasics.