Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

According to Oracle's documentation, third normal form schemas "may require less data-transformation than more normalized schemas such as star schemas".

I'm confused, I thought 3NF is the most normalized among common schema models, then goes snowflake schema and at last star schema.

share|improve this question
Perhaps it's a typo and they meant "less normalized schemas ..." – ypercubeᵀᴹ Sep 7 '12 at 12:12
"3NF is the most normalized among common schema models", this is not true as there are more normal forms than 3. – NoChance Sep 7 '12 at 21:56
3NF is the most common though, I think that's what @Yrogirg meant. – Valentino Vranken Apr 12 '13 at 6:10
up vote 2 down vote accepted

As @ypercube stated this seems to be a typo and should be changed to "more de-normalized schemas". One of the following paragraphsinthe Oracle manual states:

Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema.

This product dimension table of the star schema described here is not in third normal form but are results of joining (denormalize) some tables of the snowflake schema.

I found aricles on the web that describe why a star schema is not in 3rd normal form link link

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.