Re: File Normalization Question

JULANNFRA@aol.com wrote:
> 
> Hi Everyone, I have a question (obviously).  I am looking at this software
> package that has redundant information within some of its detail files. 

Julie,

Is it redundant data or override/point of occurance data.  The reason I
ask is that our order entry system contains an item cost.  Now this
should be derived from the item master/balance whatever file.  We keep
it to capture the cost at point of order picking.  There are times when
point of occurance data is required.

It is not considered redundant since an hour later a shipment may come
in which changes the cost of inventory. But since this order is in
transit it is no longer in inventory and should not be affected by
subsequent changes to the inventory value.

Our data base is third normal form and from the surface it would appear
there is redundant data, but in fact there isn't.

-- 
===================================================
James W. Kilgore   | Progressive Data Systems, Inc.
President          | 311 31st Ave SE
(206) 848-2567     | Puyallup, Washington 98374 USA
qappdsn@ibm.net    | http://www.ultimate.org/PDS
===================================================
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *