Re: Database design ideas or templates...
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Thu, 20 Jul 2006 23:28:00 GMT
Message-ID: <4kUvg.12964$pu3.297946_at_ursa-nb00s0.nbnet.nb.ca>
>>Hi, I'm not sure if I'm posting in the appropriate group but here
>>goes...
>>
>>I'm currently in the process of designing a new warehouse management
>>system from the ground up as our old one in MS Access is inadequate,
>>slow and poorly designed. I know I'm not the first person in the
>>world with the requirements I have so I am looking for some database
>>templates to get some ideas and avoid having to reinvent the wheel.
>>
>>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.
>>Thanks before hand!
>
> You didn't mention your db of choice. Nor your OS. Nor your RAM.
Date: Thu, 20 Jul 2006 23:28:00 GMT
Message-ID: <4kUvg.12964$pu3.297946_at_ursa-nb00s0.nbnet.nb.ca>
Paul wrote:
> > romantercero_at_gmail.com wrote: > >
>>Hi, I'm not sure if I'm posting in the appropriate group but here
>>goes...
>>
>>I'm currently in the process of designing a new warehouse management
>>system from the ground up as our old one in MS Access is inadequate,
>>slow and poorly designed. I know I'm not the first person in the
>>world with the requirements I have so I am looking for some database
>>templates to get some ideas and avoid having to reinvent the wheel.
>>
>>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.
>
>>Thanks before hand!
>
> You didn't mention your db of choice. Nor your OS. Nor your RAM.
What the hell makes you think any of that has relevance to a theory newsgroup? Received on Fri Jul 21 2006 - 01:28:00 CEST