Re: Database design ideas or templates...

<romantercero_at_gmail.com> wrote in message news:1153357385.658621.103740_at_m73g2000cwd.googlegroups.com...
> 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!
>

Check out this site. http://www.databaseanswers.org/index.htm

They have hundreds of kick-start databases ready for you to start with.

Many of the designs are implemented in Access. But the important thing is the table design (and perhaps the index design). These can be ported to any platform you like. Received on Thu Jul 20 2006 - 11:33:51 CEST