Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    need some design suggestions

    I am attempting to create a database to recommend parts needed by model. My main issue is the the same part could be used in one or more models. Ie.. one part may be used in just one model while another may be used in twenty different models. I am no dba but I have been tasked with creating this tool. So I am at a loss as to how to do this.

    I am using mysql. I have tried the following but do not feel that is the most efficient.

    Table One
    Part Number (PK)
    Description
    Notes

    Table Two
    ID/Line Number (PK)
    Part Number (FK)
    Model

    This works but is a nightmare to maintain and input. Hoping someone can point me to a better solution.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Table One
    Part Number (PK)
    Description
    Notes

    Table Two
    Model Part Number PK(FK)
    Part Part Number PK(FK)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057

Posting Permissions

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