I'm looking for some advice on how to setup some tables in a new database I'm creating. We are an automotive parts manufacturer and the first thing I need to do is setup table(s) for the parts. I'd like to arrange the parts in a bill of materials style where we make sub-components that are made into full assemblies. I've reviewed several articles and data models, the one in the link below looks pretty good, but I'd love some feedback from everyone on what works and what doesn't. The caveat I have in my table setup is that some sub-components will be final assemblies and will also be subs for more than 1 other final assembly, so I'm not sure this data model works for that situation. Comments?
http://www.databaseanswers.org/data_models/bom/index.htm