Add Product

Store employees should be able to enter a new product or update its details. These are

the minimum information that each product should have.

Product Name, Product Description, Price $($numeric data only$),$ and category that

should be selected from a pre$-$defined list, $\{$new arrival, on sale, featured, high

demand, normal$\}$ and displayed in a combo box to the user, the default category is

normal for simplicity a product belongs only to one category. Quantity which should

be numeric.

Each product should have the following:

$$ Name

$$ Brief Description $($Enable the text box to accept multiple lines of text$)$

$$ Category

$$ Price

$$ Size

$$ Remarks $($Enable the text box to accept multiple lines of text$)$

$$ Product ID which is a $10-$digit number given, is generated by the

system. When the user completes entering the product details the

system must display a confirmation message that confirms the product

has been successfully added to the database and displays the product

ID$.$

$$ At least one picture for marketing, you need to add a link to allow the

user to upload files. I might suggest that you have to upload at least

one picture for each product. You can save the file name in the

database. The filename should be like that itemIDimgSequenceNo, for

instance, if you have an item its id is $12345,$ and then the first image

file will be item$12345$img$1.$gif. The file itself could be saved in a folder

named as itemsImages.