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!

Register Log in
  • Congratulations SkipVought 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

sumeshabraham

Programmer
Nov 28, 2006
6
0
0
IN
Hi All,

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

Thanks,
Sumesh
 
Sort by date Sort by votes
A Star Schema is not normalized. A Snow Flake Schema is normalized.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BINewbie
  • Locked
  • Question
Star Schema Design
Replies
3
Views
74
johnherman
johnherman
AvgMoJoe
  • Locked
  • Question
Help designing star schema
Replies
1
Views
80
johnherman
johnherman
scottcabral1979
  • Locked
  • Question
schema design question
Replies
3
Views
88
johnherman
johnherman
LonnieJohnson
  • Locked
  • Question
Is it easy to start a data warehouse?
Replies
4
Views
51
johnherman
johnherman
wbodger
  • Locked
  • Question
Getting started with Data Warehousing
Replies
4
Views
30
wbodger
wbodger

Part and Inventory Search

Sponsor

Back
Top