Re: Help! I can't support normalization

phantomtoe_at_yahoo.com (Rowan) wrote in message news:<4bbf8d70.0211010748.727d38ef_at_posting.google.com>...
> An
> example is yesterday I was struggling with an aspect of concatenating
> an employee Last Name and a First Name. I displayed a list of
> concatenated names in a datacombo but wanted to store the Employeeid
> in a customer table. 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. I didn't have an answer. Could
> anyone give me an answer? I would like a well supported argument to
> put this silliness to rest. I appreciate anyone's thoughts and ideas.
> Please enlighten me!

Suppose you have

table person (

   name varchar2 unique key,
   ...
)

then

insert into person (name) values ('Paul Smith'); insert into person (name) values ('Smith, Paul');

is legitimate from constraint perspective, but obviously semantically invalid. Received on Sat Nov 02 2002 - 02:56:52 CET