For the web store you designed in 3371, create the inventory system necessary to record on-line purchases from your store. This tasks involves three specific tasks:

1. Create a web environment for performing the tasks discussed below. This start page should be named a6.htm
2. Create an Inventory Master database

   This database contains the relevant fields for:

   1. Product Number
   2. Size
   3. Color
   4. Quantity-on-hand

   The primary key is the composite of Product-Size-Color.

3. Create the Add, Modify and Delete capabilities for the Inventory Master
4. Create the asp program to post the online order to the Inventory Master (i.e., reduce the quantity-on-hand by the purchase quantity. When creating the response page, be sure to note any unfilled or partially filled orders)
5. Create a query program to view the inventory status of any product

Return to Parks' DISC4372 homepage