Online Wine Shop System Computer Science Essay

“ The Wine Select House ” – a private owned vino shop-has been supplying a broad scope of vino on varies of point. The vino store is normally gross revenues at least 200 bottles of vino everyday for walk in clients. All clients can be registered as members to obtain more particular offer during seasonal salutations. It is provided with 5 workstations to continue the client inside informations, record gross revenues of vinos, to seek for vinos in stock and to automatically update the stock degrees when gross revenues are made. All clients registered inside informations are recorded on the local computing machine system that stored as client in numeral order harmonizing to incrementing for every new client. There are about about 3000 client ‘s records have been accumulated for the past 5 old ages.

All the workstations are provided for staff usage merely. These workstations provided the installations including hunt for the type of vino, location from merchandise figure or keyword. The workstation will besides be used to enter gross revenues, the cost of purchase, update stock degrees when a sale is made automatically and advise the staff when the stock degree autumn below a preset value. Besides, the workstations are used to enter the client information, issue the payment grosss and order the books for the client if the gifts are out of stock.

In the past few twelvemonth, the company grow is comparatively little and there are provided with many picks for the clients particularly online shopping. The store director is planned to derive more gross by put ining the on-line gift store system leting the vinos can be sold in the worldwide and in the local. In order to supply the same privileges for the valuable client during online system, all client information are needed to computerise. By the manner, the member can still bask the particular offer even in the on-line vino store.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

In order to work out the above jobs efficaciously, a undertaking “ Online Wines Shop System ” is proposed. The client can be convenience hunt for vinos in stock, order new points on behalf of themselves and sell the gifts on the cyberspace. All information of vinos database can be accessed through the Local Area Network ( LAN ) or even Wide Area Network ( WAN ) at all times.

The Wine Select shop merely got one store in the Tsim Sha Tsui Area. Their valued clients are chiefly locally. As cyberspace is going a portion of our life, on-line shopping is normally in usage. Developing the above system can research more possible client so that increasing the company gross as a whole, it can be non restricted locally and go a world-wide vino store. Due the store director wants to run into the company gross revenues mark at the terminal of this twelvemonth, he anticipate me can complete this system for non more than four months. On top of this system, I decided to utilize a Structured System Analysis and Design Methodology ( SSADM ) to systems analysis and design.

See to the flexibleness of the system, we use PHP engineering as the front terminal interfaces building plus the free-of-charged MySQL database direction system to construct the whole system. PHP plus MySQL can supply the flexibleness and scalability for utilizing this system on different popular platforms such as Linux, Windows, MacOS and UNIX. Furthermore, these package bundles are open-sourced and free of charge, which can cut down the cost.

Key Phrases

The Select Wine Shop, 200 bottles of mundane, walk in clients, particular offer during seasonal salutations, record gross revenues of vinos, hunt for vinos in stock, client inside informations, to seek for vinos in stock, automatically update the stock degrees when gross revenues are made, the type of vinos, location from, merchandise figure or keyword, the cost of purchase, publish the payment grosss and order the vinos for the client, on-line vinos store, same privileges, vinos database, Structured System Analysis and Design Methodology ( SSADM ) , Methodology, Local Area Network ( LAN ) , Wide Area Network ( WAN ) , Windows, MacOS, Unix, unfastened beginning and MySOL.

Scope

For the range of this new system, this system can allow all possible clients purchase the vinos through cyberspace and easy entree the vinos inside informations straight on the cyberspace at any clip. All these information can straight entree through the GUI. Hence, the users can merely entree and update the information about the client and the gifts.

Aims

To supply the on-line vinos service efficaciously and its efficiency. Finding out the facts about the new system needed and the solution for constructing up such better system. And, to fix the feasibleness survey study.

Activities: Probe on the job ; feasibleness surveies in proficient, operational and economical ; and proposed solution.

Deliverables: Feasibility Report. 1000 – 1500 words.

Agenda: 1 hebdomad ( Completion Date – 12th Oct, 2010 )

To supply the item 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 informations diagrams. Use prototyping accomplishment to assist to obtain the above consequence for a structured system attack.

Deliverables: Functional specification ; Database Design and all the informations diagrams. 1000 – 1500 word

Agenda: 2 hebdomads ( Completion Date – 26th Oct, 2010 )

To supply the item physical design including application cryptography for the whole new system. It can supply the concluding merchandise of the new system.

Activities: Physical system design, user interfaces, system building, paradigm and testing, and security scene.

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

Agenda: 3 hebdomads ( Completion Date – 16th Nov, 2010 )

Relevance of other classs

The classs Database Design and Development, Business System Design, Business System Analysis, Management Business Project and Principle of Web page design will supply relevant beginnings of stuff for the undertaking.

To supply the elaborate execution program for implementing the new system and some papers for the new system used by client.

Activities: Testing all the system modules include paradigm ; installing ; preparation program and care program.

Deliverables: Detailed system proving program, execution program, user bill of fare and care bill of fare. Max 5000 words.

Agenda: 3 hebdomads. ( Completion Date – 6th Dec, 2010 )

To supply the system control and rating method to the new system. Making the decision for the system and research the potency of the new system for the hereafter development.

Activities: Measuring the system comparing to the initial demand to do to decision and happen the potency of farther development of the system.

Deliverables: Decision and rating study. Max 1000 words.

Agenda: 12 hebdomad ( Completion Date – 23rd Jan, 2010 concluding entry )

Required resources

Entree to libraries, Access to the Internet, Standard Pentium 4 Personal computer, PHP application package, Apache, Windows XP place and MySQL database direction system.

Initial mentions

Randy Jay Yarger, George Reese and Tim King, “ MySQL and mSQL ” , O’REILLY.

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

Rob, Peter, “ Database Systems: Design, execution, and direction ” , Cambridge.

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

Online Shopping Database System: hypertext transfer protocol: //www.wineshop.hk/

Apache functionary web site: hypertext transfer protocol: //www.apache.org

Critical success factors

Obtaining sufficient relevant information to find a full set of demands.

Obtaining sufficient relevant cognition and accomplishment set to implement the new system.

Chapter 1

Introduction

Company Background

“ The Select Wine House ” is one of the celebrated vino store which local near the Tsim Sha Tsui MTR station in Hong Kong since 2000. They provide many sort of vino for their client to bask with the vino. Customer can purchase ruddy vinos, white vinos, bubblies, jambon, sausages and the original bubbly spectacless etc.

For the past 3 old ages, the figure of gross revenues was increasing steadily under the policy of Hong Kong Government. Now, the store are gross revenues at least 200 bottles of wine every twenty-four hours. For the last twelvemonth one-year meeting, the manager prognosis that the policy of Hong Kong Government will be changed quickly as they are more preferred to take the most convenience manner in their life style. Besides from the gross revenues study in the past few old ages, the growing of gross revenues is rapidly, Besides the director study that the staff is unable to save the clip to reply the client phone call questions during the peak hr. The vino store are in consequent that will go running more inefficiency and ineffective.

The system is merely for internal staff usage. The reserve of vino installations required the client to travel to the counter and registered the vino and paid the sedimentation with the counter staff straight and manually. Even through the client can phone-in to make the reserve, but still hold some client complain that they can non purchase the bottle of vino which is limited. There is no internet service provided for the client usage. Furthermore, it is increase the work burden of the staff to cover with the reserve and enquires. In consequence, human mistake may be raised such as dual reserve or wrong entry of the vino engagements, etc. With the dissatisfaction of the service, the possible client may be lost.

In add-on, the staffs complained that engineering in the vino store is outdated and there is accrued clients information in the database in consequence the response is comparatively low for the client inside informations. As the client has the privileges after registered as member, they are needed to wait for a long clip to look into with the privileges during the payment procedure. The staffs besides complained that the records of the member ever incorrect they need more clip to verify with the members.

Undertaking low-level formatting

Recently, the staffs received a batch of ailments from the client about the processing clip of doing the payment and look into for information of the bottle of vinos takes excessively long, they have to wait for at least 30 proceedingss to make this. It is really unacceptable for them. And the clients ever complain that they do n’t cognize the sum of the bottle of vino which has limited and they ever ca n’t purchase it. The directors and the staffs besides complained that it takes a long clip to make the input the information for the retrieve for the bottle of vino. Apart from this, the staffs find that the records are wrong from the database.

Ricky Lee – the general director of The Select Wine Shop noticed that the client orders could be arranged by the new online system. With the new systematical and the centralised database, the staffs entree the system immediately via web. They retrieve the information though user-friendly interfaces. The database is automated synchronize across the WAN. The staffs can update and recover the record including all client order inside informations and the vino inside informations. Furthermore, the new system reduces the processing clip of the retrieve of the bottle of vino, and increases the truth of informations.

Chapter 2

Feasibility Report

Feasibility Report

Introduction

“ The Select Wine House ” is a celebrated vino store in Hong Kong, which provides a assortment of vino such as ruddy vinos, white vinos, bubblies, jambon, sausages and the original bubbly spectacless etc. A everyday operating system is used to enter gross revenues, the cost of purchase, update stock degrees when a sale is made automatically and advise the staff when the stock degree autumn below a preset value. Besides, the workstations are used to enter the client information, issue the payment grosss and order the vinos for the client if the vinos are out of stock. However, the system is merely for internal staff usage. The reserve of vino installations required the client to travel to the vino store counter and registered the wining and paid the sedimentation with the counter staff straight and manually. Even through the client can phone-in to make the reserve, it is still required to pay the sedimentation within 14 yearss to finish the reserve procedure. There is no internet service provided for the client usage. Furthermore, it is increase the work burden of the staff to cover with the reserve and enquires. In consequence, human mistake may be raised such as dual reserve or wrong entry of the engagements, etc. With the dissatisfaction of the service, the possible client may be lost.

From the last twelvemonth one-year meeting, the manager prognosis that the client outgo theoretical account will be changed quickly as they are more preferred to take the most convenience manner in their life style. Besides from the gross revenues study in the past few old ages, the growing of the gross revenues is slow. Besides the director reported that the staff is unable to save the clip to reply the client phone call questions during the peak hr. The vino store are in consequent that are running inefficiency and ineffective.

In add-on, the staffs complained that engineering in the vino store is outdated and there is accrued clients information in the database in consequence the response is comparatively low for recovering the client inside informations. As the client has the privileges after registered as member, they are needed to wait for a long clip to look into with the privileges during the payment procedure. Apart from this, the records of database are sometimes wrong, the staffs have to verify those records manually.

Feasibility survey information gathered from

Director

General Manager

Wine Shop Manager

Counter Staff

System Administrator

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

The feasibleness survey study summaries the information gathered. It contains 2 parts:

Fact Findingss

Proposed Solutions

The whole feasibleness survey study will be presented to the vino store of Directors on 12th Oct, 2010.

Footings of Mentions

Investing budget:

The entire budget of the Online Wine Shop System undertaking 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 package buying and installing.

New system Installation and Training to staffs

Network apparatus and care

Technology competence and consistence

Online Wine Shop System is a system including internal system and online system. The internal system allows the staff to entree the information including vino reserve, member enrollment record and vinos vacancy. The staffs retrieve the information through Graphical User Interfaces ( GUI ) . The online system allows client to reserve vino. Both the staffs and the clients use on-line system through web browser.

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

Easy to link the workstation within workgroup

Easy to pull off user history and user permission

Share files and pressmans faithfully, expeditiously and firmly

Many computing machine package and hardware is compatible on Apache

The Online Wine Shop System use MySQL 5 database direction system to make and pull off the relational database. MySQL 5 is manageableness, handiness, scalability, security database. The database decision maker uses Phpmyadmin which is GUI tools or Query Analyze which is bid tools to pull off the database.

All computing machine waiter and workstation will be supplied by HP. PHP 5 is scalability and dependability scheduling linguistic communication. The developer uses the development tools to make the Graphical User Interface ( GUI ) . Some maps such as searching, informations insert and update can besides be done with PHP. It can run on both LINUX and Windows Platform merely.

The bing client inside informations, gross revenues inside informations and history record will hive away in the new “ Online Wine Shop System ” . The records will be assigned the codification by the informations transmutation. In order to the old record and the new record will consistency.

Findingss — Organizational Requirements:

Role of users:

Director

Prepare budgets, proctor grosss and disbursals

Develop, implement and measure policies and processs for the vino store

Supply the top-level direction information and authorise back uping the system analyst

General Manager

Responsible for the overall operation of the vino store

Set vino monetary value, apportion financess to sections, O.K. outgos

Review monthly and annual study about gross revenues

Ensure criterion of the service

Responsible for the daily operation in the vino store

Wine Shop Manager

Coordinate vino reserves every bit good as train the vino store counter staff

Ensure that client are treated politely, ailments and jobs are resolved, and petitions for particular services are carried out

Assist in treating wine order, wine reserves and member enrollment

Give guidelines and work out the job while the antagonistic staff utilizing the system

Verify client record, better the service to fulfill the client

Decide the client ‘s ailment

Counter Staff

Responsible for wine reserves

Check day-to-day record sheets, client inside informations, grosss and verifiers utilizing computerized or manual input

To manage the client payment and give the reception to them

Answer the questions sing vino reserve services and enrollment

React the clients ‘ ailments to Wine Shop Manager

System Administrator

Prepare backup and recovery process of the system

Keep the computing machine web dependable and stable

Findings- User Requirements

Expected Benefits

Director

Better the efficiency of Wine Shop Operation

Provide extremely security for client information

General Manager

Provide truth information of monthly and annual study

Supply User-friendly interfaces to recover the information

To better the vino store service make the client to be satisfied

Wine Shop Manager

Register the client information and vino reserve procedure would be faster

To cut down the preparation clip on the new system

Prompt warning and mistake message briefly, clearly

Supply a aid bill of fare to expose the system maps

Counter Staff

Register and recover record would be faster

Better user-friendly interfaces for inputting and seeking record

Better coding for record sheet filing and retrieving

System Administrator

Control the entree manner for different user

To command the system at any computing machines

Knowledge and skill competence in engineering

Director

Excellent direction and organisation accomplishment

Basic construct about the new system

General Manager

Excellent control, direction and analytical accomplishment

Basic construct about the new system

Good control and direction accomplishment

Basic construct about the new system

Wine Shop Manager

Good construct about the new system

Experience in computing machine operation

Good typewriting accomplishment

Counter Staff

Knowledge in typing and Personal computer operation accomplishments

System Administrator

In deepness cognition about hardware and package

To work out job accomplishment in web and computing machine countries

MySQL Relational Database Management System ( RDBMS ) cognition is required

Finding – System Requirements

Functional demands

The database

Include all the vino store information such as client information and vinos inside informations ( type, merchandise or location ) , staff name, staff ID, gross revenues history

User interface

User-friendly interfaces design which allows the user to utilize the new system easy and make non utilize much clip for preparation

To forestall unauthorised user to entree the system, the security login screen is necessary

Supply the interface for staff to update and enquiry the information

Computer and Networking

To hive away the immense sum of informations, the waiter demand to big difficult disc capacity

To shorten process clip, the waiter need to more RAM

Provide appropriate backup and recovery services

Provide appropriate degree of security control

Provide virus control

Provide web printing services.

Proposed Solution

Introduction:

In order to increase the company gross with utilizing on-line vino store system, information engineering is the most efficient manner to work out the jobs. In fact, there are a batch of the jobs in the old system and impact the service quality. For illustration, the retrieval clip for the client information is long as the system engineering is old. To work out the job, the new system should implement. Besides it is of import to do certain the new on-line vino store system is in the consistence manner as in the old vino store system.

Actually, there are many solution, they besides contain different advantages and drawbacks. Therefore, we need to compare them in proficient, fiscal and operational positions to make up one’s mind the most suited solution. This papers contains the item comparing of two proposed solutions

Solution Summary:

Approach used to place solution:

The most suited solution is chosen by the comparing of two possible options ( Plan A & A ; Plan B ) . The comparing is based on: proficient feasibleness, fiscal feasibleness and operational feasibleness.

Choices proposed

There are two proposed solutions:

Centralized database on “ Online Wine Shop System ” . The information of current and new system will hive away in same database, all the information is existent clip update.

Database independent on “ Online Wine Shop System ” . The information of current and new system will maintain in their ain database, all the information is separate and non synchronise.

Outlines of proposed solution:

Description

Plan A

Plan B

General description

Centralized Database System with password hallmark engineering

Database Independent System with password hallmark engineering

User Interface

Application interface for staff

Web interface for client

Lapp as Plan A

Software demands

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

Lapp as Plan A

Hardware demands

One or more powerful waiter with dependable storages and backup devices

Perform Clustering

Workstation

Network installing

Internet Connection

At least two databases server

Workstations

Network installing

Internet Connection

Agenda

Database and user interface development: 2.5 months

Software installing: 2 hebdomads

Hardware/Network installing and testing: 2 month.

Training: 2 hebdomads

Database and user interface development: 3 months

Software installing: 2 hebdomad

Hardware/Network installing and testing: 2 month

Training: 2 hebdomads

Staffing & A ; organisation

Undertaking director, System Administrator, information engineering squad, hardware/network installing company or seller

Lapp as Plan A

Feasibility analysis agenda

See the proficient feasibleness

Whether the degree of technological promotion needed, to find the handiness and the stableness on the appropriate engineering.

See the homo and operational factors

Concerned with human, organisational facets. For illustration, will recruitment be necessary and what preparation will be required?

See the political factors

Are there any other parties or unit against or back up this undertaking?

See the fiscal factors

Calculate the existent cost and the organisation budget.

Lapp as Plan A

Human factors

Smart card engineering merely the logon procedure, and cut down the typewriting mistakes.

Lapp as Plan A

Development scheme

Internal application is developed by utilizing programming linguistic communication

Web application is developed by utilizing common web engineerings.

The database is developed by utilizing relation database engineering

The hardware/network installings will be completed by company seller.

Lapp as Plan A

Cost-benefit analysis

Basic cost: HKD $ 1,880,000

Care: HKD $ 300,000/yr

Benefits:

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

Entire monthly cost:

HKD $ 100,000

Entire monthly benefit:

HKD $ 800,000

Basic cost: HKD $ 1,880,000

Care: HKD $ 300,000/yr

Benefits:

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

Entire monthly cost:

HKD $ 100,000

Entire monthly benefit:

HKD $ 800,000

Cost

Direct: Hardware, package, networking and preparation cost

Indirect: Internet service, proficient staff cost and system care fee

Lapp as Plan A.

Benefits

Able to cut down informations reproduction

Integrate the wineing procedure

Simplify the informations security necessary to supply informations to both hotels staffs, and assign ownership of informations.

Supply web-based interface. The clients can entree the system through cyberspace.

The system layouts can be custom-make

Similar to old system, the staffs easy to larn

Supply web-based interface. The clients can entree the system through cyberspace.

Disadvantages

Data capacity is turning up rapidly.

Complex database cause care difficultly

Information do non synchronise

hard to incorporate the two systems

manually operate across the two systems

Decision and recommendation:

From the above comparing between Plan A and Plan B, the cost effectivity of both solutions is similar. Two solutions development trouble all is same. In the hereafter, the new system is a scalable, dependable and robust system more suited. Security issue is really of import on the system. The watchword hallmark engineering can supply truth confirmation. Web-base reserves system can automatic response the clients ‘ general petition. Database centralisation can incorporate the current and the new systems. The system would computerise and would cut down the handicrafts. For the grounds of system efficient, consistency and dependability, 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 bing system is for in-house day-to-day operating

The bing store is a private owned vino store in Hong Kong since 2000. It sells a broad scope of vino, such as ruddy vino, cheese, white vino etc. A everyday operating system is used to enter the benefit of sale, the cost of purchase and the stock degrees. If the stock degree falls below 100 undersides, the system will automatically advise the staff for farther action. Besides that the computing machines are used to enter the aggregation of selling client if the vino were out of stock even the bubblies spectacless. But the system is merely for internal staff and non printing our merchandises to the existent universe yet.

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

The increasing sum of our clients and the order records, the database in one of our computing machine waiter which is usage to keep those records was easy bit by bit. A big sum of client information and ordination records have been stored in paper files in the past few old ages.

Existing Computer and the Network Environment

There are 3 computing machines and 2 File Server in the vino stores, these computing machines connected with each other via a 10-Base2 Network Switch but non link to the cyberspace. In every dark about 22:30, all the dealing was recorded to one of the File Server and replicated to the 2nd File Server manually. Furthermore the Operation System were Windows NT which is installed in each computing machine. The web has been used the old coaxal wire and T-Joint to do connexion with each other, so that the transportation rate is slow. In other word, the computing machine and web engineering which were used in the vino store is really out-of-date.

Information and Record were needed to be updated manually

Recently, the expedition of client demand on the scope of the vino and the increasing orders are on personal or organisation history. However, the database operation can non be updated instantly ; the order and records are needed to be updated by the staff manually.

There is ever a long waiting line on every twenty-four hours

The vino house is located in Tsim Sha Tsui. Our valued clients are chiefly locally. But, all clients, no affair how far off they lives, they need to travel to the store to take vino, or pre-order the new vino of their pick they can non making such telling on phone for doing the reserve. In the peak seasons, the staff needs to pass a batch of clip to reply the client questions on phone, updating client information, such as the individuality card, recognition card, and other dealing records, etc. Therefore, a long waiting line in the store had happened.

Delay of the gross revenues order study

At the terminal of each month, the store director generates the gross revenues study harmonizing to the sale records of the month, but many dealing records take clip to manage. As a consequence, hold of gross revenues order studies appear often.

Current System Problem

Customer can non open history and seeking through cyberspace for the new merchandises.

As mentioned before, the system is limited for staff merely. If clients want to reserve the engagement installations, they have to either phone to or travel to the store counter. But all reserves need to travel to the store for registry the engagement and paid the sedimentation to our staff straight and manually. There is no internet service for the client. Therefore, it is a good thought to put up an online web store platform for the client.

Wastage of resources

Customer inside informations information and the order inside informations are kept in paper files. Therefore, excess resources, such as warehouse, storage room and informations storage of computing machine are used.

Outdated computing machine engineering and web engineering

The staff frequently complaint that the computing machine engineering used in the vino store is outdated and accumulated clients information adds the load to the system. As system response in recovering the client inside informations, it may devour the client rather a batch of clip. If the client has been registered as member, they need to wait for a long handling clip to look into for the payment. Sometimes, the client would complaint for these to the director. The director needs to save the clip to treat the ailment and this is non a director ‘s nucleus concern

Time devouring in replying client job

The director discovered that staff save much clip in replying the client enquires particularly during the peak hours or seasons. It increases the work load of the staff. Furthermore that, errors such as dual reserve or wrong entry of the informations would be raised. All these efficiency of staff severely affect.

Troubles in look intoing the book and ordering status

Since there are many minutess to continue on every twenty-four hours, it is trouble and clip devouring for staff to look into the ordering status. Working efficiency reduces and careless errors appear often.

Preparation of monthly gross revenues study

It takes times to fix for the monthly gross revenues order study. The staff needs to roll up analysis and adjust informations from the paper files, so big work load will execute clip devouring.

Chapter 4

Detail System Analysis

Undertaking Premises:

To guarantee the Online Wine System running implemented will be full fill within the expected clip tabular array, the following user demand and non-functional user demand demand to run into. The development of the on-line vino system will be affected by any alterations of the user demand.

Scope of the System

For the aim of the new system, the on-line vino system can allow all members purchase the vino which they are involvement and acquire the most update information of vino straight through cyberspace at any clip. All these information can straight entree through the member side GUI. Hence, the vino store staff can entree and update the information about member and vino through the disposal side GUI. We need to see on-line shopping, managing order and warehouse direction for the chief procedures of the system.

The range of our undertaking is to plan and to implement Online Wine System with user-friendly interface for Front Desk Department to diminish the processing clip with member enquire and order processing for member and Front Desk staffs. The chief procedures 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 undertaking director is responsible for supervising the advancement of the whole undertaking. The vino store staff would supply resources in fact findings and functional demand specification. Besides, the user credence testing and preparation will be arranged for front desk section staffs. The entire budget and resources required is monitored by the General Manager. The item of the estimated budget can be referred to Feasibility Study Report.

Expected Delivery Date

The undertaking completion on clip is really of import for better the efficiency of front desk operation. The Online Wine System started development in October 2010 and the finish clip 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 portion includes many maps. In the undertaking, the Online Wine System will include the above parts and maps.

Online Shopping

Function ID

Description

Requirement/Service Level

OS-UI

User-friendly interface design

Provide plenty text field and buttons

OS-CV

Check Data Validation

Motivate the message when incorrect informations input

OS-MR

Member Registration

Allow vino store staff fill in member information after member enroll enrollment signifier

OS-MU

Update Member Information

Allow vino store staff update information for member

OS-LW

List Wine

Allow member browser vino by merchandise type

OS-SC

Shoping Cart

Allow member position, update and delete vino in their cart

OS-CO

Check

Allow member submit the information of bringing and payment item.

OS-OH

Order history

Allow member to look into their order position and history

Handle Order

Function ID

Description

Requirement/Service Level

HO-UI

User-friendly interface design

Provide plenty text field and buttons

HO-OL

Order listing

Display valid order informations

HO-SF

Search map

Search order by order ID, member name, receiving system name and position

HO-OU

Update order informations

Update order position

HO-OR

Order study

Expose the order study by provide order position and day of the month

Shop Balance Management

Function ID

Description

Requirement/Service Level

SB-UI

User-friendly interface design

Provide plenty text field and buttons

SB-LS

List all shop informations

List all wine stock measure

SB-SF

Search map

Allow staff to seek book by merchandise figure, location figure and type figure

SB-US

Update shop informations

Allow staff to add new type, location, vino and update vino measure

SB-LS

List vino in lower shop degree

Allow staff to expose which vino stock is lower than 100 undersides

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

Inactive 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 maps should implement. These maps apply to test input/output for seeking, naming. The nucleus plans are described as follows.

Detailed Program Specification will be shown as the undermentioned format:

Plan Faculty

Program ID

Plan Name

Program Type

Table I/O

Screen I/O

Description

Plan Faculty: Create Member

Program ID: AD/AM/01

Plan Name: Create member information

Program Type: Online

Table I/O: Member

Screen I/O: Add Member Screen

Description: It allows staff to make full in the information of member

Plan Faculty: Amend Member

Program ID: AD/AU/01

Plan 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

Plan Faculty: Search Member by Member Name

Program ID: AD/AM/02

Plan Name: Search Member Information

Program Type: Online

Table I/O: Member

Screen I/O: Search Member Screen

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

Plan Faculty: Search Member by Member No

Program ID: AD/AM/02

Plan Name: Search Member Information

Program Type: Online

Table I/O: Member

Screen I/O: Search Member Screen

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

Plan Faculty: Create Wine

Program ID: AD/AP/03

Plan Name: Create Wine information

Program Type: Online

Table I/O: Merchandise

Screen I/O: Add Product Screen

Description: It allows the staff to make a new vino record

Plan Faculty: Amend Wine

Program ID: AD/AU/02

Plan Name: Amend Wine information

Program Type: Online

Table I/O: Merchandise

Screen I/O: Update Product Screen

Description: It allows the staff to amend the merchandise measure and information

Plan Faculty: Search Product by Product Number

Program ID: AD//AP/03

Plan Name: Search Wine Information

Program Type: Online

Table I/O: Merchandise

Screen I/O: Add Product Screen

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

Plan Faculty: Search Product by Location

Program ID: AD/AP/01

Plan Name: Search Product Information

Program Type: Online

Table I/O: Location

Screen I/O: Location and Item Screen

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

Plan Faculty: Search Product by Type

Program ID: AD/AP/02

Plan Name: Search Product Information

Program Type: Online

Table I/O: Type

Screen I/O: Location and Item Screen

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

Plan Faculty: Create Order

Program ID: MB/CR/01

Plan Name: Create Order Information

Program Type: Online

Table I/O: Order

Screen I/O: Submit Order Screen

Description: It allows the member to subject their order, payment information and bringing information

Plan Faculty: Amend Order

Program ID: AD/AO/02

Plan 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 position

Plan Faculty: Search Order By Order NO

Program ID: AD/AO/03

Plan Name: Search Order Information

Program Type: Online

Table I/O: Order

Screen I/O: Position Before Order Screen

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

Plan Faculty: Search Order by Customer First Name

Program ID: AD/AO/03

Plan Name: Search Order Information

Program Type: Online

Table I/O: Order

Screen I/O: Position Before Order Screen

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

Plan Faculty: Search Order by Status

Program ID: AD/A/03

Plan Name: Search Order Information

Program Type: Online

Table I/O: Merchandise

Screen I/O: Position Before Order Screen

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

Plan Faculty: Search Order By Member Name

Program ID: AD/AO/03

Plan Name: Search Order By Member Name

Program Type: Online

Table I/O: Order

Screen I/O: Position Before Order Screen

Description: It allows the staff to seek Member Name