ok guys like I said the project is not mind. A friend of mine ask me for help so I thought I would post it up here to get some help. So here is her proposal for the project, its an end of the year assignement. U guys are goint to have to do a little bit of reading though.



The main page or cover page of the system will be simple but attractive containing all of the functions available on the initial page. However, only some will be available depending on the choices that are made. This will allow for more accurate information and for the files to be complete. Each product will have a brief description included in the product inventory file. You can choose to just view the descriptions on the page, view only the prices, or you are able to look at the prices and quantities that are in stock, on order or being shipped in the product inventory table.
When you are choosing your products, you will have option buttons, when the option is chosen it will give you a running total so that you are aware of the prices. When you have made all of your selections you will go to the buy it choice. This will then give you a page to fill out your information and will give you a copy of the invoice to print out for your convenience and records.
You will also be able to delete an item if you no longer wish to purchase it. A delete button will be at the bottom of the page, which you may select after clicking the option already selected of the item you wish to dispose of.

SQL statements will be present in order to keep the information in order that is needed. Also it is an easy way to access the information and to keep it updated and current, incase there is a need to have an output of a specific customer numbers file, or a specific order number incase any problems arise.

The validation part of the program will cause the program to be activated, checking to make sure that all of the information that is needed was entered. If there is a blank in the form there will be a message box that pops up telling you what you need to complete. Then you can click ok and enter the information again and submit your data.

Once the information is entered and all the fields have been validated and authorized by the system, you will be able to see a report summary of all of the information that you entered. This will only be available after your information was validated or there was a correct customer number entered. Either way, your address will be saved and a bill sent to you.

The blanks are not the only thing that you need in order to complete the process. You need to make sure that the credit card is a valid number and that you don’t send the product to the person without a valid credit card number, which will end up in you not getting any money. This would cause bankruptcy. However, this is something that is done by Master Card. My system will use the self-checking number system in order to provide you with valid customer numbers and the information that is correct for that specific number.

A customer records page will be available for problems that may occur later and a reference is required. It will also keep track of the customers problems just incase someone is trying to create a scam somehow. This will be a page that will be available only to those to whom are authorized and have a password.

The calculating program will provide you with the total of the purchase, and will determine the price of shipping and handling depending on the location you are having it sent to, or if you are picking it up yourself.
The amount of tax will also be determined once the purchases are selected, because depending on the amount spent, will ascertain the total tax. Since the products are found in Ontario the taxes will be as follows, 7% GST and 8% PST.

In this type of program there won’t be a huge number of fields that will be default, province will be one of the default fields. Even though the default fields will be used where they are possible; in a software and hardware sales system it will not be very often.

In reality you want it to check the inventory of the products to make sure it is there before it is sold it to someone but in this situation because there isn’t an actual company inventory it is unavailable.


Big_Bolo