Re: Database design ideas or templates...

Hey great! The databaseanswers.org site is pretty neat. I've been looking for a site like this on google but had not been able to find one.

If you or anyone else knows more sites like that one please post them. Or post sites that deal with a specific implementation in detail.

I have looked at purchasing an off the shelf package but the sales people are flexible here so business rules are often bent a bit and people are constantly comming up with new ideas that could not be followed up with something off the shelf with out shelling out a lot of $$$. Also, in my experience companies that make this sort of software treat the customer as a cash cow, making sure that they are alway needed even if it means implementing something in an akward maner. Like a leech. So it makes sence to build it our selves since we understand the business rules and have the experience with the the other warehouse inventory system we are replacing.

Thanks!
:-D

David Cressey wrote:
> <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 - 17:48:50 CEST