Online Wine Shop System Computer Science Essay

Published:

"The Wine Select House"- a private owned wine shop-has been providing a wide range of wine on varies of item. The wine shop is usually sales at least 200 bottles of wine everyday for walk in customers. All customers can be registered as members to obtain more special offer during seasonal greetings. It is provided with 5 workstations to proceed the customer details, record sales of wines, to search for wines in stock and to automatically update the stock levels when sales are made. All customers registered details are recorded on the local computer system that stored as customer in numeric order according to incrementing for every new customer. There are approximately about 3000 customer's records have been accumulated for the past 5 years.

All the workstations are provided for staff use only. These workstations provided the facilities including search for the type of wine, location from product number or keyword. The workstation will also be used to record sales, the cost of purchase, update stock levels when a sale is made automatically and notify the staff when the stock level fall below a preset value. Besides, the workstations are used to record the customer information, issue the payment receipts and order the books for the customer if the gifts are out of stock.

Lady using a tablet
Lady using a tablet

Professional

Essay Writers

Lady Using Tablet

Get your grade
or your money back

using our Essay Writing Service!

Essay Writing Service

In the past few year, the company grow is relatively small and there are provided with many choices for the customers especially online shopping. The shop manager is planned to gain more revenue by installing the online gift shop system allowing the wines can be sold in the worldwide and in the local. In order to provide the same privileges for the valuable customer during online system, all customer information are needed to computerize. By the way, the member can still enjoy the special offer even in the online wine shop.

In order to solve the above problems effectively, a project "Online Wines Shop System" is proposed. The customer can be convenience search for wines in stock, order new items on behalf of themselves and sell the gifts on the internet. All information of wines database can be accessed through the Local Area Network (LAN) or even Wide Area Network (WAN) at all times.

The Wine Select shop only got one shop in the Tsim Sha Tsui Area. Their valued customers are mainly locally. As internet is becoming a part of our life, online shopping is commonly in use. Developing the above system can explore more potential customer so that increasing the company revenue as a whole, it can be not restricted locally and become a worldwide wine shop. Due the shop manager wishes to meet the company sales target at the end of this year, he expect me can finish this system for not more than four months. On top of this system, I decided to use a Structured System Analysis and Design Methodology (SSADM) to systems analysis and design.

Consider to the flexibility of the system, we use PHP technology as the front end interfaces construction plus the free-of-charged MySQL database management system to build the whole system. PHP plus MySQL can provide the flexibility and scalability for using this system on different popular platforms such as Linux, Windows, MacOS and UNIX. Furthermore, these software packages are open-sourced and free of charge, which can reduce the cost.

Key Phrases

The Select Wine Shop, 200 bottles of everyday, walk in customers, special offer during seasonal greetings, record sales of wines, search for wines in stock, customer details, to search for wines in stock, automatically update the stock levels when sales are made, the type of wines , location from, product number or keyword, the cost of purchase, issue the payment receipts and order the wines for the customer, online wines shop, same privileges, wines database, Structured System Analysis and Design Methodology (SSADM), Methodology, Local Area Network (LAN), Wide Area Network (WAN), Windows, MacOS, Unix, open source and MySOL.

Scope

For the scope of this new system, this system can let all potential customers purchase the wines through internet and easy access the wines details directly on the internet at any time. All these information can directly access through the GUI. Hence, the users can simply access and update the information about the customer and the gifts.

Objectives

Lady using a tablet
Lady using a tablet

Comprehensive

Writing Services

Lady Using Tablet

Plagiarism-free
Always on Time

Marked to Standard

Order Now

To provide the online wines service effectively and its efficiency. Finding out the facts about the new system needed and the solution for building up such better system. And, to prepare the feasibility study report.

Activities: Investigation on the problem; feasibility studies in technical, operational and economical; and proposed solution.

Deliverables: Feasibility Report. 1000 - 1500 words.

Schedule: 1 week (Completion Date - 12th Oct, 2010)

To provide the detail analysis, design and solution for the new system.

Activities: Analyze the new system by some development method and tools to obtain the functional specification and Database Design included all the data diagrams. Use prototyping skill to help to obtain the above result for a structured system approach.

Deliverables: Functional specification; Database Design and all the data diagrams. 1000 - 1500 word

Schedule: 2 weeks (Completion Date - 26th Oct, 2010)

To provide the detail physical design including application coding for the whole new system. It can provide the final product of the new system.

Activities: Physical system design, user interfaces, system construction, prototype and testing, and security setting.

Deliverables: User interfaces and system coding. Max. 2000 words

Schedule: 3 weeks (Completion Date - 16th Nov, 2010)

Relevance of other courses

The courses Database Design and Development, Business System Design, Business System Analysis, Management Business Project and Principle of Web page design will provide relevant sources of material for the project.

To provide the detailed implementation plan for implementing the new system and some document for the new system used by customer.

Activities: Testing all the system modules include prototype; installation; training plan and maintenance plan.

Deliverables: Detailed system testing plan, implementation plan, user menu and maintenance menu. Max 5000 words.

Schedule: 3 weeks. (Completion Date - 6th Dec, 2010)

To provide the system control and evaluation method to the new system. Making the conclusion for the system and research the potential of the new system for the future development.

Activities: Evaluating the system comparing to the initial requirement to make to conclusion and find the potential of further development of the system.

Deliverables: Conclusion and evaluation report. Max 1000 words.

Schedule: 12 week (Completion Date - 23rd Jan, 2010 final submission)

Required resources

Access to libraries, Access to the Internet, Standard Pentium 4 PC, PHP application software, Apache, Windows XP home and MySQL database management system.

Initial references

Randy Jay Yarger, George Reese and Tim King, "MySQL and mSQL", O'REILLY.

Thomas Connolly & Carolyn Begg, "Database Systems, A Practical Approach to Design, Implementation, and Management (3rd Edition)", Addison Wesley.

Rob, Peter, "Database Systems: Design, implementation, and management", Cambridge.

Jeffrey L. Whitten, Lonnie D. Bentley & Kevin C. Dittman, "Systems Analysis And Design Methods (6thEdition)", McGraw Hill.

Online Shopping Database System: http://www.wineshop.hk/

Apache official website: http://www.apache.org

Critical success factors

Obtaining sufficient relevant information to determine a full set of requirements.

Obtaining sufficient relevant knowledge and skill set to implement the new system.

Chapter 1

Introduction

Company Background

"The Select Wine House" is one of the famous wine shop which local near the Tsim Sha Tsui MTR station in Hong Kong since 2000. They provide many kind of wine for their customer to enjoy with the wine. Customer can buy red wines, white wines, champagnes, ham, sausages and the original champagne glasses etc.

For the past 3 years, the number of sales was increasing steadily under the policy of Hong Kong Government. Now, the shop are sales at least 200 bottles of wine every day. For the last year annual meeting, the director forecast that the policy of Hong Kong Government will be changed rapidly as they are more preferable to choose the most convenience way in their lifestyle. Also from the sales report in the past few years, the growth of sales is quickly, Also the manager report that the staff is unable to spare the time to answer the customer phone call queries during the peak hour. The wine shop are in consequent that will become running more inefficiency and ineffective.

Lady using a tablet
Lady using a tablet

This Essay is

a Student's Work

Lady Using Tablet

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Examples of our work

The system is only for internal staff use. The reservation of wine facilities required the customer to go to the counter and registered the wine and paid the deposit with the counter staff directly and manually. Even through the customer can phone-in to do the reservation, but still have some customer complain that they cannot buy the bottle of wine which is limited. There is no internet service provided for the customer use. Moreover, it is increase the work load of the staff to deal with the reservation and enquires. In result, human error may be raised such as double reservation or incorrect entry of the wine bookings, etc. With the dissatisfaction of the service, the potential customer may be lost.

In addition, the staffs complained that technology in the wine shop is outdated and there is accumulated customers information in the database in result the response is relatively low for the customer details. As the customer has the privileges after registered as member, they are needed to wait for a long time to check with the privileges during the payment process. The staffs also complained that the records of the member always incorrect they need more time to verify with the members.

Project initialization

Recently, the staffs received a lot of complaints from the customer about the processing time of making the payment and check for information of the bottle of wines takes too long, they have to wait for at least 30 minutes to do this. It is very unacceptable for them. And the customers always complain that they don't know the amount of the bottle of wine which has limited and they always can't buy it. The managers and the staffs also complained that it takes a long time to do the input the data for the retrieve for the bottle of wine. Apart from this, the staffs find that the records are incorrect from the database.

Ricky Lee - the general manager of The Select Wine Shop noticed that the customer orders could be arranged by the new online system. With the new systematical and the centralized database, the staffs access the system instantly via network. They retrieve the information though user-friendly interfaces. The database is automated synchronize across the WAN. The staffs can update and retrieve the record including all customer order details and the wine details. Furthermore, the new system reduces the processing time of the retrieve of the bottle of wine, and increases the accuracy of data.

Chapter 2

Feasibility Report

Feasibility Report

Introduction

"The Select Wine House" is a famous wine shop in Hong Kong, which provides a variety of wine such as red wines, white wines, champagnes, ham, sausages and the original champagne glasses etc. A routine operating system is used to record sales, the cost of purchase, update stock levels when a sale is made automatically and notify the staff when the stock level fall below a preset value. Besides, the workstations are used to record the customer information, issue the payment receipts and order the wines for the customer if the wines are out of stock. However, the system is only for internal staff use. The reservation of wine facilities required the customer to go to the wine shop counter and registered the wining and paid the deposit with the counter staff directly and manually. Even through the customer can phone-in to do the reservation, it is still required to pay the deposit within 14 days to complete the reservation process. There is no internet service provided for the customer use. Moreover, it is increase the work load of the staff to deal with the reservation and enquires. In result, human error may be raised such as double reservation or incorrect entry of the bookings, etc. With the dissatisfaction of the service, the potential customer may be lost.

From the last year annual meeting, the director forecast that the customer expenditure model will be changed rapidly as they are more preferable to choose the most convenience way in their lifestyle. Also from the sales report in the past few years, the growth of the sales is slow. Also the manager reported that the staff is unable to spare the time to answer the customer phone call queries during the peak hour. The wine shop are in consequent that are running inefficiency and ineffective.

In addition, the staffs complained that technology in the wine shop is outdated and there is accumulated customers information in the database in result the response is relatively low for retrieving the customer details. As the customer has the privileges after registered as member, they are needed to wait for a long time to check with the privileges during the payment process. Apart from this, the records of database are sometimes incorrect, the staffs have to verify those records manually.

Feasibility study information gathered from

Director

General Manager

Wine Shop Manager

Counter Staff

System Administrator

The information was gathered through interviews, meetings, record searching from 05th Oct 2010 to 12th Oct 2010.

The feasibility study report summaries the information gathered. It contains 2 parts:

Fact Findings

Proposed Solutions

The whole feasibility study report will be presented to the wine shop of Directors on 12th Oct, 2010.

Terms of References

Investment budget:

The total budget of the Online Wine Shop System project is about $1,880,000.00 including:

Internal system development and interface design

Web based system development and interface design

System Database design

Computer hardware and software purchasing and installation.

New system Installation and Training to staffs

Network setup and maintenance

Technology competency and consistency

Online Wine Shop System is a system including internal system and online system. The internal system allows the staff to access the information including wine reservation, member registration record and wines vacancy. The staffs retrieve the information through Graphical User Interfaces (GUI). The online system allows customer to reserve wine. Both the staffs and the customers use online system through web browser.

The Online Wine Shop System will run under the Microsoft Windows XP platform, using Appserve application which includes Apache (Web server), PHP (Programming language) and MySQL (database server infrastructure), those are IT operations infrastructure, application infrastructure, collaboration infrastructure operation system. It lets us:

Easy to connect the workstation within workgroup

Easy to manage user account and user permission

Share files and printers reliably, efficiently and securely

Many computer software and hardware is compatible on Apache

The Online Wine Shop System use MySQL 5 database management system to create and manage the relational database. MySQL 5 is manageability, availability, scalability, security database. The database administrator uses Phpmyadmin which is GUI tools or Query Analyze which is command tools to manage the database.

All computer server and workstation will be supplied by HP. PHP 5 is scalability and reliability programming language. The developer uses the development tools to create the Graphical User Interface (GUI). Some functions such as searching, data insert and update can also be done with PHP. It can run on both LINUX and Windows Platform only.

The existing customer details, sales details and history record will store in the new "Online Wine Shop System". The records will be assigned the code by the data transformation. In order to the old record and the new record will consistency.

Findings -- Organizational Requirements:

Role of users:

Director

Prepare budgets, monitor revenues and expenses

Develop, implement and evaluate policies and procedures for the wine shop

Provide the top-level management information and authorize supporting the system analyst

General Manager

Responsible for the overall operation of the wine shop

Set wine price, allocate funds to departments, approve expenditures

Review monthly and yearly report about sales

Ensure standard of the service

Responsible for the day-to-day operation in the wine shop

Wine Shop Manager

Coordinate wine reservations as well as train the wine shop counter staff

Ensure that customer are treated courteously, complaints and problems are resolved, and requests for special services are carried out

Assist in processing wine order, wine reservations and member registration

Give guidelines and solve the problem while the counter staff using the system

Verify customer record, improve the service to satisfy the customer

Resolve the customer's complaint

Counter Staff

Responsible for wine reservations

Check daily record sheets, customer details, receipts and vouchers using computerized or manual input

To handle the customer payment and give the receipt to them

Answer the enquiries regarding wine reservation services and registration

Respond the customers' complaints to Wine Shop Manager

System Administrator

Prepare backup and recovery procedure of the system

Maintain the computer network reliable and stable

Findings- User Requirements

Expected Benefits

Director

Improve the efficiency of Wine Shop Operation

Provide highly security for customer information

General Manager

Provide accuracy information of monthly and yearly report

Provide User-friendly interfaces to retrieve the information

To improve the wine shop service make the customer to be satisfied

Wine Shop Manager

Register the customer information and wine reservation process would be faster

To reduce the training time on the new system

Prompt warning and error message concisely, clearly

Provide a help menu to display the system functions

Counter Staff

Register and retrieve record would be faster

Better user-friendly interfaces for inputting and searching record

Better coding for record sheet filing and retrieving

System Administrator

Control the access mode for different user

To control the system at any computers

Knowledge and skill competency in technology

Director

Excellent management and organization skill

Basic concept about the new system

General Manager

Excellent control, management and analytical skill

Basic concept about the new system

Good control and management skill

Basic concept about the new system

Wine Shop Manager

Good concept about the new system

Experience in computer operation

Good typing skill

Counter Staff

Knowledge in typing and PC operation skills

System Administrator

In depth knowledge about hardware and software

To solve problem skill in network and computer areas

MySQL Relational Database Management System (RDBMS) knowledge is required

Finding - System Requirements

Functional requirements

The database

Include all the wine shop information such as customer information and wines details (type, product or location), staff name, staff ID, sales history

User interface

User-friendly interfaces design which allows the user to use the new system easily and do not use much time for training

To prevent unauthorized user to access the system, the security login screen is necessary

Provide the interface for staff to update and enquiry the information

Computer and Networking

To store the huge amount of data, the server need to large hard disk capacity

To shorten process time, the server need to more RAM

Provide appropriate backup and recovery services

Provide appropriate level of security control

Provide virus control

Provide network printing services.

Proposed Solution

Introduction:

In order to increase the company revenue with using online wine shop system, information technology is the most efficient way to solve the problems. In fact, there are a lot of the problems in the old system and affect the service quality. For example, the retrieval time for the customer information is long as the system technology is old. To solve the problem, the new system should implement. Also it is important to make sure the new online wine shop system is in the consistency way as in the old wine shop system.

Actually, there are many solution, they also contain different advantages and drawbacks. Therefore, we need to compare them in technical, financial and operational views to decide the most suitable solution. This document contains the detail comparison of two proposed solutions

Solution Summary:

Approach used to identify solution:

The most suitable solution is chosen by the comparison of two possible options (Plan A & Plan B). The comparison is based on: technical feasibility, financial feasibility and operational feasibility.

Choices proposed

There are two proposed solutions:

Centralized database on "Online Wine Shop System". The data of current and new system will store in same database, all the information is real time update.

Database independent on "Online Wine Shop System". The data of current and new system will keep in their own database, all the information is separate and not synchronize.

Outlines of proposed solution:

Description

Plan A

Plan B

General description

Centralized Database System with password authentication technology

Database Independent System with password authentication technology

User Interface

Application interface for staff

Web interface for customer

Same as Plan A

Software requirements

Server operation system with web server service, Database and web interface development tools

Same as Plan A

Hardware requirements

One or more powerful server with reliable storages and backup devices

Perform Clustering

Workstation

Network installation

Internet Connection

At least two databases server

Workstations

Network installation

Internet Connection

Schedule

Database and user interface development: 2.5 months

Software installation: 2 weeks

Hardware/Network installation and testing: 2 month.

Training: 2 weeks

Database and user interface development: 3 months

Software installation: 2 week

Hardware/Network installation and testing: 2 month

Training: 2 weeks

Staffing & organization

Project manager, System Administrator, information technology team, hardware/network installation company or vendor

Same as Plan A

Feasibility analysis schedule

Consider the technical feasibility

Whether the level of technological advancement needed, to determine the availability and the stability on the appropriate technology.

Consider the human and operational factors

Concerned with human, organizational aspects. For example, will recruitment be necessary and what training will be required?

Consider the political factors

Are there any other parties or unit against or support this project?

Consider the financial factors

Calculate the actual cost and the organization budget.

Same as Plan A

Human factors

Smart card technology simply the logon process, and reduce the typing errors.

Same as Plan A

Development strategy

Internal application is developed by using programming language

Web application is developed by using common web technologies.

The database is developed by using relation database technology

The hardware/network installations will be completed by company vendor.

Same as Plan A

Cost-benefit analysis

Basic cost: HKD $1,880,000

Maintenance: HKD $300,000/yr

Benefits:

Profit increased by HKD $8000,000/month as more customers can be visited after the new Online Wine Shop System is implemented.

Total monthly cost:

HKD $100,000

Total monthly benefit:

HKD $800,000

Basic cost: HKD $1,880,000

Maintenance: HKD $300,000/yr

Benefits:

Profit increased by HKD $800,000/month as more customers can be visited after the new Online Wine Shop System is implemented.

Total monthly cost:

HKD $100,000

Total monthly benefit:

HKD $800,000

Cost

Direct: Hardware, software, networking and training cost

Indirect: Internet service, technical staff cost and system maintenance fee

Same as Plan A.

Benefits

Able to reduce data replication

Integrate the wineing process

Simplify the data security necessary to provide data to both hotels staffs, and assign ownership of data.

Provide web-based interface. The customers can access the system through internet.

The system layouts can be customize

Similar to old system, the staffs easy to learn

Provide web-based interface. The customers can access the system through internet.

Disadvantages

Data capacity is growing up quickly.

Complex database cause maintenance difficultly

Information do not synchronize

difficult to integrate the two systems

manually operate across the two systems

Conclusion and recommendation:

From the above comparison between Plan A and Plan B, the cost effectiveness of both solutions is similar. Two solutions development difficulty all is same. In the future, the new system is a scalable, reliable and robust system more suitable. Security issue is very important on the system. The password authentication technology can provide accuracy verification. Web-base reservations system can automatic response the customers' general request. Database centralization can integrate the current and the new systems. The system would computerize and would reduce the handworks. For the reasons of system efficient, consistence and reliability, Plan A should be a better solution for developing the new "Online Wine Shop System".

Chapter 3

Detail Investigation on Current System

Current System Overview and Functional Description

The existing system is for in-house daily operating

The existing shop is a private owned wine shop in Hong Kong since 2000. It sells a wide range of wine, such as red wine, cheese, white wine etc . A routine operating system is used to record the benefit of sale, the cost of purchase and the stock levels. If the stock level falls below 100 bottoms, the system will automatically notify the staff for further action. Besides that the computers are used to record the collection of selling customer if the wine were out of stock even the champagnes glasses. But the system is only for internal staff and not publishing our products to the real world yet.

The customer information and order records are stored in paper files format

The increasing amount of our customers and the order records, the database in one of our computer server which is use to maintain those records was slowly gradually. A large amount of customer information and ordering records have been stored in paper files in the past few years.

Existing Computer and the Network Environment

There are 3 computers and 2 File Server in the wine shops, these computers connected with each other via a 10-Base2 Network Switch but not connect to the internet. In every night around 22:30, all the transaction was recorded to one of the File Server and replicated to the 2nd File Server manually. Moreover the Operation System were Windows NT which is installed in each computer. The network has been used the old coaxial wire and T-Joint to make connection with each other, so that the transfer rate is slow. In other word, the computer and network technology which were used in the wine shop is very outdated.

Information and Record were needed to be updated manually

Recently, the expedition of customer demand on the range of the wine and the increasing orders are on personal or organization account. However, the database operation cannot be updated immediately; the order and records are needed to be updated by the staff manually.

There is always a long queue on every day

The wine house is located in Tsim Sha Tsui. Our valued customers are mainly locally. But, all customers, no matter how far away they lives, they need to go to the shop to choose wine, or pre-order the new wine of their choice they cannot doing such ordering on phone for making the reservation. In the peak seasons, the staff needs to spend a lot of time to answer the customer enquiries on phone, updating customer information, such as the identity card, credit card, and other transaction records, etc. Therefore, a long queue in the shop had happened.

Delay of the sales order report

At the end of each month, the shop manager generates the sales report according to the sale records of the month, but many transaction records take time to handle. As a result, delay of sales order reports appear frequently.

Current System Problem

Customer cannot open account and searching through internet for the new products.

As mentioned before, the system is limited for staff only. If customers want to reserve the booking facilities, they have to either phone to or go to the shop counter. But all reservations need to go to the shop for register the booking and paid the deposit to our staff directly and manually. There is no internet service for the customer. Therefore, it is a good idea to set up an online web shop platform for the customer.

Wastage of resources

Customer details information and the order details are kept in paper files. Therefore, extra resources, such as warehouse, storeroom and data storage of computer are used.

Outdated computer technology and network technology

The staff often complaint that the computer technology used in the wine shop is outdated and accumulated customers information adds the burden to the system. As system response in retrieving the customer details, it may consume the customer quite a lot of time. If the customer has been registered as member, they need to wait for a long handling time to check for the payment. Sometimes, the customer would complaint for these to the manager. The manager needs to spare the time to process the complaint and this is not a manager's core business

Time consuming in answering customer problem

The manager discovered that staff spare much time in answering the customer enquires especially during the peak hours or seasons. It increases the workload of the staff. Moreover that, mistakes such as double reservation or incorrect entry of the data would be raised. All these efficiency of staff badly affect.

Difficulties in checking the book and ordering condition

Since there are many transactions to proceed on every day, it is difficulty and time consuming for staff to check the ordering condition. Working efficiency reduces and careless mistakes appear frequently.

Preparation of monthly sales report

It takes times to prepare for the monthly sales order report. The staff needs to collect analysis and adjust data from the paper files, so large workload will perform time consuming.

Chapter 4

Detail System Analysis

Project Assumptions:

To ensure the Online Wine System running implemented will be full fill within the expected time table, the following user requirement and non-functional user requirement need to meet. The development of the online wine system will be affected by any changes of the user requirement.

Scope of the System

For the objective of the new system, the online wine system can let all members purchase the wine which they are interest and get the most update information of wine directly through internet at any time. All these information can directly access through the member side GUI. Hence, the wine shop staff can access and update the information about member and wine through the administration side GUI. We need to consider online shopping, handling order and warehouse management for the main processes of the system.

The scope of our project is to design and to implement Online Wine System with user-friendly interface for Front Desk Department to decrease the processing time with member enquire and order processing for member and Front Desk staffs. The main processes we have considered of the system are: Order Processing, Handle Order, Stock Update and Member Registration.

Budget and Resources

During the development of the Online Wine System, the project manager is responsible for monitoring the progress of the whole project. The wine shop staff would provide resources in fact findings and functional requirement specification. Also, the user acceptance testing and training will be arranged for front desk department staffs. The total budget and resources required is monitored by the General Manager. The detail of the estimated budget can be referred to Feasibility Study Report.

Expected Delivery Date

The project completion on time is very important for improve the efficiency of front desk operation. The Online Wine System started development in October 2010 and the finish time is in June 2011.

Functional Specification

Overview

The Online Wine System contains three parts of system:

Online Shopping

Handle Order

Warehouse Management

The above three parts combine as a complete system. Each part includes many functions. In the project, the Online Wine System will include the above parts and functions.

Online Shopping

Function ID

Description

Requirement/Service Level

OS-UI

User-friendly interface design

Provide enough text field and buttons

OS-CV

Check Data Validation

Prompt the message when incorrect data input

OS-MR

Member Registration

Allow wine shop staff fill in member information after member enroll registration form

OS-MU

Update Member Information

Allow wine shop staff update information for member

OS-LW

List Wine

Allow member browser wine by product type

OS-SC

Shopping Cart

Allow member view, update and delete wine in their cart

OS-CO

Checkout

Allow member submit the information of delivery and payment detail.

OS-OH

Order history

Allow member to check their order status and history

Handle Order

Function ID

Description

Requirement/Service Level

HO-UI

User-friendly interface design

Provide enough text field and buttons

HO-OL

Order listing

Display valid order data

HO-SF

Search function

Search order by order ID, member name, receiver name and status

HO-OU

Update order data

Update order status

HO-OR

Order report

Display the order report by provide order status and date

Store Balance Management

Function ID

Description

Requirement/Service Level

SB-UI

User-friendly interface design

Provide enough text field and buttons

SB-LS

List all store data

List all wine stock quantity

SB-SF

Search function

Allow staff to search book by product number, location number and type number

SB-US

Update store data

Allow staff to add new type, location, wine and update wine quantity

SB-LS

List wine in lower store level

Allow staff to display which wine stock is lower than 100 bottoms

Logical system analysis

System Flow

The system flow diagram of the Online Wine Shop System can be referred to Appendix 1.1, 1.2, 1.3, 1.4.

Dynamic Model of the System (Data Flow Diagrams)

The context diagram of the Online Wine System can be referred to Appendix 1.5

The dataflow diagram of the Online Wine Shop System can be referred to Appendix 1.6, 1.7

Static Model (Entity-Relational-Diagram)

The Entity-Relationship Diagrams (ERD) of Online Wine Shop System shows the relationship between different Entities. Please refer to Appendix 1.8.

Data Dictionary

The Data Dictionary of Online Wine Shop System can be referred to Appendix 2

System Specification

In the Online Wine Shop System, many functions should implement. These functions apply to screen input/output for searching, listing. The core programs are described as follows.

Detailed Program Specification will be shown as the following format:

Program Module

Program ID

Program Name

Program Type

Table I/O

Screen I/O

Description

Program Module : Create Member

Program ID : AD/AM/01

Program Name : Create member information

Program Type : Online

Table I/O : Member

Screen I/O : Add Member Screen

Description : It allows staff to fill in the information of member

Program Module : Amend Member

Program ID : AD/AU/01

Program Name : Amend Member information

Program Type : Online

Table I/O : Member

Screen I/O : Update Member Screen

Description : It allows staff to update information for member

Program Module : Search Member by Member Name

Program ID : AD/AM/02

Program Name : Search Member Information

Program Type : Online

Table I/O : Member

Screen I/O : Search Member Screen

Description : It allows staff to search member information by member name

Program Module : Search Member by Member No

Program ID : AD/AM/02

Program Name : Search Member Information

Program Type : Online

Table I/O : Member

Screen I/O : Search Member Screen

Description : It allows staff to search member information by Member Number

Program Module : Create Wine

Program ID : AD/AP/03

Program Name : Create Wine information

Program Type : Online

Table I/O : Product

Screen I/O : Add Product Screen

Description : It allows the staff to create a new wine record

Program Module : Amend Wine

Program ID : AD/AU/02

Program Name : Amend Wine information

Program Type : Online

Table I/O : Product

Screen I/O : Update Product Screen

Description : It allows the staff to amend the product quantity and information

Program Module : Search Product by Product Number

Program ID : AD//AP/03

Program Name : Search Wine Information

Program Type : Online

Table I/O : Product

Screen I/O : Add Product Screen

Description : It allows the staff to search Wine record by Product Number

Program Module : Search Product by Location

Program ID : AD/AP/01

Program Name : Search Product Information

Program Type : Online

Table I/O : Location

Screen I/O : Location and Item Screen

Description : It allows the staff to search book record by Location Number

Program Module : Search Product by Type

Program ID : AD/AP/02

Program Name : Search Product Information

Program Type : Online

Table I/O : Type

Screen I/O : Location and Item Screen

Description : It allows the staff to search Product record by Type Number

Program Module : Create Order

Program ID : MB/CR/01

Program Name : Create Order Information

Program Type : Online

Table I/O : Order

Screen I/O : Submit Order Screen

Description : It allows the member to submit their order, payment information and delivery information

Program Module : Amend Order

Program ID : AD/AO/02

Program Name : Amend Order Information

Program Type : Online

Table I/O : Order

Screen I/O : Update Order Screen

Description : It allows the staff to amend the order status

Program Module : Search Order By Order NO

Program ID : AD/AO/03

Program Name : Search Order Information

Program Type : Online

Table I/O : Order

Screen I/O : View Before Order Screen

Description : It allows the staff to search Order by Order Number

Program Module : Search Order by Customer First Name

Program ID : AD/AO/03

Program Name : Search Order Information

Program Type : Online

Table I/O : Order

Screen I/O : View Before Order Screen

Description : It allows the staff to search Order by Customer First Name

Program Module : Search Order by Status

Program ID : AD/A/03

Program Name : Search Order Information

Program Type : Online

Table I/O : Product

Screen I/O : View Before Order Screen

Description : It allows the staff to search Order by Order Status

Program Module : Search Order By Member Name

Program ID : AD/AO/03

Program Name : Search Order By Member Name

Program Type : Online

Table I/O : Order

Screen I/O : View Before Order Screen

Description : It allows the staff to search Member Name