I agree with both Jeff and Steve, but I'd like to add that their comments apply to more than just Inventory Management System. Database design is not something that should be taken lightly. A poorly designed database can break a system, especially as the number of records increases.
The book referenced by Steve is a great book. I have the SQL Server 2005 version. It will certainly open your eyes to what you need to consider in your design.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]