[AccessD] DB Design Question - too much normalization?

jack drawbridge jackandpat.d at gmail.com
Wed Mar 16 23:30:41 CDT 2011


Rocky,
Just curious, but why 3 tables?
jack

On Thu, Mar 17, 2011 at 12:16 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> 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/>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list