朋友们帮帮忙，我在大马留学，我刚接触VB。NET不久，老师就给一个这个assignment，这让我不知道该怎么下手，高手们帮下拉，会的就帮下忙, 关于超市的系统
CASE STUDY
You are asked to develop a Visual Basic.Net program for a Supermarket. It should allow the cashier to receive the products from customers and generate a sales receipt. Each item has its own product code. Your program should allow the cashier to select the product code from the system and display the price. Once all items have been selected, your program should generate a customer’s sales receipt. Your program should have the following product category in the database such as:
v Dairy Productsv Vegetablesv Soft Drinksv Household Productsv Fruitsv Biscuitsv Toiletriesv Baby Products
Each product category has a unique product code as listed below:
|
Product-Category |
Product Code |
|
Dairy Products |
1 |
|
Vegetables |
2 |
|
Soft Drinks |
3 |
|
Household Products |
4 |
|
Fruits |
5 |
|
Biscuits |
6 |
|
Toiletteries |
7 |
|
Baby Products |
8 |
Your program should have the following modules:
1. Login Module
The login module is used by the systems administrator and cashier to access the system. This module should allow the systems administrator to add new staff, update and delete records.
|
Table Name : |
Login |
|
Field Name |
Data Type |
|
Username – Primary Key |
Text |
|
Password |
Text -Min 8 characters |
|
Name |
Text |
|
DOB |
Date |
|
|
Text |
2. Product Module
This module should allow the systems administrator to add, update and delete products from the database. You should have a search function to search for a product category. You should also be able to add more product categories into the database.
|
Table Name : |
Product |
|
Field Name |
Data Type |
|
PCode – Primary Key |
Integer |
|
ProductCategory |
Text |
|
Table Name : |
ProductType |
|
Field Name |
Data Type |
|
No – Primary Key |
Autonumber |
|
PCode - Foreign Key |
Integer |
|
Typecode |
Integer |
|
Description |
Text |
|
Cost |
Currency |
3. Payment Module
The payment module allows the cashier to key in the product code and display the total cost to be paid by the customer. A receipt is generated once all items have been keyed into the system. Furthermore, a discount of 15% is given to customers who purchase an amount of RM100 and above.
|
Table Name : |
Payment |
|
Field Name |
Data Type |
|
Counter |
Autonumber |
|
TransactionNo |
Integer |
|
TypeCode – Primary Key |
Text |
|
Description |
Text |
|
Cost |
Currency |
|
Date |
Date / Time |
4. Report Module
This module is used to print the following hardcopy:
a) Receipt which is given to the customer once they have made their payment. (See Appendix A).
b) Cash Collection Report for a given date range e.g monthly or weekly cash flow (see Appendix B).
Appendix A
a) Sample Receipt
TPM Supermarket
Receipt
Transaction No : 1
Date : 3/5/2007
PCode TypeCode Description Cost
7 111 Shampoo 10.00
7 112 Soap 5.00
3 113 Coke 2.20
Total 17.20
Discount (%) 0
Nett Total 17.20
Thank You
Please Come Again
Appendix B
b) Sample Cash Collection Report
TPM Supermarket
Month: September
Cash Flow for the month of September: RM 2000
这是关于超市及数据库系统的,表中有些内容是应当在数据库中表现的,如NAME等
