An Online Mobile Phone Shop System Computer Science Essay

Published:

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

Now, shopkeeper found that sales on the decline. In 2008, sales amount is 1,500,000 dollar of year. In 2009, sales amount is 1,200,000 dollar of year and decreased by 20% over last year. Shopkeeper is very angry of this sales amount and he thing are some method to improve sales amount. So he knows internet is new market that he wants to development online mobile phone shop to Increase market share. It is because the internet was world nature, in marketing convenient to must big than location shop. In the customer nature, it can attract more different classification customer to consumption. So it can be sold in the worldwide and in the local. He hopes that maybe same year or next year can improve sale amount.

"Hi-tech Mobile Phone" only got one shop in the Sin Tat Plaza of Mong Kok. It is because salary and rent is too expense so shopkeeper not thought to open branch store. In the business scope can while operating the retail and online mobile phone shop. Do that the benefit has can keep original fixed sale turnover, and open new do are new sale method is online mobile phone shop. It is can sales amount affect fixed and overall rise increase. The all about online mobile phone shop product is saved in the location on retail. So, all product export will must in the retail. The shopkeeper has some requirement of online mobile phone shop.

Shopkeeper needs the online mobile phone shop must have are online shopping functions and the membership system and product classification information. He hopes online mobile phone shop has easy for staff and customers to use it, simple of the menu, different Operating System (OS) access system and beautiful interface of system. So the peoples can at home or organization to buying mobile phone and accessories of the online mobile shop. And the peoples can have are long times do are some research on the mobile shop. It is so swift and convenient. Important point is beautiful interface of system for online mobile shop and use easy. It is because so much to attract are peoples. So the peoples must very enjoy to buys something in the online mobile shop.

Project initialization

Recently, because about the mobile phone and mobile phone accessories information was so much, the staff in sometimes can't remember about mobile and accessories information tell us to the customers, the customers and shopkeeper also complained that it. And the local mobile shop space so small, can't accommodate so more customers, sometimes many customers will wait more time to buy are prefer products, the customers and also complained that it. Apart from this, the staff has so much pressure.

The general shopkeeper of the "Hi-tech Mobile Phone" noticed that the customer orders could be arranged by the new sales method for online mobile shop. The about all mobile and accessories information can complete record in the online mobile shop database. It can show about information on the website, in the staff psychology can reduce pressure. And the mobile shop product warehouse and online mobile shop warehouse must have are connection for database automated synchronize across the WAN relationship, it can reduce most of the problems were due to human error. Furthermore, the online mobile shop can reduce the processing time of the customer order, and increases the accuracy of data. Last, new sales method of the online mobile shop must to have the very good effect regarding the sales amount.

Chapter 2 Feasibility Report

Introduction

The feasibility report is research new system feasibility. The feasibility report is user and system requirement to development. User and system requirement was gathered through interviews, meetings, and record searching to find out information. Purpose of gathering information is fact findings and proposed solutions. The whole feasibility report will be presented to the mobile phone shop of shopkeeper.

User Requirements

Stakeholder

"Hi-tech Mobile Phone" was mobile phone shop. Shopkeeper found that sales on the decline and he wants to development internet market. His requirement our company to design and development online mobile phone shop. He needs new system function has online shopping, membership system and product information. He hopes new system can easy to use, simple of menu, different Operating System (OS) access system and beautiful interface of system. Staff expects new system can easy to management and save work times. Supplier hope new system can show their product and increase profits. Our company want to new system can easy design and development, save manpower and keep low cost to development.

Customers

"Hi-tech Mobile Phone" has many teenager and office lady to purchase. They have different proposal about online mobile phone shop. Teenagers expect online mobile phone shop can post much news about mobile phone information. Office lady hope online mobile phone shop provides different model accessories to remake their mobile phone and special discounts of any product. Guest desire online mobile phone shop provides simple menu, beautiful of interface and support different operating system to browse.

System Requirements

Online Shopping: Can online trading product that customer can online payment. Show different mobile phone and accessories to customer choose. Record customer order what is they buy. If member buy any product, member will have special discounts of any product.

Membership System: Record member information such as name, age, addresses and telephone number. Record member what is they buy product and detail. Member can change their information of system.

Product Information: Classification of different products and provide product price and details. Create second hand product area. Create mobile phone knowledge area.

Terms of References

Report of Roles

Our / we = our company

System / new system= online mobile phone shop system

Report Information

Any data or information may have incomplete or wrong. Any data or information may have omissions or delays. All rights reserved by our company.

Report Scope

The report based on user and system function requirements came to the following questions. The report scope is new system development occurs question includes:

1. Use what technical to new system?

2. How much money to new system?

3. New system occur what problem or risk?

4. Which solution is compatible new system?

5. How long complete to new system?

System Technical

1. The report shows what technical to design and development system.

2. If the technical have any problem, we don't compensate any money for your company.

3. Our company reserves the final decision to choose technical.

Finance Budget

1. The new system design and development don't over total system cost.

2. System cost include hardware, software and design & development cost.

3. The report is preliminary calculations of system cost that not final system cost.

4. The report system cost reference only.

5. Our company reserves the final decision of system cost.

Investigating and Evaluating Technical

In new system, system design and development has two things was important. One is programming language that Influence system running in what Operating System (OS). Other one is databases management system that Influence system data structure. This system is web system so that we need understand programming language and database management system about web system.

Programming Language

Different programming language support different Operating System (OS), but some programming language supports more than one OS. Web programming language compatible different OS that customer only use browser can run web programming language. Web programming language is server side coding such as ASP, JSP and PHP etc. Common use web programming language is PHP and ASP.

PHP Active Server Pages (ASP)

Programming Easy Difficult

Function Fewer More

System requirement Low High

Compatible High Low

License Open Source Proprietary

PHP programming is easy than ASP because PHP has simple coding can design and development system that similar HTML coding what is easy. But ASP has more version to design and development system; you should be long time to learning. ASP function is more than PHP because ASP can use different programming language to design and development system, such as C#, VB and .NET etc. But PHP only use our programming language design and development system that functions is fewer than ASP.

PHP system requirement is low than ASP because PHP is any client side computer can use and use little system resources to running. ASP need high system requirement to use server side computer to running. PHP can compatible different OS to use, such as Windows, Linux, and Mac etc. But ASP compatible is low; this only runs Windows side but don't run to other side OS. So that PHP is high compatible than ASP.

PHP license is open source that mean anyone can use; you don't pay any money to use and you can correct any things. ASP license is proprietary that mean anyone can use but you maybe pay money to use and you don't correct any things. Open source is best than proprietary because anyone can use; you don't pay any money to use and you can correct any things. So that PHP license is best than ASP. Overall, PHP programming, system requirement, compatible and license is best than ASP. So we choose PHP for new system programming language.

Database Management System (DBMS)

In database development, we needs choose good database management system to process data. If we choose wrong database management system, data will be wrong. So we need choose right database management system. Common in web database management system includes MySQL and SQL Server etc.

MySQL SQL Server

Function Fewer More

Control Easy Difficult

System requirement Low High

Compatible High Low

License Open Source Proprietary

MySQL function is fewer than SQL Server but control is easy than SQL Server. MySQL has simple database that function may fewer but easy to control. SQL Server has advanced database that has more function but difficult to control.

MySQL system requirement is low than SQL Server because MySQL is any client side computer to running. SQL Server need high system requirement to use server side computer to running. MySQL can compatible different OS to use, such as Windows, Linux, and Mac etc. But SQL Server compatible is low; this only runs Windows side but don't run to other side OS. So that MySQL is high compatible than SQL Server.

MySQL license is open source that mean anyone can use; you don't pay any money to use and you can correct any things. SQL Server license is proprietary that mean anyone can use but you maybe pay money to use and you don't correct any things. Overall, MySQL control, system requirement, compatible and license is best than SQL Server. So we choose MySQL for new system database management system.

Operational and Economic Factors

New system is based on investigating and evaluating technical, we know new system programming language is PHP and database management system is MySQL. But new system will be operational and economic factors affecting development.

Operational factors

We know choose what technical to development new system but new system have other operational factors affect development. Affect development new system operational factors include the following:

1. Who management of new system?

2. Staff needs training new system how to use?

3. New system need provide what function for customer to use?

New system design and development is our company but about management is your company to do. Our company provides new system training for staff. New system will provide function for customer is based on shopkeeper requirement to development. But new system starting 3 months find out problem or error, we can free to help the system maintain.

Economic factors

We understand operational factors of new system affect but economic factor of new system have important status. Economic factor can affect system has no initiation. Economic factor of new system include the following:

1. How many customers to visit new system?

2. New system can increase how much sales amount?

3. Every year need how much money about maintain system?

Based on our experience, online shop system on everyday has 1,000 peoples to visit; every month attain 30,000 peoples to visit. If you have best promotion, every month over 100,000 people to visit .In sales report of 2009, we find out online shop system every month of sales amount is over $100,000. Overall, year of sales amount is over $1,000,000. Online shop system maintain fee about $20,000 to above of year. But if you want to do other service such as change system details etc, you will pay other fee.

Now, we understand new system affect operational and economic factors, but new system has other factors affect that are cost and risk.

Cost and Risk analysis

Cost and risk analysis of new system is very important. If you don't know cost and risk of new system, you will have occurred big problem. So we need understand cost and risk of new system affect.

Cost Assessment

Cost assessment can we understand new system need how much money success development. Total cost of the new system (online mobile phone shop) system project is about $180,000.

Item Cost

Internal system development and interface design $35,000

Web based system development and interface design $40,000

System Database design $30,000

Computer hardware and software purchasing and installation $35,000

New system Installation and Training to staffs $20,000

Network setup and maintenance (One year) $20,000

Total Cost: $180,000

Risk Assessment

Risk assessment can we understand new system occur what problem that prevent and solve problem. The risk has three levels include high, middle and low. High risk is large degree of impact system running or development, so we need process high risk affect.

Risk Name System don't connect internet

Assessment High Risk (Always)

Risk Detail Customer wants to come out our system but they don't connect. The system don't connect internet. System influences our work and improves efficiency.

Solutions 1. Check network cable has no link.

2. Check computer network setting is right.

3. Contact ISP to check network problem.

Proposed Solution

In order to increase the company revenue with using online mobile phone shop system, information technology is the most efficient way to solve the problems. Actually, there are many solution, they also contain different advantages and disadvantage. Therefore, we need to compare them in technical, operational, economic, cost and risk views to decide the most suitable solution.

This document contains the detail comparison of two proposed solutions. 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.

Solution Summary

Plan A

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

Plan B

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

Solution Introduction

Plan A Plan B

General Description Centralized database system with PHP technical Database independent system with PHP technical

User Interface 1. Application interface for staff

2. Web interface for customer Same as Plan A

Software Requirements 1. Server operation system

2. Web server application

3. Database management system

4. Web development tools Same as Plan A

Hardware Requirements 1. One or more powerful server

2. Reliable storages and backup devices

3. Workstation

4. Network tools

5. Internet service 1. At least two server of database service

2. Reliable storages and backup devices

3. Workstation

4. Network tools

5. Internet service

Cost  Direct: Hardware, software, networking and training cost

 Indirect: Internet service, technical staff cost and system maintenance fee Same as Plan A

Cost-benefit Analysis Basic cost: HKD $160,000

Maintenance: HKD $20,000/year

Benefits: Profit increased by $500,000/year as more customers can be visited after the new Online Mobile Phone Shop System is implemented Basic cost: HKD $160,000

Maintenance: HKD $40,000/year

Benefits: Profit increased by $500,000/year as more customers can be visited after the new Online Mobile Phone Shop System is implemented

First year cost:$180,000

First year net benefit:$320,000

After year cost:$20,000

After year net benefit:$480,000 First year cost:$200,000

First year net benefit:$300,000

After year cost:$40,000

After year net benefit:$460,000

Staffing & Organization  Project manager

 System Administrator

 Information technology team

 Hardware/network installation company or vendor Same as Plan A

Schedule  Database and user interface development: 2 months

 Software installation: 2 weeks

 Hardware/Network installation and testing: 1 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

Total: 4 months Total: 6 months

Feasibility Analysis Schedule 1. Consider the technical feasibility

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

3. Consider the human and operational factors

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

5. Consider the political factors

6. Are there any other parties or unit against or support this project

7. Consider the financial factors

8. Calculate the actual cost and the organization budget Same as Plan A

Development Strategy 1. Internal application is developed by using programming language

2. The database is developed relation database technology

3. Web application is developed by using common web technologies

4. The hardware/network installations will be completed by company vendor Same as Plan A

Advantages 1. Able to reduce data replication

2. Integrate the booking process

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

4. Provide web-based interface The customers can access the system through internet 1. The system layouts can be customize

2. Reduce server workload and stop occur problem opportunity

3. Reduce the risk of data loss

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

Disadvantages 1. Data capacity is growing up quickly

2. Complex database cause maintenance difficultly 1. Information do not synchronize

2. Difficult to integrate the two systems

3. Manually operate across the two systems

Conclusion and Recommendation

New system is online mobile phone shop system that has two solutions to choose. Plan A is centralized database system with PHP technical and Plan B is database independent system with PHP technical. Plan A and B solutions are similar but some parts have different. Plan A and B are similar include user interface, hardware and software requirement, cost, staffing & organization, feasibility analysis schedule and development strategy. In cost-benefit analysis, Plan B is expensive than Plan A because Plan B needs maintain two or more server so that is expensive than Plan A. For schedule, we find out Plan B needs time is long than Plan A because Plan B need more time to design, development, install and testing. Plan A and B has different advantages but Plan B has disadvantages is more than Plan A. Overall, Plan A is best than Plan B because Plan A on cost-benefit analysis, schedule and disadvantage is best than Plan B. So that Plan A better solution to developing of online mobile phone shop system.

Chapter 3 Detail Investigation on New System

Analysis Current System

Current Background

"Hi-tech Mobile Phone" doesn't have any system of the shop and all staffs were needed process order, stock and sales etc. They need more time to process order steps but some customer seen staffs were busy that customer go to other shop to purchase. Shopkeeper don't recruit new staff to process order, stock and sales etc, so process order time need more. The shop could loss customer to purchase opportunity.

The shop has different customer to purchase, but main customer have teenager and office lady to purchase. The shop size was limit, sometimes customers need wait over 10 minute would enter shop. The shop received many complaints about waiting time. Some customer cannot wait long time; they will go to other shop to purchase. In the shop, it need keep more and more record that about product receipt. Government needs every shop keep product receipt over 5 years to check. Product receipt can check sales what product model and find out which date of sales and amount. Product receipt is small but it uses some storage area in the shop. But shopkeeper doesn't want to rent big size of the shop.

The shop has different mobile phone and accessories for customer to purchase. But the shop space was limit and staff doesn't display all model mobile phone and accessories. If customers find out certain model mobile phone or accessories, they may not find certain model mobile phone or accessories in the shop. The shop have many product information, staff don't remember all product information. If customer asks staff some product information, staff maybe tells some wrong information. Goodwill is very important of every shop, if you tell customer some wrong information; you will loss goodwill of the shop. In this time, not one was coming to your shop to purchase product.

Current Problem

"Hi-tech Mobile Phone" doesn't have any system of the shop that occur some problem to influence the shop sales. The problem for the following:

1. Need many times to process order steps, loss of opportunities for customers to buy.

2. The shop only has part of some customer to purchase, such as teenager or office lady. The shop cannot compatible different customer to purchase.

3. The shop space is limit but it need keep many records and cannot display all products to customer purchase.

4. The staffs don't provide correct product information for customer.

5. The customers need much time to process product order that would loss time.

Final System Requirement

New system needs to help traditional business strengthen sales amount; but also to resolve the problems of traditional business, such as wait time was too long etc. Moreover, new system needs to meet basic user requirement to development.

Basic User Requirements

Stakeholder

Shopkeeper needs new system function has online shopping, membership system and product information. He hopes new system can easy to use, simple of menu, different Operating System (OS) access system and beautiful interface of system. Staff expects new system can easy to management and save work times. Supplier hope new system can show their product and increase profits. Our company want to new system can easy design and development, save manpower and keep low cost to development.

Customers

"Hi-tech Mobile Phone" has many teenager and office lady to purchase. They have different proposal about online mobile phone shop. Teenagers expect online mobile phone shop can post much news about mobile phone information. Office lady hope online mobile phone shop provides different model accessories to remake their mobile phone and special discounts of any product. Guest desire online mobile phone shop provides simple menu, beautiful of interface and support different operating system to browse.

Final System Function

Final system function is final system requirement, based on current problem and basic user requirement that we can get final system function. Stakeholder and customer need function was different, so that have two models was administration page and customer page. Administration and customer page final system function on the following:

Administration Page

Management Online Shopping:

Check customer order detail to arrange the delivery. Update customer order record of database. Delete futile customer order record of database. Find out incomplete customer order to help customer complete order.

Management Membership System:

Create new one member record of database. Update member record of database. Delete futile member record of database. Find out member information detail to provide product information for member.

Management Product Information:

Create new product information in the customer page. Change product information detail of database. Check product information have or no outdate. Delete futile product information of database. Find out which one product information was popular for customer.

Administration Logon System:

Enhance the system's confidentiality of administration page; prevent other users to logon system to change database detail.

Customer Page

Online Shopping:

Can online trading product that customer can online payment. Show different mobile phone and accessories to customer choose. Record customer order what is they buy. If member buy any product, member will have special discounts of any product.

Membership System:

Record member information such as name, age, addresses and telephone number. Record member what is they buy product and detail. Member can change their information of system.

Product Information:

Classification of different products and provide product price and details. Display second hand product area and mobile phone knowledge area. Customer can find out product information.

Customer Logon System:

Enhance the system's confidentiality of customer page; prevent other users to logon system to change member detail.

*Shopkeeper approve final system requirement to design and development the system.

Chapter 4 Detail System Analysis

Project Assumptions

In order to ensure the online mobile phone shop system running implemented successfully in the expected time table, the following assumption and limitation should be fulfilled. The development of the whole project will be affected by any changes of the following assumption:

Scope of the System

For the scope of this new system is online mobile phone shop. The systems can different operating system to access. The system can different potential customer to purchase mobile phone and accessories. Customer just use browser connect internet to access online mobile phone shop system. Staffs can easy to control online mobile phone shop system. The system have two models was administration page and customer page.

Administration page function includes management online shopping, management membership system, management product information and administration logon system. Administration page main is management customer page record, change the system product information and check order to arrange the delivery. Customer page function includes online shopping, membership system, product information and customer logon system. Customer page main is providing online trade and payment platform, manage member account detail and display different product information.

Budget and Resources

During the development of the online mobile phone shop system, the project manager is responsible for monitoring the progress of the whole project. The mobile phone shop staff would provide resources in fact findings and functional requirement specification. Also, the user acceptance testing and training will be arranged for front staff. The detail of the estimated budget can be referred to feasibility report.

Expected Delivery Date

To improve the efficiency of front desk operation, project completion on time is very important. The online mobile phone shop system started development in September 2010 and expected to be finished in Jan 2011.

Functional Specification

Functional specification can understand the system have which function. Development staff based on functional specification to development the system.

Function Overview

Online mobile phone shop system contains two models of system, two models is administration page and customer page. The two models function on the following:

Administration Page Functions

 Management Online Shopping

 Management Membership System

 Management Product Information

 Administration Logon System

Customer Page Functions

 Online Shopping

 Membership System

 Product Information

 Customer Logon System

The above two models combine as a complete system. Each part includes many functions. In the project, the online mobile phone shop system will accomplish the above models and functions.

Function Detail

Administration page and customer page function will show you on the system function details. Function detailed will be shown as the following format:

Function ID Description Requirement/Service Level

Administration Page

Management Online Shopping

Function ID Description Requirement/Service Level

AP-MOS-S Search Order Search order record to arrange the delivery.

AP-MOS-U Update Order Update order record detail of database.

AP-MOS-D Delete Order Delete order record of database.

AP-MOS-SR Make Sales Report Use order record to make sales report.

Management Membership System

Function ID Description Requirement/Service Level

AP-MMS-S Search Member Search member account to check member detail.

AP-MMS-C Create Member Create new one member account of database.

AP-MMS-U Update Member Update member account information of database.

AP-MMS-D Delete Member Delete member account information of database.

Management Product Information

Function ID Description Requirement/Service Level

AP-MPI-S Search Product Search product information to check product detail.

AP-MPI-C Create Product Create new one product information of database.

AP-MPI-U Update Product Update product information of database.

AP-MPI-D Delete Product Delete product information of database.

Administration Logon System

Function ID Description Requirement/Service Level

AP-ALS-L System Logon User enters username and password to use administration page menu.

AP-ALS-LO System Logout Logout administration page menu to close system.

AP-ALS-R Reset Username and Password Reset user enters username and password.

Customer Page

Online Shopping

Function ID Description Requirement/Service Level

CP-OS-SC Shopping Cart Allow customer view, update and delete product in their cart.

CP-OS-CO Checkout Allow member submit their order, payment detail, delivery address. If member purchase any product, they can get discount.

CP-OS-IV Input Validation Prompt the message when incorrect data input.

CP-OS-OH Order History Allow customer or member to check their order status and history.

Membership System

Function ID Description Requirement/Service Level

CP-MS-C Change Member Account Information Change member account information of database.

CP-MS-PR Member Account Purchase Record Show member past purchase

Product Information

Function ID Description Requirement/Service Level

CP-PI-S Search Product Information Allow customer search product information of database.

CP-PI-L List Product Information Allow customer browser product follow the category.

Customer Logon System

Function ID Description Requirement/Service Level

CP-CLS-L System Logon User enters username and password to use administration page menu.

CP-CLS-LO System Logout Logout customer page menu to close system.

CP-CLS-R Reset Username and Password Reset user enters username and password.

CP-CLS-F Forget User Password If user forget password, user can click to reset password.

Logical system analysis

Logical system analysis includes system flow, dynamic model of the system, static model and data dictionary.

System Flow

Online Mobile Phone Shop System

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.