[AccessD] Slow day - normalization discusion

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





More information about the AccessD mailing list