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.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 wordAgenda: 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 wordsAgenda: 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 formattingRecently, 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 fromDirectorGeneral ManagerWine Shop ManagerCounter StaffSystem AdministratorThe 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 FindingssProposed SolutionsThe 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 designWeb based system development and interface designSystem Database designComputer hardware and package buying and installing.

New system Installation and Training to staffsNetwork apparatus and careTechnology competence and consistenceOnline 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 workgroupEasy to pull off user history and user permissionShare files and pressmans faithfully, expeditiously and firmlyMany computing machine package and hardware is compatible on ApacheThe 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:DirectorPrepare budgets, proctor grosss and disbursalsDevelop, implement and measure policies and processs for the vino storeSupply the top-level direction information and authorise back uping the system analystGeneral ManagerResponsible for the overall operation of the vino storeSet vino monetary value, apportion financess to sections, O.K. outgosReview monthly and annual study about gross revenuesEnsure criterion of the serviceResponsible for the daily operation in the vino storeWine Shop ManagerCoordinate vino reserves every bit good as train the vino store counter staffEnsure that client are treated politely, ailments and jobs are resolved, and petitions for particular services are carried outAssist in treating wine order, wine reserves and member enrollmentGive guidelines and work out the job while the antagonistic staff utilizing the systemVerify client record, better the service to fulfill the clientDecide the client ‘s ailmentCounter StaffResponsible for wine reservesCheck day-to-day record sheets, client inside informations, grosss and verifiers utilizing computerized or manual inputTo manage the client payment and give the reception to themAnswer the questions sing vino reserve services and enrollmentReact the clients ‘ ailments to Wine Shop ManagerSystem AdministratorPrepare backup and recovery process of the systemKeep the computing machine web dependable and stable

Findings- User Requirements

Expected BenefitsDirectorBetter the efficiency of Wine Shop OperationProvide extremely security for client informationGeneral ManagerProvide truth information of monthly and annual studySupply User-friendly interfaces to recover the informationTo better the vino store service make the client to be satisfiedWine Shop ManagerRegister the client information and vino reserve procedure would be fasterTo cut down the preparation clip on the new systemPrompt warning and mistake message briefly, clearlySupply a aid bill of fare to expose the system mapsCounter StaffRegister and recover record would be fasterBetter user-friendly interfaces for inputting and seeking recordBetter coding for record sheet filing and retrievingSystem AdministratorControl the entree manner for different userTo command the system at any computing machinesKnowledge and skill competence in engineeringDirectorExcellent direction and organisation accomplishmentBasic construct about the new systemGeneral ManagerExcellent control, direction and analytical accomplishmentBasic construct about the new systemGood control and direction accomplishmentBasic construct about the new systemWine Shop ManagerGood construct about the new systemExperience in computing machine operationGood typewriting accomplishmentCounter StaffKnowledge in typing and Personal computer operation accomplishmentsSystem AdministratorIn deepness cognition about hardware and packageTo work out job accomplishment in web and computing machine countriesMySQL Relational Database Management System ( RDBMS ) cognition is required

Finding – System Requirements

Functional demandsThe databaseInclude all the vino store information such as client information and vinos inside informations ( type, merchandise or location ) , staff name, staff ID, gross revenues historyUser interfaceUser-friendly interfaces design which allows the user to utilize the new system easy and make non utilize much clip for preparationTo forestall unauthorised user to entree the system, the security login screen is necessarySupply the interface for staff to update and enquiry the informationComputer and NetworkingTo hive away the immense sum of informations, the waiter demand to big difficult disc capacityTo shorten process clip, the waiter need to more RAMProvide appropriate backup and recovery servicesProvide appropriate degree of security controlProvide virus controlProvide 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 proposedThere 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 engineeringDatabase Independent System with password hallmark engineering

User Interface

Application interface for staffWeb interface for clientLapp as Plan A

Software demands

Server operation system with web waiter service, Database and web interface development toolsLapp as Plan A

Hardware demands

One or more powerful waiter with dependable storages and backup devicesPerform ClusteringWorkstationNetwork installingInternet ConnectionAt least two databases serverWorkstationsNetwork installingInternet Connection

Agenda

Database and user interface development: 2.5 monthsSoftware installing: 2 hebdomadsHardware/Network installing and testing: 2 month.Training: 2 hebdomadsDatabase and user interface development: 3 monthsSoftware installing: 2 hebdomadHardware/Network installing and testing: 2 monthTraining: 2 hebdomads

Staffing & A ; organisation

Undertaking director, System Administrator, information engineering squad, hardware/network installing company or sellerLapp as Plan A

Feasibility analysis agenda

See the proficient feasiblenessWhether the degree of technological promotion needed, to find the handiness and the stableness on the appropriate engineering.See the homo and operational factorsConcerned with human, organisational facets. For illustration, will recruitment be necessary and what preparation will be required?See the political factorsAre there any other parties or unit against or back up this undertaking?See the fiscal factorsCalculate 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 communicationWeb application is developed by utilizing common web engineerings.The database is developed by utilizing relation database engineeringThe hardware/network installings will be completed by company seller.Lapp as Plan A

Cost-benefit analysis

Basic cost: HKD $ 1,880,000Care: HKD $ 300,000/yrBenefits: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,000Entire monthly benefit:HKD $ 800,000Basic cost: HKD $ 1,880,000Care: HKD $ 300,000/yrBenefits: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,000Entire monthly benefit:HKD $ 800,000

Cost

Direct: Hardware, package, networking and preparation costIndirect: Internet service, proficient staff cost and system care feeLapp as Plan A.

Benefits

Able to cut down informations reproductionIntegrate the wineing procedureSimplify 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-makeSimilar to old system, the staffs easy to larnSupply web-based interface. The clients can entree the system through cyberspace.

Disadvantages

Data capacity is turning up rapidly.Complex database cause care difficultlyInformation do non synchronisehard to incorporate the two systemsmanually 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 operatingThe 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 formatThe 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 EnvironmentThere 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 manuallyRecently, 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 hoursThe 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 studyAt 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 resourcesCustomer 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 engineeringThe 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 concernTime devouring in replying client jobThe 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 statusSince 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 studyIt 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 4Detail 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 SystemFor 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 ResourcesDuring 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 DateThe 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

OverviewThe Online Wine System contains three parts of system:Online ShoppingHandle OrderWarehouse ManagementThe 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 ShoppingFunction IDDescriptionRequirement/Service LevelOS-UIUser-friendly interface designProvide plenty text field and buttonsOS-CVCheck Data ValidationMotivate the message when incorrect informations inputOS-MRMember RegistrationAllow vino store staff fill in member information after member enroll enrollment signifierOS-MUUpdate Member InformationAllow vino store staff update information for memberOS-LWList WineAllow member browser vino by merchandise typeOS-SCShoping CartAllow member position, update and delete vino in their cartOS-COCheckAllow member submit the information of bringing and payment item.

OS-OHOrder historyAllow member to look into their order position and historyHandle OrderFunction IDDescriptionRequirement/Service LevelHO-UIUser-friendly interface designProvide plenty text field and buttonsHO-OLOrder listingDisplay valid order informationsHO-SFSearch mapSearch order by order ID, member name, receiving system name and positionHO-OUUpdate order informationsUpdate order positionHO-OROrder studyExpose the order study by provide order position and day of the monthShop Balance ManagementFunction IDDescriptionRequirement/Service LevelSB-UIUser-friendly interface designProvide plenty text field and buttonsSB-LSList all shop informationsList all wine stock measureSB-SFSearch mapAllow staff to seek book by merchandise figure, location figure and type figureSB-USUpdate shop informationsAllow staff to add new type, location, vino and update vino measureSB-LSList vino in lower shop degreeAllow staff to expose which vino stock is lower than 100 undersides

Logical system analysis

System FlowThe 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.5The dataflow diagram of the Online Wine Shop System can be referred to Appendix 1.

6, 1.7Inactive 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 DictionaryThe 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 FacultyProgram IDPlan NameProgram TypeTable I/OScreen I/ODescriptionPlan Faculty: Create MemberProgram ID: AD/AM/01Plan Name: Create member informationProgram Type: OnlineTable I/O: MemberScreen I/O: Add Member ScreenDescription: It allows staff to make full in the information of memberPlan Faculty: Amend MemberProgram ID: AD/AU/01Plan Name: Amend Member informationProgram Type: OnlineTable I/O: MemberScreen I/O: Update Member ScreenDescription: It allows staff to update information for memberPlan Faculty: Search Member by Member NameProgram ID: AD/AM/02Plan Name: Search Member InformationProgram Type: OnlineTable I/O: MemberScreen I/O: Search Member ScreenDescription: It allows staff to seek member information by member namePlan Faculty: Search Member by Member NoProgram ID: AD/AM/02Plan Name: Search Member InformationProgram Type: OnlineTable I/O: MemberScreen I/O: Search Member ScreenDescription: It allows staff to seek member information by Member NumberPlan Faculty: Create WineProgram ID: AD/AP/03Plan Name: Create Wine informationProgram Type: OnlineTable I/O: MerchandiseScreen I/O: Add Product ScreenDescription: It allows the staff to make a new vino recordPlan Faculty: Amend WineProgram ID: AD/AU/02Plan Name: Amend Wine informationProgram Type: OnlineTable I/O: MerchandiseScreen I/O: Update Product ScreenDescription: It allows the staff to amend the merchandise measure and informationPlan Faculty: Search Product by Product NumberProgram ID: AD//AP/03Plan Name: Search Wine InformationProgram Type: OnlineTable I/O: MerchandiseScreen I/O: Add Product ScreenDescription: It allows the staff to seek Wine record by Product NumberPlan Faculty: Search Product by LocationProgram ID: AD/AP/01Plan Name: Search Product InformationProgram Type: OnlineTable I/O: LocationScreen I/O: Location and Item ScreenDescription: It allows the staff to seek book record by Location NumberPlan Faculty: Search Product by TypeProgram ID: AD/AP/02Plan Name: Search Product InformationProgram Type: OnlineTable I/O: TypeScreen I/O: Location and Item ScreenDescription: It allows the staff to seek Product record by Type NumberPlan Faculty: Create OrderProgram ID: MB/CR/01Plan Name: Create Order InformationProgram Type: OnlineTable I/O: OrderScreen I/O: Submit Order ScreenDescription: It allows the member to subject their order, payment information and bringing informationPlan Faculty: Amend OrderProgram ID: AD/AO/02Plan Name: Amend Order InformationProgram Type: OnlineTable I/O: OrderScreen I/O: Update Order ScreenDescription: It allows the staff to amend the order positionPlan Faculty: Search Order By Order NOProgram ID: AD/AO/03Plan Name: Search Order InformationProgram Type: OnlineTable I/O: OrderScreen I/O: Position Before Order ScreenDescription: It allows the staff to hunt Order by Order NumberPlan Faculty: Search Order by Customer First NameProgram ID: AD/AO/03Plan Name: Search Order InformationProgram Type: OnlineTable I/O: OrderScreen I/O: Position Before Order ScreenDescription: It allows the staff to hunt Order by Customer First NamePlan Faculty: Search Order by StatusProgram ID: AD/A/03Plan Name: Search Order InformationProgram Type: OnlineTable I/O: MerchandiseScreen I/O: Position Before Order ScreenDescription: It allows the staff to hunt Order by Order StatusPlan Faculty: Search Order By Member NameProgram ID: AD/AO/03Plan Name: Search Order By Member NameProgram Type: OnlineTable I/O: OrderScreen I/O: Position Before Order ScreenDescription: It allows the staff to seek Member Name