DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: master table and lookup

  1. #11
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Oh, and I remembered another argument for the existence of simple code tables - consistency. Okay, so your Gender column contains M/F. What if another table makes it m/f? Or even assuming that you rule your database with an iron fist and even without a code table, everyone puts in exactly the right codes all the time - what about the display of non-code values. Your application's on-screen reports may all say the same thing, like 'Male' or Female', but what about reports? 'Boy' 'Girl', 'Man' 'Woman'. The problem gets worse over time. In 2 years, people may still be adding reports to your application long after you're gone. What is to keep them consistently translating your codes to descriptive words or phrases? While this may sound silly for Male/Female, it becomes less silly for race, or other less universally-accepted domains. If you want to enfocrce consistency in both your data and in your presentation, the code table is the best vehicle, hands-down.

    - Chris

  2. #12
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Originally posted by marist89
    [I figured sooner or later you would jump in here...
    It's been harder lately, I'm splitting my time between 2 clients *and* the book *and* standard summertime fun

    But you're right - there are some issues where I can't help myself

    - Chris

  3. #13
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi Chris

    I am glad that your finally cummin out with your book .why not rope in jurij ............two brains are better then one i guess.


    regards
    hrishy

  4. #14
    Join Date
    Jun 2001
    Posts
    193
    if we use method 2.

    we will end up with lots of tables,

    should i put foreign key between all those lookup table and fact table?
    guru is on the way!!!!

Posting Permissions

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


Click Here to Expand Forum to Full Width