Database normalization & design for inventory system

We have a legacy inventory (stock control) database that we are migrating from Foxpro to VB.Net/MS SQL Server.? The current table design is poor, for example? on-hand values are stored in the stock table rather than being calculated on-the-fly from a transaction table. You will review the existing tables and propose a new normalized design that incorporates a stock transaction table.? This project if done well will lead to more work in terms of helping to deliver the new solution, so you MUST have the following skills: VB.Net (Visual Studio 2008) MS SQL Server 2005