Re: Normalization: Tables for Addresses?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In addition to all the advice you've already received, take a look at
http://www.databaseanswers.org/data_models/customers_and_addresses/index.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Peter Stone" <PeterStone@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:750288DD-DE70-448E-AFCF-0AB13055B279@xxxxxxxxxxxxxxxx
Novice/WinXP/Access 2003
Good Evening

With good advice from this forum, I have a normalized db with one-to-ones,
one-to-manys, and many-to-manys.

But, how do I normalize addresses. Northwind db doesn't help because they
give everyone a one-line street address and one phone number.

Each address is attached to an organization.

I presume:
tblStreetAddresses (with each line of the address in a separate record).
tblPostCodes (with PostCode as ID and fields for IDCity and Suburb).
tblTelephones (with fields Telephone and TelephoneType).
tblEmails
tblCities

Sometimes people share the same address and telephone numbers.

Will there be problems if one line of the address is the same as a
different
address?

Do I allow duplicates in the address field? There could be a 22 Rose
Street
in different suburbs.

Room 15
22 Rose Street
Any Suburb

Room 99
22 Rose Street
Any Suburb

22 Rose Street
Some Other Suburb

Or should the StreetAddress be in one field with lines separated by
commas?

Should the street number be in a separate field?

On the Net, I saw advice to put words like Street and Avenue in a separate
table...surely that's not necessary.

Thanks

Peter


.

Relevant Pages

  • Re: Normalization: Tables for Addresses?
    ... There is a one-to-one relationship set up under the business rules. ... is alright to have them as separate fields within the same record. ... tblPostCodes (with PostCode as ID and fields for IDCity and Suburb). ... 22 Rose Street ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Normalization: Tables for Addresses?
    ... There is a one-to-one relationship set up under the business rules. ... is alright to have them as separate fields within the same record. ... tblPostCodes (with PostCode as ID and fields for IDCity and Suburb). ... 22 Rose Street ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Normalization: Tables for Addresses?
    ... I'll offer the business scenario that ... Microsoft IT Academy Program Mentor ... tblStreetAddresses (with each line of the address in a separate record). ... 22 Rose Street ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Threads question
    ... The target thread should check this variable regularly, and return from its run method in an orderly fashion if the variable ... inner classes so both the start and stop button actions can see the ... could do this will three separate classes. ... Any advice on this would be appreciated ...
    (comp.lang.java.programmer)
  • Re: Changing Linux Distros
    ... GS>> A few weeks ago I asked for books and advice regarding some Red Hat 9 ... GS>> Is it possible to just change distros like this without losing any user ... GS> repartition the drive so that you have a separate / partition (I find that ...
    (comp.os.linux.misc)