[dba-Tech] database

I'm sorrry, but I just can't help it. 

Every time I see POS,  the first thing I think of is a rude derogatory term for something which 
is very badly designed/built.  I'm sure you know the expression I mean :-)

It's only on reflection that I interpret it correctly.

-- 
Stuart 

On 26 Jan 2013 at 11:57, Jim Lawrence wrote:

> Hi John:
> 
> Right on; definitely the royal-jelly of tech work. 
> 
> My specialty is POS design and this database is one hundred percent mine,
> over twenty years of work, so I can blame no one else if everything does not
> work a hundred percent, every time. :-)
> 
> Jim 
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of John Bartow
> Sent: Saturday, January 26, 2013 11:33 AM
> To: 'Discussion of Hardware and Software issues'
> Subject: Re: [dba-Tech] database
> 
> This is the stuff I love to do!
> 
> But I will not fog the waters for you.
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Saturday, January 26, 2013 12:45 PM
> To: 'Discussion of Hardware and Software issues'
> Subject: Re: [dba-Tech] database
> 
> Those were my initial thoughts but then there would be issues with inventory
> and the related accounting. 
> 
> Then there is the issues with whether a client ever had an unpaid invoice, a
> bankruptcy or even association issues that will a have to be rolled forward
> and records will still have to be flagged and situations noted. There is
> also the thresholds that may establish a client, supplier or even staff as
> "rated highly", "to watch" or "do not do business with" as incidents before
> the five year cut-off must be carried forward. 
> 
> Some inventory has been active for twenty years while other items not...
> Then there is the accounting, security and transaction files. Then there are
> the issues of how much should be carried forward, in summary files... The
> clients still wants to be able to chart activity even though it may have
> been rolled up to five years...setting averages, viewing trends,
> inventory/equipment quality, and so on.
> 
> Then there has been a lot of bad practices, especially in the accounting
> where a series of book-keepers were suppose to manage things...now the
> company has a real Chartered Accountant...a breathe of fresh air. 
> 
> As you are an expert at business practices any thoughts and cautions would
> be appreciated?
> 
> Jim
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Saturday, January 26, 2013 10:18 AM
> To: 'Discussion of Hardware and Software issues'
> Subject: Re: [dba-Tech] database
> 
> Modifying the relationships to cascade delete? 
> 
> Rocky
> 
> 
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Saturday, January 26, 2013 10:02 AM
> To: 'Discussion of Hardware and Software issues'
> Subject: [dba-Tech] database
> 
> Today and tomorrow I will be working on a huge database.
> 
> It has records going back to the late eighties and the client wants the
> whole system cleared except for the last five years. Clearing data is not
> difficult but leaving no orphaned records is. There are over a hundred
> inter-related tables and I have been planning this with the client for a
> couple of months and today is the day (the company's year-end).
> 
> Has any one else had similar experiences and any insights, recommendations
> and so on?
> 
> Jim
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>