Archives of the TeradataForum
Message Posted: Sun, 10 Nov 2002 @ 22:50:48 GMT
Pat, can you be precise and rigorous when you say 3NF is "far more flexible"? Can you prove it? I don't think you can, it's just an idea that no one has ever proven. Secondly, a dimensional schema, with normalized dimension tables (also know as a snowflake schema) is, in fact, in 3NF. Does that mean you endorse a dimensional schema?
My point is, there are lots of designs that are 3NF, and most of them will not perform at all. Which ones will? And just what is it that makes a 3NF so flexible? Please explain WHAT KIND of 3NF schema you are recommending and why various design choices lead to this flexibility.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|