[maddinat0r]

Quote:

Originally Posted by Jay_ It would be wrong to normalise a vehicle database table containing fields represented by vehicle modifications. Patchwerk's post is correct: you do not need to split these off because the number of vehicle modifications is not a dynamic amount. There is always a maximum of 9. You'd only need to normalise this when there would be a dynamic amount of modifications, or the fields could potentially contain repeating data.

Not normalizing this is a waste of memory. Does every vehicle always has all 9 mod slots filled? No. So most of the time your "mod" fields are empty, thus having the value "0" -> repeating data.