Create A Database For A Catalog?

Create a database for a catalog. The database columns will be SKU (Stock Keeping Unit), DESC (Description), and UCOST (Unit Cost). The database will have 10 entries (rows) with the following SKUs:

121, 232, 343, 501, 560, 603, 606, 747, 800, and 988.

You may use any descriptive text for DESC. I suggest limiting the description to 20 or fewer characters. The unit cost will be in dollars and cents. The amount is up to you, but keep the it in the range $0.50 to $100.00. Also, keep the item and the price somewhat realistic.

Create a form to access the database. There will be 2 input boxes, one for the SKU number and one for quantity. There will be 3 output boxes, one for the Description, one for the Subtotal (price x quantity), and one for the Total Cost (a sales tax of 7% added to the subtotal). There will be 1 button to retrieve the data and display the result (Description, Subtotal and Total Cost).

Here is what I have..

Code:

<%
' global variables
dim strDesc
dim ucost

[code]....