Re: Database design ideas or templates...
Date: Fri, 21 Jul 2006 00:10:51 +0100
Message-ID: <c530c21k2sr3l7tepjt1uh3f7emj38v13b_at_4ax.com>
Paul <paul_at_see.my.sig.com> wrote:
> > The basic requirements for the database are that it store transactions
> > made so that to get a current inventory count need to add up the
> > inbound and outbound transactions. This is to say that it be auditable.
> > Another requirement is that products cane come grouped and can be
> > manipulated with one group ID or handle for convenience but in outbound
> > transactions it should be possible to send only a unique product from a
> > group.
> You didn't mention your db of choice. Nor your OS. Nor your RAM.
> If you wish to go with Oracle (and maybe PostgreSQL) and have a small
> system, you might want to look at www.compiere.org which is an ERM
> system for free.
You could also try this link if you wish to run it on Firebird (a cheaper and less resource-greedy db server than Oracle, in fact it's free, even for commercial use!).
http://www.janus-software.com/compiere_dl.html
Paul...
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 9.2.0.1.0 (Enterprise Ed.) Interbase 6.0.1.0; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, as a courtesy to those who spend time analysing and attempting to help, please do not top post.Received on Fri Jul 21 2006 - 01:10:51 CEST