Re: Microsoft Access, Double Data Entry and breaking the Normalization rule

"Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx> wrote in
news:up2p53p5kd7dlnuckscti79klvaula90ki@xxxxxxx:

"hippomedon@xxxxxxxxxxxxxx" <hippomedon@xxxxxxxxxxxxxx> wrote:

On the other hand, it seems that it might be easier to
"de-Normalize"
the table slightly to have a [DtaRspn1] and a [DtaRspn2] field.

This is not denormalizing. You have the same data but entered
twice. It's perfectly legitimate to do this.

At the concept or overview lefel this is similar to storing the
cost and price of an item when you sell the item. After all the
cost and price could change moments after the transaction is
entered.

Yes, but there are different ways to store the data:

1. double the fields in a single record.

2. have two records in a single table, with identical structure.

3. have two separate tables with identical structure.

4. have a main table and then a narrow side table that records only
the discrepancies, one field per record.

The worst of all seems to me to be the 1st choice, which is, I
believe, what the OP is considering.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Caster levels, schools and prices for artifacts
    ... Craft Wondrous Item, ... Price 107824 gp. ... for divine spellcasting ability is offset by the cost of damaging ...
    (rec.games.frp.dnd)
  • Re: von Mises Institute on Henry George
    ... Are you trying to imply that carrying cost forces the car dealer to ... put the cars on the market, and work to get their highest market ... of that cost back from sales due to the 100% tax, ... price of $1, or "take what you can drive". ...
    (sci.econ)
  • Re: Will Dell OEM Vista install on another Dell PC?
    ... The cost of the media is completely immaterial to the price of the software ... Justify stealing for me. ... We're talking about the customer paying for one hamburger and stealing ...
    (alt.sys.pc-clone.dell)
  • Re: F, etc.
    ... that a "cancer only" med can get away with. ... I can't figger why they cost so much. ... that is part of every med's price. ... a taste of my pre-January life again. ...
    (alt.support.chronic-pain)
  • Re: F, etc.
    ... that a "cancer only" med can get away with. ... I can't figger why they cost so much. ... that is part of every med's price. ... a taste of my pre-January life again. ...
    (alt.support.chronic-pain)