Re: Database design ideas or templates...
Date: 30 Jul 2006 14:09:14 -0700
Message-ID: <1154293754.645478.107460_at_i42g2000cwa.googlegroups.com>
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!
Data Model Patterns Conventions of Thought by David Hay The Data Model Resource Book by Silverston, Inmon and Graziano
Gints Plivna
http://www.gplivna.eu
Received on Sun Jul 30 2006 - 23:09:14 CEST