>>>To me it looks like they're distinct lookup values per column. A star schema might be enough to do in a single table:
>>
>>LookupGroup, lookupValue, description
>
>I looked up star schema, but it wasn't as clear to me as I had hoped. Does it mean that I would have to have a dimension table for each unique LookupGroup in the driver table? How is this better?
I didn't say it's better (though IMHO it is:). In a star schema you use a single table for multiple lookups. A simple example would be:
lookupGroup lookupValue Description
----------- ----------- -------------------
Gender F Female
Gender M Male
AgeGroup 1 0-10 years old
AgeGroup 2 11-20 years old
AgeGroup 3 21-30 years old
AgeGroup 4 31+ years old
select lookupValue as 'Gender',Description from myStarTable where lookUpGroup = 'Gender'
To get individual groups as a table. If you cross join 'individual group table's you get all the combinations possible.
Cetin