Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Star Schema

Status
Not open for further replies.

sumeshabraham

Programmer
Nov 28, 2006
6
IN
Hi All,

Can anyone tell me to which level a Star schema is normalized?

Thanks,
Sumesh
 
A Star Schema is not normalized. A Snow Flake Schema is normalized.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Dr Ralph Kimball says a Dimensional Model (star) is in about 1.5 normal form on the average.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top