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.

Table One
Part Number (PK)
Description
Notes

Table Two
Model Part Number PK(FK)
Part Part Number PK(FK)

This may be giant overkill, but OFBiz, The Apache Open For Business Project - Open Source E-Business / E-Commerce, ERP, CRM, POS