Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Question Is this a good design?

    I'm just learning about database design and I'm working on a contact management app for work. I'm reviewing schemas online for thoughts on best practices when I found the following design:

    Contacts and Products

    It looks simple but then the Communications table has three foreign keys that's always been a no-no. In the world of "we need something now" is this a workable schema, or is there a better implementation?
    Attached Thumbnails Attached Thumbnails contacts_conceptual.gif  

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Quote Originally Posted by datanewbie
    It looks simple but then the Communications table has three foreign keys that's always been a no-no.
    Why? Actually I can see six but that doesn't make it "wrong".

    If contacts is what you are looking for then take a look at Fowler's party data model:

    A Universal Person and Organization Data Model

Posting Permissions

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