See the Snowflake Schema, where a dimension data is separated and kept in another table. For Example: Country, State, District, Post Code data are kept in 4 separate tables.
De Normalized:
See star Schema, where data is kept in one dimension table and that is directly joined to Fact. So in above case, Country, State, District, Post Code if you keep in one dimension table called Geographical table then It is De normalized. Here you will see data redundancy for country column, state column, District column because there may be 100 distinct Post code in a district and that district belongs to a State, country.
