DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 18

Thread: Data Modeling Question

Threaded View

  1. #13
    Join Date
    Jul 2008
    Posts
    8
    Quote Originally Posted by citldba
    So Bob - is it just me and you again then ?
    No, PAVB is busy trying to boost his ego by criticizing me...

    Anyone that has anything constructive to add is welcome to join in!

    citldba, I have had a few other people say that using a Super-Type/Sub-Type approach would be reasonable and is a good way to avoid having a "wide" table with lots of Nulls.

    I also think it encourages keeping "Apples with Apples" and "Unleaded with Unleaded"!!

    Attached is an ERD I created yesterday. It is far from complete, and does not show everything, but is a good sample of what - I believe - we were discussing...



    Just Bob
    Attached Images Attached Images

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