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.
Part Number (PK)
ID/Line Number (PK)
Part Number (FK)
This works but is a nightmare to maintain and input. Hoping someone can point me to a better solution.