Re: Normalization Question

>> Notice the field just above the phone number, it's a flag th­at
>> tells what the type of phone number is.

I see, so "H]C]C" would allow one to have one home, two cell and no international #s.

Is there a db level mechanism that ensures changes to a thing will be reflected or synchronized with other representations of the same thing in the db even if they are one of mulitiple values in various fields?

Also if some phone# have suparts (ie extentions, hours of operation, alternate number, etc), how would the sub parts be stored without redundancy? Received on Wed Feb 02 2005 - 23:11:06 CST