RE: Normalization was Left AS/400 and Returned

I remember the first time I saw a programmer throw his hands in the air. 
After working on the rules for payroll and finally  getting a payroll almost
perfect, he was told that one man made a nickle an hour over the bill
because the man had washed the boss's car on Saturdays during the Great
Depression. 

I always remember that when people discuss business rules.
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 05/04/05 17:37:25
To: 'Midrange Systems Technical Discussion'
Subject: RE: Normalization was Left AS/400 and Returned
 
> From: James Rich
>
> > Would you store the data one flag per warehouse/date, with the
warehouse
> > and date as the keys to the file, or would you store the information
in
> > an array, perhaps by year or by some other arbitrary unit of time?
>
> Neither.  I'd find out what the rules are for when it is open/closed
and
> code those rules.  No file/table needed.  In fact, I've already done
this.
 
There are no hard and fast rules, James, that's the point of a
maintainable file.  Some warehouses are open 24/7.  Some are open based
on available labor, or on inventory movement.  Some are available M-F,
some Saturday.  Some are seasonal.  Some are not open on certain legal
holidays.  Some are open when the tide is high.  Which are open when is
subject to change on a monthly, weekly or even daily basis.
 
Coding every possible rule would be counterproductive, especially since
it could not handle the ad hoc changes.  A table could just as easily
summarize those rules.
 
Joe
 
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
 
 
.