Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feeder.news-service.com!feeder.news-service.com!nntp-server.pubsub.com!news.glorb.com!postnews.google.com!i42g2000cwa.googlegroups.com!not-for-mail From: "Gints Plivna" Newsgroups: comp.databases.theory Subject: Re: Database design ideas or templates... Date: 30 Jul 2006 14:09:14 -0700 Organization: http://groups.google.com Lines: 26 Message-ID: <1154293754.645478.107460@i42g2000cwa.googlegroups.com> References: <1153357385.658621.103740@m73g2000cwd.googlegroups.com> NNTP-Posting-Host: 83.223.131.240 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1154293759 30265 127.0.0.1 (30 Jul 2006 21:09:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 30 Jul 2006 21:09:19 +0000 (UTC) In-Reply-To: <1153357385.658621.103740@m73g2000cwd.googlegroups.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.0 WALL Complaints-To: groups-abuse@google.com Injection-Info: i42g2000cwa.googlegroups.com; posting-host=83.223.131.240; posting-account=dghNNQ0AAABoYFdkrBcnDisM167T3pNz Xref: dp-news.maxwell.syr.edu comp.databases.theory:43763 romantercero@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