Re: Help! I can't support normalization

Rowan wrote:
>[....] When I asked the programmer for help, he said just concatenate the
>names in the field in the employee table and call it "name". I said no.
>He asked why.

Because you may want separate indices on the first and the last name. This may be the case if somwhere in your WHERE clauses you only compare to the first name or only to the last name. If this is not the case then you have to wonder if as far as the database is concerned the whole name should be considered atomic and then this would in fact not be a normalization problem.

• Jan Hidders