Data Normalization

I understand what the purpose and value of data normalization is, but
I just have one thing I am confused about. If you split up a table,
then it will create two tables. The child table will have a lookup
column to the parent table, which will have whatever value is
applicable that relates that given record to it's parent. What I
don't understand is how that is more efficient. In fact it seems to
duplicate the data if anything...
.

Relevant Pages

  • Data Normalization
    ... I understand what the purpose and value of data normalization is, ... applicable that relates that given record to it's parent. ... duplicate the data if anything... ...
    (microsoft.public.access.developers.toolkitode)
  • Re: How to copy other fields after combobox look up
    ... One of the basic rules of data normalization is that you do not duplicate the same data across multiple tables. ...
    (microsoft.public.access.queries)