Hi,

I have been asked to create a database for my company. However I'm unsure which approach to take. Basically our products can have one or more "sub-systems" which each have different specifications. Most of the specification titles will be relevant to each sub-system.

It is yet to be decided whether this will be for the whole organisation as one central database or if it's just for a product selector for our website.

I've come up with two ideas:

To have two tables, one detailing the main product features e.g. size, model, part number which is linked ( One-to-many) to another table with every single specification for all sub-systems and then have a "Sub-System Type" field.

Or to have a table for each sub-system, linked to the main product table. Each sub-system table then has the relevant specification for that sub-system.

If you can help with deciding which is best and the advantages and disadvantages of each, I'd greatly appreciate it. Or perhaps there's a better way of doing it?

Thanks