This is Srs Document Prepared by me fot partial complite of MCA 4th sem. This was my firs project. It includes software requirement details and screenshots of system, and source codes etc.Full description
Full description
project report on book shop management system.Full description
project report on book shop management system.Full description
Full description
Full description
This is the project report on Library management System.
Hospital Management system full Project Report
Full description
A full project documentation on Insurance Management System
Project Report on Computer Networks
Project Report on Computer Networks
If you need this project then you call or whatsapp me on +91-8376986802. You can also write email us on [email protected] For Project Details, Below URL: http://www.freeproj…Full description
The aim of our project is to develop a system that is meant to partially computerize the work performed in the Employee Management System. In this software we can add employee details according to ...
very useful document
Full description
Project report with Oracle FormsFull description
Full description
Full description
If you need this project then you call or whatsapp me on +91-8376986802. You can also write email us on [email protected] For Project Details below URL: http://www.freeprojectz.com...Full description
If you need this project then you call or whatsapp me on +91-8376986802. You can also write email us on [email protected] For Project Details below URL: http://www.freeproje…Full description
If you need this project then you call or whatsapp me on +91-8376986802. You can also write email us on [email protected] For Project Details: http://www.freeprojectz.com/pr…Description complète
Project Report of Computer Shop Management System
Title of the Project
Computer Shop Management System (1)
Project Report of Computer Shop Management System
Introduction In Computer Shop Management System, it store records of suppliers, hardware, software, sale, purchase and customer’s records are maintained and manipulated. There is now some investigations are involved to find out or to correctly done the work. Generally these works are done and managed, manually hence leading to the chances of human errors that may create some problems. Thus, a secured and reliable system is required to handle it. Computer Shop Management System, as described above, can lead to error free, secure, reliable and fast management system. It can assist the staff to concentrate on their other activities rather to concentrate on the record keeping. Thus it will help organization in better utilization of resources.
(2)
Project Report of Computer Shop Management System
Objective of the Project This project deals with the management and transaction criteria of the Computer Shop Management System. Shop is a place where the work is to sale the hardware prepare bill, maintain purchasing and stock in shop and keeps their records, and prepare reports. The aim is to automate its existing manual system by the help of computerized equipments and full-fledged computer software, fulfilling their requirements.
The main objectives behind the development of this project are as follows: 1) To assist the staff in capturing the effort spent on their respective working areas. 2) To utilize resource of the institution in an efficient manner by increasing their productivity through automation. 3) To keep and manipulate suppliers information. 4) To keep and manipulate hardware details. 5) To provide facility to sale at shop and prepare customer bill. 6) To make enquiry of a particular sale 7) To maintain the purchase and stock at shop.
(3)
Project Report of Computer Shop Management System
Project Category “RDBMS PROJECT” The project is application software that satisfies the application area of hotel. The project comes under RDBMS category. The project handles the huge data in hostel subjected to customers their rooms, food and rent and other charges. The RDBMS is capable of creating storage, keeping date, manipulating data and retrieving data in desired manner.
(4)
Project Report of Computer Shop Management System
TOOL/LANGUAGES TO BE USED a) Operating System The proposed software is targeted to run on Windows Xp, Windows NT version 2.0 (Server/Workstation) and Windows 2000 (Professional/Server) editions. b) Front End JSP is being used as Front End due to its productivity and maintainability. Java Server Pages (JSP) is a technology for controlling the content or appearance of Web pages through the use of servlets, small programs that are specified in the Web page and run on the Web server to modify the Web page before it is sent to the user who requested it. Sun Microsystems, the developer of Java, also refers to the JSP technology as the Servlet application program interface (API). c) Back End (Central Repository) MY-SQL is being used as Back End for application’s central repository. The reasons to choose it as back-end are: I. It is very simple to maintain. II. It is highly secured. III. It can be integrated with JSP very easily. IV. It can support and manage a large amount of data. V. It is a very scalable product and can support as many number of users as supported by the infrastructure.
(5)
Project Report of Computer Shop Management System
SYSTEM ANALYSIS The analysis model is a concise, precise abstraction of what the desired system must do, and not how it will be done after the study of the existing system is completed. This basically includes system study and the requirement analysis. Interacting with the clients regarding their requirements and expectations from the system does requirement analysis. The steps, which are essential for system analysis, are: 1.
Research and define essential components.
2.
Analyse current processes and identify gaps.
3.
Interview users, shopkeepers, customers and other concerned personnel
regarding essential components and current
processes.
4.
Write requirements document.
5.
Define standards for standards, policies, and procedures.
6.
Review draft requirements document with users, shopkeeper, customers
and other concerned personnel. 7.
Update and expand project plan.
(6)
Project Report of Computer Shop Management System Identifications of the need COMPUTER SHOP MANAGEMENT SYSTEM as described above can lead to error free, secure, reliable and fast management system for the shop. It can assist the staff to concentrate on their activities rather to concentrate on the records and reports of computers, cost and customers. This will help organization in better utilization of human resources. WHAT to do with it The Computer shop can maintain computerized member Register without redundant entries. It can even search a parts, company etc within a moment of time without any trouble from a database of thousand of customers and visitors. That means that one need not be distracted by information that is not relevant, while being able to reach the information that is relevant much more quickly. Instead of conventional reports it can generate more presentable and automated reports. Besides, financial and MIS level reports can be generated to assist the management and concerned staff. Preliminary Investigation Benefit to Organization The organization will obviously be able to gain benefits such as savings in operating cost, reduction in paperwork, better utilization of human resources and more presentable image increasing goodwill. The other benefits are improved service and faster and better access to up-to-date information. The Initial Cost (7)
Project Report of Computer Shop Management System The initial cost of setting up the system will include the cost of hardware (server/clients, network adapter and related hardware), software (server OS, add-on software, utilities) & labour (setup & maintenance). The same has to bear by the organization. Running Cost Besides, the initial cost the long term cost will include the running cost for the system including the AMC, stationary charges, cost for human resources, cost for update/renewal of various related software. Need for Training The users along with the administrator need to be trained at the time of implementation of the system for smooth running of the system. The client will provide the training site. Depending upon this definition, we analyzed the present COMPUTER SHOP that was being maintained manually. During the analysis process, we had to go through the entire manual system that was being followed in the Organization for past few years. We talked to the management people who were managing a the financial issues of the shop, the shop’s staff who were keeping the records in lots of registers and the reporting manager regarding their existing system, their requirements and their expectations from the new proposed system. Then, we did the system study of the entire system based on their requirements and the additional features they wanted to incorporate in this system.
(8)
Project Report of Computer Shop Management System The manual Computer Shop system was very complex to be managed and searching or updating the information of Computers, companies and customers was also very difficult. There was a lengthy procedure for entering the sold Computers and returned information in one register. First along with the member to be bought for them and later on after selling the Computers by the shopkeeps, it has to be maintained in the registers . The other problem with the manual system was of report generation. The reports to be generated on a daily/weekly/monthly basis required lot of paper work and calculations etc. Thus, Reporting Manager had to manually calculate all the consultation fees of every member at the end of every day/week/month. Even a small calculation mistake was leading to reanalysis and recreation of whole work. Reliable, accurate and secure data was also considered to be a complex task without this proposed system. Because there used be no such record for keeping track of all the activities done by the employees on the daily basis. The new system proposed and then developed by me will ease the task of the managing shop in consideration. It will be helpful in generating the required reports based on the parameters required by the management, which will help them to track their progress and services.
(9)
Project Report of Computer Shop Management System Thus, it will ease the task of shop staff to a great extent as all the major activities to be performed, related to reporting, are computerized through this system.
(10)
Project Report of Computer Shop Management System
FEASIBILITY STUDY The feasibility study is the important step in any software development process. This is because it makes analysis of different aspects like cost required for developing and executing the system, the time required for each phase of the system and so on. If these important factors are not analyzed then definitely it would have impact on the organization and the development and the system would be a total failure. So for running the project and the organization successfully this step is a very important step in a software development life cycle process. In the software development life cycle after making an analysis in the system requirement the next step is to make analysis of the software requirement. In other words feasibility study is also called as software requirement analysis. In this phase development team has to make communication with customers and make analysis of their requirement and analyze the system. By making analysis this way it would be possible to make a report of identified area of problem. By making a detailed analysis in this area a detailed document or report is prepared in this phase which has details like project plan or schedule of the project, the cost estimated for developing and executing the system, target dates for each phase of delivery of system developed and so on. This phase is the base of software development
process
since
further
steps
taken
in software development life cycle would be based on the analysis made on this phase and so careful analysis has to be made in this phase.
(11)
Project Report of Computer Shop Management System
Though the feasibility study cannot be focused on a single area some of the areas or analysis made in feasibility study is given below. But all the steps given below would not be followed by all system developed. The feasibility study varies based on the system that would be developed.
Feasibility study is made on the system being developed to analyze whether the system development process require training of personnel. This help in designing training sessions as required in later stage.
Is the system developed has scope for expanding or scope for switching to new technology later if needed in ease. In other study is made to find the portability of the system in future. .
Is the cost of developing the system high or does it meet the budgeted costs. That is a cost benefit analysis is made. In other words an analysis is made on cost feasibility of the project. This helps in identifying whether the organization would meet the budgeted costs and also helps the organization in making earlier and effective plans for meeting extra costs because of the system development.
Analysis is made on what software to use for developing the system. This study and analysis would help to choose the best implementation for system and the organization. This feasibility study includes factors like scalability, how to install, how to develop and so on. This feasibility study in short includes the analysis of technical areas. This analysis helps the efficiency of the system developed to get (12)
Project Report of Computer Shop Management System improved. This is because by choosing the correct technology by making analysis on the needs of system helps in improving the efficiency of the system.
The above feasibilities are analysis which helps in development of the system. But the scope of feasibility study does not end with this. Analysis or feasibility study also includes the analysis of maintenance stage. In other words feasibility study is made to analyze how one would maintain the system during maintenance stage. This helps sin planning for this stage and also helps in risk analysis. Also the analysis helps in making analysis about what training must be given and how and what all documents must be prepared to help users and developers to face maintenance phase.
(13)
Project Report of Computer Shop Management System Advantages of making Feasibility study:
There are many advantages of making feasibility study some of which are summarized below:
This study being made as the initial step of software development life cycle has all the analysis part in it which helps in analyzing the system requirements completely.
Helps in identifying the risk factors involved in developing and deploying the system.
The feasibility study helps in planning for risk analysis
Feasibility
study helps
in
making
cost/benefit
analysis
which
helps
the organization and system to run efficiently.
Feasibility study helps in making plans for training developers for implementing the system.
So a feasibility study is a report which could be used by the senior or top persons
in
the organization.
This
is
because
based
on
the
report
the organization decides about cost estimation, funding and other important decisions which is very essential for an organization to run profitably and for the system to run stable. (14)
Project Report of Computer Shop Management System The feasibility study that was done for this project included the following considerations 1. Economical Feasibility This is a very important aspect to be considered while developing a project. We decided the technology based on minimum possible cost factor. All hardware and software cost has to be borne by the organization. We analyzed the existing system and concluded that the existing systems with the organization only needed to be updated to newer configuration instead of going for new hardware setups. Overall we have estimated that the benefits the organization is going to receive from the proposed system will surely overcome the initial costs and the later on running cost for system.
2. Technical Feasibility This included the study of function, performance and constraints that may affect the ability to achieve an acceptable system. For this feasibility study, we studied complete functionality to be provided in the system, as described in the System Requirement Specification (SRS), and checked if everything was possible using JSP and MYSQL or not. After the study we came to conclusion that we can proceed further with the tools and development environment chosen by us. This was important in our case as we were working on two various phases of the department that will need to be (15)
Project Report of Computer Shop Management System integrated in future to make an extended system.
3. Operational Feasibility No doubt the proposed system is fully GUI based that is very user friendly and all inputs to be taken all self-explanatory even to a layman. Besides, a proper training has been conducted to let know the essence of the system to the users so that they feel comfortable with new system. As far our study is concerned the clients are comfortable and happy as the system has cut down their loads and doing all the complex activities itself.
4. Resource Availability This is also an important check to be done that the required resources will be available or not. As far as Software and Hardware were considered, there was no such constraint using JSP and MYSQL as front end and Back end respectively. 5. Problem Statement The problem is to design and develop software to handle the Computers, company details, cost prices, customer’s details in the Shop and prepare the report of a particular Computer and company and to handle the records of other enquiries which come to shop. There is lack of coordination among various related processes of the shop that should be checked out. Besides, there exist various problems in data handling such as a large number of registers to be maintained separately, loss of data due to inefficient entry, data redundancy and complex manipulation of data in (16)
Project Report of Computer Shop Management System searching particulars entry. The problem can be divided into sub problems like… 1. To keep and manage Computer detail. 2. To keep and manage company information. 3. To prepare price details. 4. To manage customers and billing process. 5. To maintain salary record of all the employee.
(17)
Project Report of Computer Shop Management System 6. Requirement Analysis The organization requires computerizing its shop to fully automate its corresponding activities. The requirements from the proposed software are as follows: 1)
To keep and manage Computer detail.
2)
To keep and manage company information.
3)
To prepare price details.
4)
To manage customers and billing process.
5)
To maintain salary record of all the employee
7. Design The table structure for the various tables to be used in the proposed software is described in Data Structure part of this proposal. The data flow in the software is depicted in Data Flow Diagram (DFD).
(18)
Project Report of Computer Shop Management System
DFD ER Diagram Table Structure of Computer Shop Management System
(19)
Computer Shop ManagemenSystem
Project Report of Computer Shop Management System
(DFD) DATA FLOW DIAGRAM
DATA BASE
Customer
Dealer
Zero Level DFD
(20)
Project Report of Computer Shop Management System
Access
Order Details
First Level DFD (21)
Update
Project Report of Computer Shop Management System cust_paddress
cust_laddress
pr_barcode
cust_dob
cust_lname
pr_price
cust_phone
cust_fname
pr_manu_date
pr_comp_id
pr_name
cust_gender
pr_dlr_id
#pr_id
#cust_id
CUSTOMER
PRODUCT Purchase
emp_paddress
emp_dob Made By
emp_laddress
emp_phone
comp_state
emp_gender
emp_lname
comp_city
emp_fname
emp_et_id
comp_name
#emp_id
emp_email
#comp_id
EMPLOYEE Request
comp_location comp_reg_no comp_date comp_active
COMPANY
Manage By
Provide
dlr_city
Expense
exp_time
Takes
sal_com_amt sal_due_amt
dlr_dob dlr_paddress
exp_desc exp_amt
sal_amt
#exp_id
dlr_pincode
dlr_fname exp_date
exp_emp_id #sal_id
dlr_gender
dlr_lname
EXPENSE SALARY
dlr_mobile
dlr_laddress
sal_date
dlr_email
#dlr_id
DEALER
sal_emp_id
By
ER Diagram (22)
dlr_active
Project Report of Computer Shop Management System
DATABASE STRUCTURE •
Balance Table Key Primary key
•
Column Name InvoiceNo. Customername Customer address Customer phone no. Paidamount Totalamount Date
Data Type Alphanumeric Alphanumeric Alphanumeric Numeric Numeric Numeric Date
Width 5 25 6 6 8
Computer part Detail
Primary key
•
Data Type Alphanumeric Alphanumeric Alphanumeric Numeric Alphanumeric Numeric
Width 15 25 5 6 5 1
Column Name Customer_name Customer_Address Customer_Phone.no. Customer_Balance
Data Type Alphanumeric Alphanumeric Numeric Numeric
Width 25 30 10 8
Customer Key Primary key
•
Column Name Itemname Brandname Type Price Serialno. warranty
Computer system detail Key
Primary key
Column Name Systemname Brandname Categary Price Model no. (23)
Data Type Alphanumeric Alphanumeric Alphanumeric Numeric Alphanumeric
Width 15 25 5 6 5
Project Report of Computer Shop Management System warranty Ram Mother-board Monitor Processor Other description
Column Name Invoice no Customer_name Customer_Address Customer_phoneno. Problem Service_date Charge
Data Type Alphanumeric Alphanumeric Alphanumeric Numeric Alphanumeric Date Numeric
Width 5 25 30 10 25 8 10
6.Employee Table Key Primary key
Column Name Employee-id Employee_name Employee_address Employee_phoneno Email_id
Data Type Alphanumeric Alphanumeric Alphanumeric Numeric Alphanumeric
Width 12 15 45 10 20
7.Warranty Key Primary key
Column Name Invoice_no. Serial_no. Bill_no. New_Serial no Problem Service_date Delivery_date
(24)
Data Type Alphanumeric Alphanumeric Alphanumeric Alphanumeric Alphanumeric Date Date
Width 8 20 10 15 25 8 8
Project Report of Computer Shop Management System
SYSTEM REQUIREMENT AND SPECIFICATION The Software Requirements Specification is produced at the culmination of the analysis task. The function and performance allocated to software as part of system engineering are refined by establishing a complete information description, a detailed functional and behavioral description, an indication of performance requirements and design constraints, appropriate validation criteria, and other data pertinent to requirements. Introduction 1.1.
Purpose –
The main purpose, to make this software is to overcome of
problems of data base handling, maintain registers of Computers, companies, services and information about worker who works at the shop etc. 1.2.
Intended Audience – This SRS is meant for basically my final semester project report of BCA. Besides, it is obviously targeted for the managers of mentioned center, the client, to get and overall description and advantage of the proposed system over the existing manual system.
1.3.
Product Vision and Scope – The proposed system is being developed keeping in mind the requirements/need of the client to automate its existing system for record keeping, report generation and management level information system. Keeping in mind the needs, the system has been developed as per guidelines laid by the client’s center. The system is capable enough to handle Computer records, company records, customer records, price records, report generation, and storing other related information.
2. Overall Description
(25)
Project Report of Computer Shop Management System 2.1 Product Perspectives: The proposed system falls under RDBMS (Relational Data Base Management System) category. I have adopted JSP as front end for the software and MYSQL as back end. JSP is at present one of the most popular development platform for web based system that is efficient for web programming. MYSQL is at present the most reliable and secure RDBMS tool. MYSQL Server works to efficiently manage its resource, a database of information, among the multiple clients requesting and sending data in the network. MYSQL has many important features that make it not only an exceptional database management system but also an excellent database server choice for client/server database computing. So the overall system will prove to reliable, secure and efficient for the organization. 2.2.
Operating
Environment
–
The
proposed
software
is
to
run
on
client/server model network. A client/server can deliver the better performance than the file server system because a client application and database server work together to split processing load of applications (thus the term distributed processing). The server manages the database among the number of clients, while the client send, request, and analyse the data entry form with small specific data set, such as rows in a table not file as in the file server system. A database server is intelligent enough so that it lock and return only the rows a client request, which ensure concurrency, minimize the network traffic and increase the system performance. 2.3 Assumptions and Dependencies – While cost estimation of the proposed system it has been assumed that the cost hardware and for license of Operating System and back end will be met by client (the organisation). Hence only the cost incurred for the proposed software is included therein.
(26)
Project Report of Computer Shop Management System The followings are identified as some of the potential risk factors or dependencies: (1)
Non-availability of required resources.
(2)
Power cuts.
(3)
Slippage of schedule due to unpredictable holidays, etc.
2.4 Life Cycle Model – I am using SDLC model that begin at system level and progresses through analysis, design, coding, testing, implementation and maintenance. A process model for software engineering is chosen based on the nature of the project and application, the methods and tools to be used, and the controls and deliverables that are required. Here for the proposed project model of Automation of School Administration, we are using Linear Sequential model for Software engineering. This model suggests a systematic, sequential approach to software development that begins at the system level and progresses through analysis, design, coding, testing and maintenance.
The Linear sequential model encompasses the following activities:-2.4.1.
System engineering and modeling: This system view encompasses
requirements gathering at the system level with a small amount of top-level analysis and design. 2.4.2: Software requirement analysis: To understand the nature of the program(s) to be built, the software engineer must understand the information domain for the software as well as required function, behaviour, performance and interfacing. 2.4.3: Design: This process focuses on design of data structures, software architecture, interface representation and procedural detail. 2.4.4: Code generation: This step translates the design into a machine readable form.
(27)
Project Report of Computer Shop Management System 2.4.5: Testing: The testing process focuses on the logical internals of the software, assuring that all statements have been tested, and ensure that defined input will produce actual results that agree with required results. 2.4.6: Maintenance: Software will undoubtedly undergo changes after it is delivered to the customer. Software maintenance reapplies each of the programs rather than a new one. 3. External Interface Requirements 3.1 User Interfaces – It has been required that every form’s interface should be user friendly and simple to use. Besides, there should be facility of accessing the system through keyboard along with the mouse i.e. keyboard shortcuts. 3.2 Software Interfaces – It has been required that there could be a necessity of using the stored data for some kind of report that is not supported by proposed system at present. So the proposed system is required to export its data as text file so that some other application software can import the data. 4.
System Future Requirement – Other than descriptions provided above, the
following features were required by the client: (1)
The system should be secured enough to rely upon.
(2)
Users should not be allowed to delete/modify any records.
(3)
Users should not be allowed to take financial reports.
(4)
Every users report should keep the tracks of user inputting the record.
(5)
System should provide facility of exporting its data in text format.
(28)
Project Report of Computer Shop Management System (6)
System should be able to integrate with its Phase II developments.
1. Other Nonfunctional Requirements a. Performance Requirements – As it is going to be used by all the concerned employees within the organization, the system should have a good performance in terms of speed and accuracy. The proposed system should be accurate and fast enough to handle huge data. It should provide fast communication between server and clients. b. Safety Requirements – As the system is going to handle records for a long run eliminating the manual system, it is supposed to ensure the retaining of data avoiding or eliminating any probable cause for data loss. c. Security Requirements – The software should not allow unauthorized access to any module of the system. Besides, it should maintain the privileges granted to users at various user levels. d. Software Quality Attributes – The prioritization of the software quality attributes are assumed as under: (1)
Accurate and hence reliable.
(2)
Secured.
(3)
Fast speed.
(4)
Compatibility.
(5)
Portability.
(29)
Project Report of Computer Shop Management System
SOFTWARE REQUIREMENT Server: Software Operating System Database
Name Windows NT/2000 Server / Linux MYSQL
Web Server Language Drivers Engine Browser
Tomcat Server Java JDK and JRE MySQL JConnector JSP Engine Chrome, Internet Explorer, Mozilla etc
Client: Software Operating System
Name Windows NT/2000 Server / Linux
Browser
Chrome, Internet Explorer, Mozilla etc
Networking: Network connectivity to be ensured between Server and Clients.
(30)
Project Report of Computer Shop Management System
HARDWARE REQUIREMENT Administrator The hardware requirements for all the platforms are: Since the project is based on the jsp, so it can run all platforms and basic hardware requirements are: 1.
512 MB RAM
2.
4 GB HDD (normally)
3.
Pentium family processor
4.
1 Laser Printer
5.
Network Adapter Card And other related peripherals.
1. Client Hardware Requirements – 1 PC at least Pentium family, 512 MB RAM, 20 GB HDD, 1 Printer, Network Adapter Card and other related peripherals.
(31)
Project Report of Computer Shop Management System
System Design Screen Shots
(32)
Project Report of Computer Shop Management System
(33)
Project Report of Computer Shop Management System
(34)
Project Report of Computer Shop Management System
(35)
Project Report of Computer Shop Management System
(36)
Project Report of Computer Shop Management System
(37)
Project Report of Computer Shop Management System
(38)
Project Report of Computer Shop Management System
(39)
Project Report of Computer Shop Management System
(40)
Project Report of Computer Shop Management System
(41)
Project Report of Computer Shop Management System
(42)
Project Report of Computer Shop Management System
(43)
Project Report of Computer Shop Management System
(44)
Project Report of Computer Shop Management System
(45)
Project Report of Computer Shop Management System
(46)
Project Report of Computer Shop Management System
(47)
Project Report of Computer Shop Management System
(48)
Project Report of Computer Shop Management System
Coding Of the Project
(49)
Project Report of Computer Shop Management System Code for Connect.java package com; import java.sql.*; import java.util.*;
public class Connect { public static Statement statement = null; public static Connection connection; public static ResultSet rs; public static PreparedStatement pstmt; /////Function for connect to the MySQL Server Database//////////// public static void connect_mysql() { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); connection
Project Report of Computer Shop Management System { System.out.println(" Error : "+ e.toString()); } } ////////Function for geting the Option///////////////////// public
public class Employee extends Connect { /////Function for connect to the MySQL Server Database//////////// public Employee() { Connect.connect_mysql(); } //////////Save User Details ///// public String saveEmployee(HashMap employeeData) {
String SQL = "INSERT INTO employee (employee_user, employee_password, employee_level,
employee_sal,
employee_last_name, employee_state,
employee_first_name,
employee_gender,
employee_country,
employee_middle_name,
employee_address, employee_landline,
(53)
employee_village, employee_mobile,
Project Report of Computer Shop Management System employee_email,
/////Function for Getting the List//////////// public String getStateOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("state","state_id","state_name","state_id,state_name",selectedI D,"1"); }
/////Function for Getting the List////////////
(62)
Project Report of Computer Shop Management System public String getCountryOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("country","country_id","country_name","country_id,country_ name",selectedID,"1"); }
/////Function for Getting the List//////////// public String getSalutionOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("salutions","sl_id","sl_name","sl_id,sl_name",selectedID,"1"); }
/////Function for Getting the List//////////// public String getConnectionTypeOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("connection_type","cont_id","cont_name","cont_id,cont_name ",selectedID,"1");
(63)
Project Report of Computer Shop Management System }
/////Function for Getting the List//////////// public String getStatusOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("status","status_id","status_name","status_id,status_name",sel ectedID,"1"); }
/////Function for Getting the List//////////// public String getDepartmentOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("department","dept_id","dept_name","dept_id,dept_name",sel ectedID,"1"); }
////////////////Function for getting all the Airport Details//////////////////// public ArrayList getAllEmployee() {
(64)
Project Report of Computer Shop Management System int count=0; String error = "";
public class Login extends Connect { /////Function for connect to the MySQL Server Database//////////// public Login() { Connect.connect_mysql(); } //////////////////Function for Update the airport//////////////////////// public boolean changePassword(String old_password,String new_password, int login_id) { String SQL; int count = 0; try
(70)
Project Report of Computer Shop Management System { SQL = "SELECT * FROM login WHERE login_password = '"+old_password+"' AND login_id = "+login_id ; statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next())
count++;
if(count==1) { SQL = "UPDATE login SET login_password=? WHERE login_id=?"; int record=0; pstmt = connection.prepareStatement(SQL); pstmt.setString(1,new_password); pstmt.setInt(2,1); record = pstmt.executeUpdate(); pstmt.close(); connection.close(); } } catch(Exception e) { System.out.println(" Error : "+ e.toString()); } if(count==0)
(71)
Project Report of Computer Shop Management System return false; return true; } //////////////////Function for geting the Single Airport Details////////// public boolean checkLogin(String login_user,String login_password) { int count=0; try { String SQL = "SELECT * FROM login WHERE login_user = '"+login_user+"' AND login_password = '"+login_password+"'" ; statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next())
public class Products extends Connect { /////Function for connect to the MySQL Server Database//////////// public Products() { Connect.connect_mysql(); } //////////Save User Details ///// public String savePart(HashMap partData) { String SQL = "INSERT INTO parts (part_company_id, part_type, part_name, part_modal,
////////////////Function for getting all the Airport Details//////////////////// public ArrayList getAllPart() { String SQL = "SELECT * FROM parts"; int count=0;
(81)
Project Report of Computer Shop Management System ArrayList resultArray = new ArrayList(); try { statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next()) { HashMap results = new HashMap(); results.put("part_company_id",Integer.parseInt(rs.getString("part_company_id"))); results.put("part_type",rs.getString("part_type")); results.put("part_name",rs.getString("part_name")); results.put("part_modal",rs.getString("part_modal")); results.put("part_serial_number",rs.getString("part_serial_number")); results.put("part_price",rs.getString("part_price")); results.put("part_warranty",rs.getString("part_warranty")); results.put("part_ram",rs.getString("part_ram")); results.put("part_motherboard",rs.getString("part_motherboard")); results.put("part_monitor",rs.getString("part_monitor")); results.put("part_processor",rs.getString("part_processor")); results.put("part_description",rs.getString("part_description")); results.put("part_id",rs.getString("part_id"));
count++;
(82)
Project Report of Computer Shop Management System resultArray.add(results); } } catch(Exception e) { System.out.println("Error is: "+ e); } return resultArray; } /////Function for Getting the List//////////// public String getCompanyOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("company","company_id","company_name","company_id,co mpany_name",selectedID,"1"); }
}
(83)
Project Report of Computer Shop Management System Code for Salary.java package Model;
public class Salary extends Connect { /////Function for connect to the MySQL Server Database//////////// public Salary() { Connect.connect_mysql(); } //////////Save User Details ///// public String saveSalary(HashMap salaryData) { String SQL = "INSERT INTO salary (sal_employe_id, sal_month, sal_year, sal_amount) VALUES (?, ?, ?, ?);"; int record=0; String error = "";
(84)
Project Report of Computer Shop Management System try { pstmt = connection.prepareStatement(SQL); pstmt.setString(1,(String) salaryData.get("sal_employe_id")); pstmt.setString(2,(String) salaryData.get("sal_month")); pstmt.setString(3,(String) salaryData.get("sal_year")); pstmt.setString(4,(String) salaryData.get("sal_amount"));
Project Report of Computer Shop Management System public boolean delete_login(int airline_id) { return true; }
////////////////Function for getting all the Airport Details//////////////////// public ArrayList getAllSalary(String emp_id) { String SQL = "SELECT * FROM salary"; int count=0; ArrayList resultArray = new ArrayList(); try { if(!emp_id.equals("0")) { SQL = "SELECT * FROM salary WHERE sal_employe_id = "+emp_id; } statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next()) { HashMap results = new HashMap(); results.put("sal_id",rs.getString("sal_id"));
(90)
Project Report of Computer Shop Management System results.put("sal_employe_id",Integer.parseInt(rs.getString("sal_employe_id"))); results.put("sal_year",rs.getString("sal_year")); results.put("sal_month",Integer.parseInt(rs.getString("sal_month"))); results.put("sal_amount",rs.getString("sal_amount"));
count++; resultArray.add(results); } } catch(Exception e) { System.out.println("Error is: "+ e); } return resultArray; } /////Function for Getting the List//////////// public String getMonthOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("month","month_id","month_name","month_id,month_name", selectedID,"1"); }
(91)
Project Report of Computer Shop Management System /////Function for Getting the List//////////// public String getEmployeeOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("employee","employee_id","employee_id","employee_id,empl oyee_id",selectedID,"1"); } }
(92)
Project Report of Computer Shop Management System Code for Salary.java package Model;
public class Salary extends Connect { /////Function for connect to the MySQL Server Database//////////// public Salary() { Connect.connect_mysql(); } //////////Save User Details ///// public String saveSalary(HashMap salaryData) { String SQL = "INSERT INTO salary (sal_employe_id, sal_month, sal_year, sal_amount) VALUES (?, ?, ?, ?);"; int record=0; String error = "";
(93)
Project Report of Computer Shop Management System try { pstmt = connection.prepareStatement(SQL); pstmt.setString(1,(String) salaryData.get("sal_employe_id")); pstmt.setString(2,(String) salaryData.get("sal_month")); pstmt.setString(3,(String) salaryData.get("sal_year")); pstmt.setString(4,(String) salaryData.get("sal_amount"));
Project Report of Computer Shop Management System public boolean delete_login(int airline_id) { return true; }
////////////////Function for getting all the Airport Details//////////////////// public ArrayList getAllSalary(String emp_id) { String SQL = "SELECT * FROM salary"; int count=0; ArrayList resultArray = new ArrayList(); try { if(!emp_id.equals("0")) { SQL = "SELECT * FROM salary WHERE sal_employe_id = "+emp_id; } statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next()) { HashMap results = new HashMap(); results.put("sal_id",rs.getString("sal_id"));
(99)
Project Report of Computer Shop Management System results.put("sal_employe_id",Integer.parseInt(rs.getString("sal_employe_id"))); results.put("sal_year",rs.getString("sal_year")); results.put("sal_month",Integer.parseInt(rs.getString("sal_month"))); results.put("sal_amount",rs.getString("sal_amount"));
count++; resultArray.add(results); } } catch(Exception e) { System.out.println("Error is: "+ e); } return resultArray; } /////Function for Getting the List//////////// public String getMonthOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("month","month_id","month_name","month_id,month_name", selectedID,"1"); }
(100)
Project Report of Computer Shop Management System /////Function for Getting the List//////////// public String getEmployeeOption(Integer SelID) { int selectedID = SelID.intValue(); return Connect.getOptionList("employee","employee_id","employee_id","employee_id,empl oyee_id",selectedID,"1"); } }
public class Waranty extends Connect { /////Function for connect to the MySQL Server Database//////////// public Waranty() { Connect.connect_mysql(); } //////////Save User Details ///// public String saveWaranty(HashMap warantyData) { String SQL = "INSERT INTO waranty (waranty_Invoice_no, waranty_Serial_no, waranty_Bill_no, waranty_New_Serial_no, waranty_Problem, waranty_Service_date, waranty_Delivery_date) VALUES (?, ?, ?, ?, ?, ?, ?);"; int record=0; String error = "";
Project Report of Computer Shop Management System catch(Exception e) { StringWriter writer = new StringWriter(); PrintWriter printWriter = new PrintWriter( writer ); e.printStackTrace( printWriter ); printWriter.flush(); String stackTrace = writer.toString(); error+="Error : "+stackTrace; System.out.println(" Error : "+ e.toString()); } return error; } ////////////////Function for getting all the Airport Details//////////////////// public ArrayList getAllWaranty() { String SQL = "SELECT * FROM waranty"; int count=0; ArrayList resultArray = new ArrayList(); try { statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next())
(114)
Project Report of Computer Shop Management System { HashMap results = new HashMap(); results.put("waranty_id",rs.getString("waranty_id")); results.put("waranty_Invoice_no",rs.getString("waranty_Invoice_no")); results.put("waranty_Serial_no",rs.getString("waranty_Serial_no")); results.put("waranty_Bill_no",rs.getString("waranty_Bill_no")); results.put("waranty_New_Serial_no",rs.getString("waranty_New_Serial_no")); results.put("waranty_Problem",rs.getString("waranty_Problem")); results.put("waranty_Service_date",rs.getString("waranty_Service_date")); results.put("waranty_Delivery_date",rs.getString("waranty_Delivery_date")); count++; resultArray.add(results); } } catch(Exception e) { System.out.println("Error is: "+ e); } return resultArray; } }
(115)
Project Report of Computer Shop Management System
PROJECT SCHEDULING AND COST ESTIMATION Scheduling An elementary Gantt chart or Timeline chart for the development plan is given below. The plan explains the tasks versus the time (in weeks) they will take to complete.
Cost Estimation Software cost comprises a small percentage of overall computer-based system cost. There are a number of factors, which are considered, that can affect the ultimate cost of the software such as - human, technical, Hardware and Software availability etc. The main point that was considered during the cost estimation of project was its sizing. In spite of complete software sizing, function point and approximate lines of code were also used to "size" each element of the Software and their costing. The cost estimation done by me for Project also depend upon the baseline metrics collected from past projects and these were used in conjunction with estimation variables to develop cost and effort projections. We have basically estimated this project mainly on two bases 1) Effort Estimation - This refers to the total man-hours required for the development of the project. It even includes the time required for doing documentation and user manual. 2) Hardware Required Estimation - This includes the cost of the PCs and the hardware cost required for development of this project.
(117)
Project Report of Computer Shop Management System 1. EFFORT ESTIMATION
Project Activities
Person Days
System Requirement Analysis and its Feasibility study
15
System Study
10
Preparation of the High Level Design of the system
Preparation of Low Level design – 6 Procedural Design
3
Database Design
12
Designing Of Input/Output screens
Coding – Front End Coding 32
Back End Coding
10
Preparation of test cases and Test data (118)
8
Project Report of Computer Shop Management System
Unit Testing
14
Integration Testing
15 Acceptance Testing
8
Documentation
133
Total Person days
1064
Total Person hours Person Cost (@40/- Per Hour Person Cost)
Rs 12,560.00
Guide Cost
Rs 2,500.00
Total Cost
Rs 15,060.00
2. HARDWARE REQUIREMENT ESTIMATION System Configuration required for Server: One PC (Pentium IV) with 128 MB RAM and 40 GB Hard Disk and Network Adapter Card for full installation of Windows 2000 Server and MYSQL along with this software installed on it. (Estimated cost approximately Rest 20,000.00) System Configuration required for Clients: (119)
Project Report of Computer Shop Management System Three PCs (Pentium III) with 64 MB RAM and 20 GB Hard Disk and Ethernet cards for installation of Windows 98 se and MYSQL client along with this software instilled on it. (Estimated cost approximately Rs 30,000.00 x 3 = Rs 50,000.00) Therefore
the
total
approximate
Hardware/Software
Cost
will
be
Rs 65,060.00 (NOTE: In this case, since the Center was already having licensed versions of Windows 2000 server and MYSQL Server/Client therefore their cost is not included in report). Thus, the cost estimation done for This project mainly focused on the Hardware, Software and the human resource cost.
(120)
Project Report of Computer Shop Management System
(JSP) A BRIEF NOTE ABOUT FRONT END Java Server Pages: Java Server Pages (JSP) is a technology for controlling the content or appearance of Web pages through the use of servlets, small programs that are specified in the Web page and run on the Web server to modify the Web page before it is sent to the user who requested it. Sun Microsystems, the developer of Java, also refers to the JSP technology as the Servlet application program interface (API). JSP is comparable to Microsoft's Active Server Pages (ASP) technology. Whereas a Java Server Pages calls a Java program that is executed by the Web server, an Active Server Pages contains a script that is interpreted by a script interpreter (such as VB Script or Java Script) before the page is sent to the user. An HTML page that contains a link to a Java servlet is sometimes given the file name suffix of JSP.
(121)
Project Report of Computer Shop Management System What are the Advantages of JSP? vs. Active Server Pages (ASP) ASP is a similar technology from Microsoft. The advantages of JSP are twofold. First, the dynamic part is written in Java, not Visual Basic or other MS-specific language, so it is more powerful and easier to use. Second, it is portable to other operating systems and non-Microsoft Web servers. vs. Pure Servlets. JSP doesn't give you anything that you couldn't in principle do with a servlet. But it is more convenient to write (and to modify!) regular HTML than to have a zillion println statements that generate the HTML. Plus, by separating the look from the content you can put different people on different tasks: your Web page design experts can build the HTML, leaving places for your servlet programmers to insert the dynamic content. vs. Server-Side Includes (SSI). SSI is a widely-supported technology for including externally-defined pieces into a static Web page. JSP is better because it lets you use servlets instead of a separate program to generate that dynamic part. Besides, SSI is really only intended for simple inclusions, not for "real" programs that use form data, make database connections, and the like. vs. JavaScript. JavaScript can generate HTML dynamically on the client. This is a useful capability, but only handles situations where the dynamic information is based on the client's environment. With the exception of cookies, HTTP and form submission data is not available to JavaScript. And, since it runs on the client, JavaScript can't access serverside resources like databases, catalogs, pricing information, and the like.
(122)
Project Report of Computer Shop Management System vs. Static HTML. Regular HTML, of course, cannot contain dynamic information. JSP is so easy and convenient that it is quite feasible to augment HTML pages that only benefit marginally by the insertion of small amounts of dynamic data. Previously, the cost of using dynamic data would preclude its use in all but the most valuable instances.
(123)
Project Report of Computer Shop Management System
(MYSQL) A BRIEF NOTE ABOUT BACK END MySQL: MySQL is a relational database system that is used to store information. MySQL can store many types of data from something as tiny as a single character to as large as complete files or graphics. Although it can be accessed by most programming languages, it is often coupled with PHP because they work together with ease. Information stored in a MySQL database hosted on a web server can be accessed from anywhere in the world with a computer. This makes it a good way to store information that needs the ability to change over time, but also needs to be accessed over the net. Some examples that can utilize MySQL are a web message board or a customer's shipping status. MySQL is a database system used on the web. Basically, a MySQL database allows to create a relational database structure on a web-server somewhere in order to store data or automate procedures. If we think of it in comparison to Microsoft Access, MySQL is what holds all of our tables, JSP acts as our queries (among other things), and our forms are basically web pages with fields in them. With all of this combined, we can create truly spectacular projects on the web. MySQL is also open source in that it’s free and falls under the GNU General Public License (GPL). Chances are, if we are getting our own web-page or already have one – our host supports MySQL and JSP. They are generally associated with (though not limited to) Unix/Linux based servers. If by chance we are considering getting our own page and want MySQL and JSP support, check out Dreamhost – I’ve been using them for years and they absolutely can’t be beat. Interacting with a MySQL database is a little weird as you don’t have the tried and true WYSIWYG interface that something as easy as Microsoft Access affords. When creating tables, you’ll either have to create them by using SQL Statements, or by using another open-source tool available online called PHPMyAdmin. PHPMyAdmin gives (124)
Project Report of Computer Shop Management System you an easy-to-use interface that allows you to create tables and run queries by filling in a little bit of information and then having the tables created for you. This is good if you’re either lazy, or don’t feel like bothering with big and complicated SQL Statements. In comparing MySQL to Access you’re going to have a truckload of differences. While MySQL isn’t exactly tough to tackle (once the tables are created – you’re pretty much done with it), it’s capabilities extend far beyond that of Microsoft Access when dealing with speed and reliability. It’s simply a better system – and it should be. Microsoft Access (as much as I love it) is only a desktop database system. And while a limit of 10-20 concurrent Microsoft Access users is fine for most small organizations – when we’ve got a webpage getting 10,000 hits a day you’ll need something that can handle all of those queries efficiently. MySQL tables also have the luxury of using “real” data types – not those little fluffy ones you see in Microsoft Access. Need a text field that can hold over four billion characters? Not a problem, just use the LongText data type. Want the field to hold that many characters and be case-sensitive? Easy, just use the LongBlob data type. Need to store numbers from 0 to 18,446,744,073,709,551,615 (for those of you who are curious, that would be over 18 Quintillion), then use the BigInt data type. Indeed, 18 quintillion is a big integer. As you can see, the limitations of Access fall well within the capabilities of MySQL. This is one of the many reasons that huge webpages use MySQL to handle their millions of daily hits. Well, that, and it’s free!
(125)
Project Report of Computer Shop Management System
IMPLEMENTATION AND TESTING Detailed Design of Implementation: This phase of the systems development life cycle refines hardware and software specifications, establishes programming plans, trains users and implements extensive testing procedures, to evaluate design and operating specifications and/or provide the basis for further modification. Technical Design: This activity builds upon specifications produced during new system design, adding detailed technical specifications and documentation. Test Specifications and Planning – This activity prepares detailed test specifications for individual modules and programs, job streams, subsystems, and for the system as a whole. Programming and Testing – This activity encompasses actual development, writing, and testing of program units or modules. User Training – This activity encompasses writing user procedure manuals, preparation of user training materials, conducting training programs, and testing procedures. Acceptance Test – A final procedural review to demonstrate a system and secure user approval before a system becomes operational. Installation Phase – In this phase the new Computerized system is installed, the conversion to new procedures is fully implemented, and the potential of the new system is explored. (126)
Project Report of Computer Shop Management System System Installation: The process of starting the actual use of a system and training user personnel in its operation. Review Phase – This phase evaluates the successes and failures during a systems development project, and to measure the results of a new Computerized Transystem in terms of benefits and savings projected at the start of the project. Development Recap – A review of a project immediately after completion to find successes and potential problems in future work. Post-Implementation Review – A review, conducted after a new system has been in operation for some time, to evaluate actual system performance against original expectations and projections for cost-benefit improvements. Also identifies maintenance projects to enhance or improve the system.
(127)
Project Report of Computer Shop Management System Input to the Project In this project fallowing types of input are given which is as fallows … I. It stores the supplier information. II. It stores the purchase detail. III. It store information of available hardware detail. IV. It store information of available hardware V. It store the bill record of customers VI. It store details of employee VII. It store details of employee salary VIII. It store the details information of stock
(128)
Project Report of Computer Shop Management System Output to the Project In this project fallowing types of output are given which is as fallows … I. It prints the supplier information. II. It prints the purchase detail. III. It prints information of available hardware detail. IV. It prints information of available hardware V. It prints the bill record of customers VI. It prints details of employee VII. It prints details of employee salary VIII. It prints the details information of stock
(129)
Project Report of Computer Shop Management System
PROCESS LOGIC OF THE MODULES Login process can be performed in following manner: User Activates the software package Login Form pops up User makes the required entries and submits The submitted data is tested by VALIDATION module. If(all correct entries )returned ( ( Open the Login table in database Check for username and password If (found )returned ( ( Current form is closed Main Menu form is displayed as by default is the next step I the software Else-Otherwise Error message for in correct entry is displayed The software prompts for new user name entry ) ) else-otherwise Error message for is displayed for incomplete submission of form (130)
Project Report of Computer Shop Management System Software prompts for re submission of data ) ) Creation of New Login process can be performed in following manner: User goes the new login option New Login Form pops up User makes the required entries and submits The submitted data is tested by VALIDATION module. If(all correct entries )returned ( ( Open the Login table in database Enter new username and password Login database is updated else-otherwise Error message for is displayed for incomplete submission of form Software prompts for re submission of data ) ) Editing of Login process can be performed in following manner: After User makes proper login Login edit form is requested User makes the required entries and submits The submitted data is tested by VALIDATION module. If(all correct entries )returned (131)
Project Report of Computer Shop Management System ( ( Package moves forward with the software Displays a message of Login edited.
else-otherwise
Error message for is displayed for incomplete submission of form Software prompts for re submission of data )
)
(132)
Project Report of Computer Shop Management System
Modules of the Project 1. Login Form In this form, existing user/administrator enters the user-name and password and access the main form. If user forgets his password then he can click on button forget password and then entering his e-mail id can get user name and password. This form contains user name and password as sub module. 2. Main Form If administrator accesses this form using authentic login-name and password then the administrator has administrative power as add the product, create user account, add new branded computer system, add company, change the shop record . Administrator have full power But user have some restricted power only which is provided by administrator. In this main form user can sell computer part/assemble computer system/branded computer system, update customer record, change the password, make quotation. Using this form the user/administrator can see the report of sold computer part, branded computer system in any time duration. In this form, there is option to exit & log-off 3. Sell Computer System Module There are two sub modules: 1) Sell branded computer system 2) Sell assembled computer system/computer part In sell branded computer system module, user/administrator can sell available branded computer system. In this form, the user/administrator enters the customer name, address & phone number and chooses any branded computer system to sell. This form also so the all information of chosen branded computer system as category, model number, monitor type, hard-
(133)
Project Report of Computer Shop Management System disk range, ram, processor, price etc. After selling, the user/administrator can print and save the receipt. In sell assembled computer system/computer part module, user/administrator can sell available computer part and assembled computer system. In this form, the user/administrator enters the customer name, address & phone number and chooses all computer part to sell according to request of customer. The user/administrator can chose any product, its type, range, its serial number using combo-box. After choosing the serial number of product the price of the product and total price (including vat, tax) automatically generate. After selling, the user/administrator can print and save the receipt. The invoice number and customer number automatically generate by this software when this form is loaded. 4. Update Customer Balance Module In this module, there is information related to balance of customer, customer name and address. In future if any customer paid the balance amount then it can be update. 5. Make Quotation Module In this module, the user/administrator makes quotation according to request of the customer. This quotation provide information about the price, range, type & company name of all product to customer before purchasing the computer parts/assembled computer system. This quotation also provides total price (including vat) assembled computer system. 6. Change Password Module In this module, the user/administrator can change his/her password by entering login-name and old password and new password. So this provide security from unauthorized access. 7. Create user account Module (134)
Project Report of Computer Shop Management System In this module, the administrator can create new user by providing him loginname and password. In this module, the administrator can update user information as name, address and phone number of exiting user. He can delete exiting user account. The administrator can see the entire exiting user. The administrator can also give administrator power to any user. In this module, there is information related to the entire user working in the computer-shop as name, address, e-mail id, phone number etc. Here admin can take information related to user. 8. Add Product Module In this module, the administrator can add new product by entering its name, company name, range, type, serial number, and its price. Here administrator can also see the available product and its information. And the administrator can also delete any product. 9. Add computer system Module In this module, the administrator can add new branded computer system by entering its category, model number, company name, ram capacity and its speed, monitor type, Hard-disk capacity and its interface, processor clock speed and its L2cach, motherboard company-name and its chipset, its selling and buying price and other description. Here administrator can also see the available computer system and its information. And the administrator can also delete any computer system. 10. Add company Module In this module, the administrator can add any company information whose product are available at the computer shop. This module contains the name of company, contact person, address, phone number, website, and fax number. 11. Change Shop information Module (135)
Project Report of Computer Shop Management System In this module, the administrator save/update the information related to his computer-shop as name of computer-shop, address, phone-number, and registration number. 12. Product Price Report: This report shows the price of all available products and its detail as item-name, company-name, type, range, and serial-number. 13. Sold computer part Report: This report show the sold computer part in any time duration. The administrator/user can see the detail of sold computer part in specified time duration. This report show the name of customer, item-name, companyname, type, range, serial-number, and price of sold product. 14. Sold computer system Report: This report shows the sold computer system in any time duration. The administrator/user can see the detail of sold computer system in specified time duration. This report shows the name of customer, category, company-name, model-number, ram capacity and its speed, monitor type, Hard-disk capacity and its interface, processor clock speed and its L2cach, motherboard company-name and its chipset, description
(136)
its
price and other
Project Report of Computer Shop Management System
TESTING OF THE SOFTWARE Testing is the process in which the system is run on manually created input so that the system is correctly working as desired or not. During systems testing, the system is used experimentally to ensure that the software does not fail. In other words, we can say that it will run according to its specifications and in the way users expect. Special test data are input for processing, and the results examined. A limited number of users may be allowed to use the system so that analyst can see whether they try to use it in unforeseen ways. It is desirable to discover any surprises before the organization implements the system and depends on it. Testing of a system is generally done in two phases – One is Unit Testing which is done for each module independently on its completion and the other one is System Testing which is done at the end of a project. IMPORTANCE OF TESTING During systems testing, the system is used experimentally to ensure that the software does not fail. In other words, we can say that it will run according to its specifications and in the way users expect. Special test data are input for processing, and the results examined. The importance of system testing is that the system is expected to run according to customer’s requirement before delivering it to the customer. The System is tested on the basis of specification so that it does not fail on user site.
(137)
Project Report of Computer Shop Management System THE STEPS IN THE SOFTWARE TESTING The steps involved during Unit testing are as follows: a) Preparation of the test cases. b) Preparation of the possible test data with all the validation checks. c) Complete code review of the module. d) Actual testing done manually. e) Modifications done for the errors found during testing. f) Prepared the test result scripts. The unit testing done included the testing of the following items: 1) Functionality of the entire module/forms. 2) Validations for user input. 3) Checking of the Coding standards to be maintained during coding. 4) Testing the module with all the possible test data. 5) Testing of the functionality involving all type of calculations etc. 6) Commenting standard in the source files. After completing the Unit testing of all the modules, the whole system is integrated with all its dependencies in that module. While System Integration, We integrated the modules one by one and tested the system at each step. This helped in reduction of errors at the time of the system testing. The steps involved during System testing are as follows: a) Integration of all the modules/forms in the system. b) Preparation of the test cases. c) Preparation of the possible test data with all the validation checks. d) Actual testing done manually. e) Recording of all the reproduced errors. f) Modifications done for the errors found during testing. g) Prepared the test result scripts after rectification of the errors. (138)
Project Report of Computer Shop Management System The System Testing done included the testing of the following items: 1) Functionality of the entire system as a whole. 2) User Interface of the system. 3) Testing the dependent modules together with all the possible test data scripts. 4) Verification and Validation testing. 5) Testing the reports with all its functionality.
(139)
Project Report of Computer Shop Management System After the completion of system testing, the next following phase was the Acceptance Testing. Clients at their end did this and accepted the system with appreciation. Thus, we reached the final phase of the project delivery. There are other six tests, which fall under special category. They are described below:
i.
Peak Load Test: It determines whether the system will handle the volume of activities that occur when the system is at the peak of its processing demand. For example, test the system by activating all terminals at the same time.
ii.
Storage Testing: It determines the capacity of the system to store transaction data on a disk or in other files.
iii.
Performance Time Testing: it determines the length of time system used by the system to process transaction data. This test is conducted prior to implementation to determine how long it takes to get a response to an inquiry, make a backup copy of a file, or send a transmission and get a response.
iv.
Recovery Testing: This testing determines the ability of user to recover data or re-start system after failure. For example, load backup copy of data and resume processing without data or integrity loss.
v.
Procedure Testing: It determines the clarity of documentation on operation and uses of system by having users do exactly what manuals request. For example, powering down system at the end of week or responding to paper-out light on printer.
vi.
Human Factors Testing: It determines how users will use the system when processing data or preparing reports.
(140)
Project Report of Computer Shop Management System
Report Generation In this software there is fallowing types of report is generated:1. This software generates the report of incoming hardware 2. This software generates the report of bill 3. This software generates the report of sale hardware information 4. This software generates the report of supplier 5. This software generates the reports of all it employee 6. This software generates the report of stock information 7. This software generates the report of company 8. This software generates the report of product.
(141)
Project Report of Computer Shop Management System
Limitation of the Project Although I have put my best efforts to make the software flexible, easy to operate but limitations cannot be ruled out even by me. Though the software presents a broad range of options to its users some intricate options could not be covered into it; partly because of logistic and partly due to lack of sophistication. Paucity of time was also major constraint, thus it was not possible to make the software foolproof and dynamic. Lack of time also compelled me to ignore some part such as storing old result of the candidate etc. Considerable efforts have made the software easy to operate even for the people not related to the field of computers but it is acknowledged that a layman may find it a bit problematic at the first instance. The user is provided help at each step for his convenience in working with the software.
(142)
Project Report of Computer Shop Management System
Future Scope of the Project In a nutshell, it can be summarized that the future scope of the project circles around maintaining information regarding: In future the project can be extended to maintain the accounting in shop. The future version can also combine the facility to handle staff detail and salary detail. The future version can run on network too. The above mentioned points are the enhancements which can be done to increase the applicability and usage of this project.
(143)
Project Report of Computer Shop Management System
Conclusion In the end We wish to say that computers should be put to such use where not only their capabilities are fully exploited but, what is more important, serve the society by raising the standard of living of people, thereby making the world better place to live and work in. At the end it is concluded that we have made effort on following points… 1. A description of the background and context of the project and its relation to work already done in the area. 2. Made statement of the aims and objectives of the project. 3. The description of Purpose, Scope, and applicability. 4. We define the problem on which we are working in the project. 5. We describe the requirement Specifications of the system and the actions that can be done on these things. 6. We understand the problem domain and produce a model of the system, which describes operations that can be performed on the system. 7. We included features and operations in detail, including screen layouts. 8. We designed user interface and security issues related to system. 9. Finally the system is implemented and tested according to test cases.
(144)
Project Report of Computer Shop Management System
Bibliography The books referred during the development of this project are as follows: JSP: The Complete Reference, by Phil Hanna (Osborne) Making use of JSP,by Madhushree Ganguli The definitive guide to MySQL, byMichael Kofler, David Kramer MySQL: the complete reference, by Vikram Vaswani Software Engineering from IGNOU block Database Management System from IGNOU block Software Engineering by Roger Pressman www.Google .com www.java.sun.com www.mysql.com
