Normalization issue

[rfigley]

I'm reorganizing a databse and need to check something. I have rows in a table that have some duplicate field data like gender (male, female) and occupation. The rows (example below) will be retrieved and displayed according to the Grp ID. Would it be necessary to separate these out to eliminate dupication (male, female, occupation) data with that guideline?

Person Name | Gender | Occupation | Car Model | Age | Grp ID

Thanks

[rfigley]

A little follow up here:

Duplicates are with the Gender field (several of each in the table so those duplicate of course) the occupation and the Grp ID. For some stupid reason I was thinking each name had a unique Grp ID, but of course that is not the case as it is a list of people separated by groups. Fortunatley I have a field not mentioned here that is unique number for each person called "respondent" so I guess that field should be joined with a table to link the groups.

[klansman]

hi!

i really don't understand your question...

how do you expect to normalize the gender field any more? i don't seem to understand... can you explain further?

[]