Sales and Inventory System of Shoes

Inventory system of a shoe warehouse. From supplier delivers shoes to warehouse(add) then warehouse to mall branches (minus). It must contain Stock No, Name of the shoes, Color, Sizes (5-12, no half sizes) and Availability of the shoe. The sales must contain the summary of all ordered shoes per branch. The front end must be in Visual Studio then the back end is in oracle 11gr2. Add what you think is necessary to the system.