[AccessD] DB Design Question - too much normalization?

Rocky Smolin rockysmolin at bchacc.com
Wed Mar 16 23:16:40 CDT 2011


Dear List:
 
I'm putting together an app for a client that will have three tables that
will have address information.  There will probably be no overlap.  
 
Normally I would put address, city, state, zip, main phone, main fax, etc.,
fields into each table. 
 
Is there any reason to make an "address" table with an autonumber PK and an
FK to the address table in each of the other three tables?
 
 
 
MTIA
 

Rocky Smolin

Beach Access Software

858-259-4334

Skype: rocky.smolin

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 




More information about the AccessD mailing list