Report-computer Shop Management System

1

INTRODUCTION 1. INTRODUCTION 1.1 Introduction

This system will be used for making quotations of requested amount for the user. The billing system will use current system date and time. However its user can manually set the date and time of purchase and can make changes in the amount which will be special feature available in the control panel of this system. Under generating bill section, its user have to make entry in the field of particular model and its serial number after which it will display the brand name of the products, its cost price and service tax. Then after total amount will be generated for total number of products along with the address details of the seller. This system will also include the name, address and mobile number of the customer. Each bill will have a unique number generated by the system automatically. As this system will also help the vendor to keep track of number of products available, time of purchase. If any products whose total number will be less than 2 will comes under the blue zone indicating it’s time to purchase that product. It will also display other details such as last time when it is purchased, at what price it was purchased, from where it is purchased, total number of products which was purchased last time. Administrator can also make changes in the billing process, such as increase or decrease in service tax value, discount to be given to the customer on particular product. Making changes in billing process as per user requirement or for other business rules

1.2 Scope of Project

The scope of project ‘Computer-shop management system’ is to Develop Visual Basic based software to support for daily sale, receipt & Balance of products and maintain the all information of System related items. This software will be very useful for the Big Computer Shop as well as the customer. It will perform as the required task of Automation of product by itself in a systematic way. It will also save lots of time, as system will perform all tasks in quick time profiting customer and shop owner as well, so it will prove very economical in every respect.

2

SYSTEM OVERVIEW

2. System overview

2.1.Existing System:

The computer shop contains different types of computer’s of various configuration with various company according to the customer’s needs and requirement. It is necessary for every business to maintain all records. In today’s life people have very little time and many things To do. They have to manage all this unbalance workload, although everyone wants to achieve all their ambitions and dreams. And the present system of managing computer shop is very time consuming so it is very difficult to maintain good records and fast service. The paper work is becoming very difficult to handle day by day. Currently we have to keep track of each and every thing about the computer shop on the paper or in register. We have to maintain lot of registers to enter these large volumes of data. This leads to the wastage of stationary.

2.2. Problems with Existing System.  

Manual system involves a lot of paper work, so it becomes time-consuming and costly. The chances of errors in calculation of delivery of computer are more in the current manual system. The calculation of total collection for day or month or year is very



difficult. Currently no security is provided to the large amount of data of the every computer part



details. It becomes very difficult to maintain details of every computer as records increases day by day

2.3. Solution on Problem

This Computer Shop Management system will be used for making quotations of requested amount for the user. The billing system will use current system date and time. However its user can manually set the date and time of purchase and can make changes in the amount which will be special feature available in the control panel of this system. Under generating bill section, its user have to make entry in the field of particular model and its serial number after which it will display the brand name of the products, its cost price and service tax. Then after total amount will be generated for total number of products along with the address details of the seller. This system will also include the name, address and mobile number of the customer. Each bill will have a unique number generated by the system automatically. Some advantages are:

User – Friendly software  Easy to record all data about the Books and its details  It saves time of the user as well as prevent paper work  It provides the security to the database that is large amount of important data of the Shop  It provides more reliability for keeping information.

Book

3 HARDWARE AND SOFTWARE REQUIREMENTS Hardware Requirement: Here is the recommended hardware requirement for this software to run efficiently. 1) Pentium 166 MHz or higher processor 2) 32 MB RAM 3) 50 MB free hard disc space 4) SVGA monitors 5) Printer (Optional)

Software Requirement: This software comes under application software. So the necessary software for this is 1) Windows operating system family. 2) Window 9x, (that is window 95, 98, ME, etc.) 3) Window NT, 2000, 2003, XP

Chapter 4 Requirement Analysis Identifying needs is the first step while designing a system and implementation. This is the way to handle user needs, it must be an outgoing process to know requirements of customer during whole system development life cycle. During this phase the main things to be considered are got by placing meetings and questionnaires with customer. Requirements found during all the stages proposed system development are  How the present system work.  Time take to operate the system.  List of contents associated with the system.  Error/failure rate to be acceptable.  Risk factors involved.  Proprietary aspects, liability risks, potential infringement, and political issues to consider.  Human-machine and machine-machine communication.  Interfacing with external environment

4.1 Feasibility study Depending on the results of the initial investigation the survey is now expanded to a more detailed feasibility study. “FEASIBILITYSTUDY” is a test of system proposal according to its workability, impact of the organization, ability to meet needs and effective use of the resources. It focuses on these major questions: 1.What are the user’s demonstrable needs and how does a candidate system meet them? 2. What resources are available for given candidate system? 3. What are the likely impacts of the candidate system on the organization? 4. Whether it is worth to solve the problem? During feasibility analysis for this project, following primary areas of interest are to be considered. Investigation and generating ideas about a new system does this. Steps in feasibility analysis eight steps involved in the feasibility analysis are:  Form a project team and appoint a project leader.  Prepare system flowcharts.  Enumerate potential proposed system.  Define and identify characteristics of proposed system.  Determine and evaluate performance and cost effective of each proposed system.  Weight system performance and cost data.  Select the best-proposed system.  Prepare and report final project directive to management. Feasibility study is the procedure to identify, describe the evaluate candidate system and select the best possible action for the job. The initial investigation

culminated in a proposal summarized the thinking of the analyst, was presented to the user for review. The proposal initiated a feasible study to describe and evaluate the best system to choose in terms of economical, technical and behavioral constraints. The terms constraints involved in feasibility analysis areo Technical o Economical o Operational o Behavioral

4.2. Technical Feasibility  A study of resource availability that may affect the ability to achieve an acceptable system. This evaluation determines whether the technology needed for the proposed system is available or not.  Can the work for the project be done with current equipment existing software technology & available personal?  Can the system be upgraded if developed?  If new technology is needed then what can be developed? This is concerned with specifying equipment and software that will successfully satisfy the user requirement. The technical needs of the system may include: Front-end and back-end selection

An important issue for the development of a project is the selection of suitable front-end and back-end. When we decided to develop the project we went through an extensive study to determine the most suitable platform that suits the needs of the organization as well as helps in development of the project. The aspects of our study included the following factors. Front-End selection 1. It must have a graphical user interface that assists employees that are not from IT background. 2. Scalability and extensibility. 3. Flexibility. 4. Robustness. 5. According to the organization requirement and the culture. 6. Must provide excellent reporting features with good printing support. 7. Platform independent. 8. Easy to debug and maintain. 9. Event driven programming facility. 10. Front-end must support some popular back end like MS Access. According to the above stated features we selected Java 1.6 as the front-end for developing our project. Back-End Selection 1. Multiple user support. 2. Efficient data handling.

3. Provide inherent features for security. 4. Efficient data retrieval and maintenance. 5. Stored procedures. 6. Popularity. 7. Operating System compatible. 8. Easy to install. 9. Various drivers must be available. 10. Easy to implant with the Front-end. According to above stated features we selected MS-Access as the backend. The technical feasibility is frequently the most difficult area encountered at this stage. It is essential that the process of analysis and definition be conducted in parallel with an assessment to technical feasibility. It centers on the existing computer system (hardware, software etc.) and to what extent it can support the proposed system.

4.3. Economic Feasibility Economic justification is generally the “Bottom Line” consideration for most systems. Economic justification includes abroad range of concerns that includes cost benefit analysis. In this we weight the cost and the benefits associated with the candidate system And if it suits the basic purpose of the organization i.e. profit making, the project is making to the analysis and design phase. The financial and the economic questions during the preliminary investigation are verified to estimate the following:

 The cost to conduct a full system investigation.  The cost of hardware and software for the class of application being considered.  The benefits in the form of reduced cost.  The proposed system will give the minute information, as a result the performance is improved which in turn may be expected to provide increased profits.

4.4. Behavioral Feasibility After considering the following point that the system is behaviorally feasible. The project is carried out on the request of the users. To a greater extent, the proposed system aims at maximizing user friendliness. This is intended to overcome resistance to change by the exiting staff. Users are quite experienced in handling the computerized system. Users are aware of the software and hardware environment.

Chapter 5 system design and modeling

system Design Software design is an actually a multi-step process that focuses on four distinct attributes of program namely data structure, software architecture, interface representation and procedural details. The design process translates requirements into a representation of the software that can be assessed for quality before code generation begins. The design is documented and is part of the software configuration. Code Generation The design must be translated into a machine readable form. The code generation steps perform this task. Testing The testing process focuses on the logical internals of the software assuring that all statements have been tested and on the functional externals that is

conducting tests to uncover errors and ensure that defined input will produce actual results that agree with required. Maintenance Software will undoubtedly undergo changes after it is delivered to the customer. Change will occur because errors have been

LOGICAL DIAGRAM

DATA FLOW DIAGRAM

ZERO LEVEL DFD

FRIST LEVEL DFD

ER DIAGRAM

Chapter 6 DATABASE DESIGN

Chapter 7 INPUTE AND OUTPUTE FORMS

Chapter 8 Reports

Chapter 9 LIMITATIONS Though the system has been designed according to the requirements of the users it has its own limitation. Thus the limitation of system are No facility to create new users with different roles  Object oriented Approach has been not been fully utilized

Chapter 10 FUTURE ENHANCEMENT The future scope of this software is given below.

• Customize bills that you print! • Create estimates and latter convert it into bills! • Reports to make comparisons between months (total sum, or sum by employees)! • Sell computer system by installments! • Print bills with currency sign. • Different kind of reports. • Pay - roll administration for your employees! • Keep track of you suppliers! • Server database is protected from unauthorized modifications! • Process payments quickly and efficiently! • Unique design with very functional user interface!

Chapter 11 CONCLUSION This system computerizes the computer shop management process in any computer shop. It manages the different operations in computer shop such as maintain record of available computer/parts, sale computer, purchase computer, stock in or stock out New features and modules can be added into the system as per user requirement.

Chapter 12 BIBLOGRAPHY Books: 1) Programing Microsoft visual basic 6.0 2) Mastering visual basic 6 3) Black book visual basic 4) Complete reference in visual basic 6 5) System analysis and design by elias m. awad Websites: 1) www.a1vbcode.com

2) www.vbcode.com

3) www.codeguru.com

4) www.vbexpert.com

5) www.1000project.com