John Bartow
john at winhaven.net
Wed Jun 18 10:35:22 CDT 2008
I recently had pull data from a contact mgt. app's database where the normalization brought up a question in my mind. The phone information was normalized as: tblPhone: fldPhoneID (PK) fldPhoneTypeID (FK) fldAreaCodeID (FK) fldPhoneNumber fldPhoneExtension tblPhoneType: fldPhoneTypeID (PK) fldPhoneType tblAreaCode: fldAreaCodeID (PK) fldAreaCode To be consistent with this level of normalization wouldn't it make sense to have the first three numbers separated from the back 4 numbers? The first three would be very repetitious also. So the table would appear as: tblPhone: fldPhoneID (PK) fldPhoneTypeID (FK) fldAreaCodeID (FK) fldPhoneNumberPrefixID (FK) fldPhoneNumber fldPhoneExtension tblPhoneType: fldPhoneTypeID (PK) fldPhoneType tblAreaCode: fldAreaCodeID (PK) fldAreaCode tblPhonePrefix: fldPhoneNumberPrefixID (PK) fldPhoneNumberPrefix