Re: Database design ideas or templates...

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!
a book will help you : The Data Model Resource Book Revised Edition Received on Mon Jul 24 2006 - 07:02:56 CEST