asked
Normalisation link table...
I need a vehicle table and a vehicle attributes table, the link table is to allow multiple attributes against the same vehicle. I need to repeat some attributes so that they form a count i.e. wheel, repeated 4 times for a car, 2 for a motorcycle. If I try adding the attribute 4 times I get an error. I need to do it this way so that one of the wheels can have a different value if required, say 'Spare'. Can this be accomplished or am I just thinking of this the wrong way? Thanks.,
Instead of adding the wheel attribute 4 times, it would make more sense to me to add the wheel attribute once, with a quantity of 4. I would do so by adding a Quantity column to the link table.
16 People are following this question.
