G
George
I have to design a DB which contains a parts table with components as records
and tables which contain information about these components. Now, the
different component types may have a different number of attributes.
What is the better approach?
Keep all parts in one table with the maximum number of fields determined by
the part with the maximum attributes (this would leave many fields empty) or
keep the parts in separate tables. How would I set the relation between the
parts table and the different component tables?
Any hint or help is highly appreciated.
and tables which contain information about these components. Now, the
different component types may have a different number of attributes.
What is the better approach?
Keep all parts in one table with the maximum number of fields determined by
the part with the maximum attributes (this would leave many fields empty) or
keep the parts in separate tables. How would I set the relation between the
parts table and the different component tables?
Any hint or help is highly appreciated.