By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,122 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,122 IT Pros & Developers. It's quick & easy.

Help with Store Information Database Design

P: 228

I am designing a small database with access and (will be upgraded to sql server soon). The database is for store keeping in this fashion:

Items come and are registered. Then they must be placed in stores/shelves/layers. That is in a single store, we have shelves and each shelve have layers in it.

I did the tables but I donno what to store for layer information so that the program can know which layer is empty, half full or full and when new items arrive, it automatically suggests to the store keeper where to put the items. The items are very different in size, like computers, tools to medical equipments.

Any idea on how to design the tables?
Mar 19 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
The layer table should have, at minimum
  • A unique ID for the layer
  • Which shelf the layer belongs to
  • How many items can go on the layer to be considered full
Mar 19 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.