Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    54

    Dimensions.... Dimensions?

    Hi,
    Are dimensions that follows a single strict hierarchy normalized?

    For example time_by_day table with columns:
    day_id
    day
    week
    month
    quarter
    year

    This follows a straight forward strict hierarchy.

    Thanks
    Vmuisc

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, i think they are

    could be wrong, though (wouldn't be the first time)

    where's doktorblue? he'll tell you everything is redundant after day

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •