Re: Data Normalization

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

On Oct 17, 12:33 pm, "Jeff Boyce" <nonse...@xxxxxxxxxxxx> wrote:
If you are saying that the [ClientName] column contains a text string, then
you will be repeating that same string for each record involving the same
client.

Why would this matter?

Peoples' names change.  Data entry is done with errors.  Do you want to have
to review EVERY record in your table and update a changed (or incorrectly
entered) [ClientName], or would you rather go to the [tblClient] table and
change it one time?

The former approach increases the risk of having rows for:

    John Doe
    J.J. Doe
    John J. Doe
    Johnnie Doe
    J. Dough

So what?  So Access will NOT know that these are all the same person unless
YOU know they are all the same person and tell it.  Much easier to have a
single record in a tblClient, with a ClientID, and store that ClientID in
each of the records you posited in your question.  Less risk of data
integrity issues.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"R Tanner" <tanner.ro...@xxxxxxxxx> wrote in message

news:85d75ccf-b252-4120-95f3-f69122149ea6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Since the whole purpose of data normalization is to ensure the
integrity of your data and eliminate duplications, if you have, say,
one column in a 10 column invoices table that tracks the name of the
client and that is the only aspect of the client that you track, you
would not want to make a separate table for it would you?  since you
only track that one piece of information on the client, you could keep
it in the invoices table - there would be no benefit to an additional
table.- Hide quoted text -

- Show quoted text -

But just to clarify, John Doe is not the same on all records. 30% are
John Doe while another 30% are Jack Johnson and then the remaining 40%
are John Smith.
.

Relevant Pages

  • Re: Housing Counselor Jobs in Fresno - We will train
    ... Bilingual Housing and Delinquency Counselor ... and negotiating individual workout plans with the lender. ... and analysis of the client, you may determine which of the lenders are ...
    (soc.culture.hmong)
  • Re: client server socket interaction (inetd)
    ... Servers never ask the client for information: ...   can accept several commands, with 'quit' being one of them. ...   what the server returns. ... the server must always return a response to every possible request ...
    (comp.lang.python)
  • Re: Data Normalization
    ...     John Doe ... one column in a 10 column invoices table that tracks the name of the ... client and that is the only aspect of the client that you track, ...
    (microsoft.public.access.gettingstarted)
  • Re: Help ZFS FreeBSD 8.0 RC2 Write performance issue
    ... by a Commit RPC to force them to disk, done by the client when it ... When you set this sysctl, the NFSv3 server (sys/nfsserver, not the ... - The client may then choose to not bother with a Commit RPC. ...    though, since if it does make a significant difference, it ...
    (freebsd-current)
  • Re: Data Normalization
    ...     John Doe ... one column in a 10 column invoices table that tracks the name of the ... client and that is the only aspect of the client that you track, ...
    (microsoft.public.access.gettingstarted)