The Database Design Resource Center

Inventory system

by Iftikhar
(Pakistan, lahore)

I designed a database on SQL server, this is a inventory system and POS System. I stored all Purchase order, Purchase Invoice, Purchase Return, Stock in Stock out and Stock Adjustments.

then Point of Sale (POS)

Sale, sale Return, Sale replacment, Sale booking, Sale invoice.

All kind of entries in a single table named as Documents.

This table has more than rows 10,00000 in just two years.

NOw a days, I am thinking about separation of Purchse, and sale.

Comments for Inventory system

Average Rating starstarstarstarstar

Click here to add your own comments

Apr 20, 2018
free NEW
by: Anonymous

This is really great product which you share here for the user.

Oct 13, 2015
I need it NEW
by: Anonymous

I also need a custom solution like this but I am not familier with technology much, can any one guide me how to do it myself?
write my essay for myself

Oct 12, 2015
Good post NEW
by: Merritt Howe Sr.

Hi! You have an amazing niche site!
May I ask to do a favor for me, please? I also have a site (about Halloween Costume Ideas) and it will be great if I cound share one of your article on my blog.

Is it possible? I will link for you as an author! Thanks for answering!

Sep 02, 2015
Inventory system NEW
by: Anonymous

Cutting edge stock control frameworks depend upon scanner tags, and possibly RFID labels, to give programmed distinguishing proof of stock items. In a scholarly study[1] performed at Wal-Mart, RFID decreased Out of Stocks by 30 percent for items offering somewhere around 0.1 and 15 units a day. Online Essay Writing Service .Stock articles could incorporate any sort of physical resource: stock, consumables, settled resources, circling instruments, library books, or capital gear.

Jul 24, 2015
True information is shared NEW
by: Rizzo

Physical training perform a fundamental part for the improvement of our general public. It is a key of enhancing mind, heath, and additionally certainty. In this manner, we ought to get this training for their better future. We are offering write my essay cheap to your scholastic work.

Apr 10, 2015
Best help for students NEW
by: Carrie T. Banks

Great! I was looking for exactly the same thing all day yesterday. I really wish more people write about it. I really appreciate the post.

big school

Jan 31, 2011
POS Database design required
by: Anonymous


I need the database structure of POS System. If you have then help me.

Thanks in advance.

Jun 07, 2010
by: toetoeag

I need database design for Inventory Control System and POS System. If you have, I want it.

Please help me.Please hurry up.Because I will give my database design for my thesis.

with regards,

Sep 24, 2008
What's is your solution?
by: Anonymous


Did you manage to fine tune the database design? If yes, please share the experience with us. alternatively, we can exchange the ideas by email (mdyameen6 at gmail dot com).

Even I have been working on retail applications since quite long.


Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Worst Database Design Experience.

Exclusive interviews with:
Steven Feuerstein, PLSQL expert
Donald Burleson, Top IT consultant

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:

What visitors say...

"I just stumbled accross your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site. Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Database Normalization eBook:

Database Normalization eBook

Copyright © / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
Disclaimer: does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.