06-10-2016, 12:25 PM
1458020565-HARDWAREMMN2.docx (Size: 1.47 MB / Downloads: 4)
In the present day world most of the job are done mechanically and it is very much clear that carrying out sort of business or commercial transactions manually would be an utter waste of time and resources .Today computer are used not only for the book keeping purpose but also it changed the way work is being done by automating the entire operation.
At present storing and retrieving are done in a manual way .This means that it is difficult to maintain proper data. The project entitled “HARDWARE SHOP MANAGEMENT SYSTEM”. This shop manages with the Purchase & Sales of hardwaes. HARDWARE shop management system deals with the common operation of a HARDWARE shop.
The existing system is manually operated. The main drawback of the existing system is it take a lot of time to record the various data and keeping is also very difficult to create report on basis of various conditions and also the searching is difficult because of the medium storage like files. So it takes a lot of manual effort and time. To overcome these drawbacks we implement the proposed system.
Facilities for generating reports for the efficient management of the Hardware shop are also provided in the system. Hardware shop management system has developed in Microsoft VB 6.0 environment (front end) and use Microsoft SQL 2000(back end) for database. The Hardware shop management system overcomes all the drawback of the manual system. It performs efficiently for the better performance of the organization.
Since the automation is preferred to manual labour,automating of an existing system will certainly lead to a better-integrated working environment, efficient handling of data and meaningful interaction with the information.It helps us to reduce the cost for the day-to-day operations and it save our time.
STUDY OF EXISTING SYSTEM
In order to elicit the requirement and to identify the elements, inputs, outputs, subsystems and the procedures the existing had to be examined and analyzed in detail. This constituted the system study. Records slips, procedures, rules etc were examined thoroughly. This existing system was studied involving a complete co-operation from the employees who run the system at present.
PROBLEMS WITH THE EXISTING SYSTEM
Reports could not be prepared in time.
• Calculations were sometimes found incorrect, that caused accumulating problems.
• Use and maintains of paper files, registers, and other written matter was very difficult.
• Security of information is time consuming
• More man power required.
• Data verification and validation was manual.
The existing system is manually operated. The main drawback of the existing system is it take a lot of time to record the various data and keeping is also very difficult procedure because it take a large number of space to store details and difficult to create reports on basis of various conditions and also the searching is difficult because of the medium storage like files. So it takes a lot of manual effort and time. To overcome these drawbacks we implement the proposed system.
In order to overcome this disadvantages the manual system was decided to be automated with pursue with a front end user interface, which has a variety of choices to the front end administrator.
STUDY OF PROPOSED SYSTEM
Proposed system is fully computerized one. As all the entire working is done with the aid of computers, this will result in faster processing and improved performance. This information can be retrieved very quickly by the click of a button when compared to earlier retrieval from files and registers. The corresponding details of models, option types, sale, and purchase are also stored in database for future reference. As all the details are stored in the computer’s hard drive the physical storage space requirement can be reduced to a great extent.
Processing of information manipulation was difficult with manual system, but as we are doing all the processing with the aid of computers it can be done very easily and accurately. Creating reports timely needs a quick search in the huge file cabinets, but with the proposed system reports can be generated in the winks of an eye lid. This computer system increases the efficiency of the Hardware shop management system and improves the performance.
The disadvantages of existing system have been solved by automating the HARDWARE SHOP MANAGEMENT SYSTEM which helps to all the process of the Organization especially to know the details of customers. Creating reports timely needs a quick search in the huge file cabinets. This computer facility increases the efficiency and improves the performance. The use of the paper file is avoided and all the data are efficiently manipulated by the system. The ne system facilitates more report to know the status and which is difficult in the existing system we can reduce error which is occurred manually and also it is easy to use this proposed system.
ADVANTAGE OF THE PROPOSED SYSTEM
• It take the less number of time compared to the existing system
• It takes less space to store the data.
• It is very easy to search and take reports.
• It is more efficient.
• It is more reliable.
• It is easy to work.
FEATURES OF PROPOSED SYSTEM
• User friendly environment
• Reliable data-entry
• Atomized processing
• Single-click Result analysis
• High Security
• Generate reports daily and monthly
SYSTEM SPECIFICATION
HARDWARE SPECIFICATION
Processor : Pentium iv or Higher
Memory : 512MB RAM
Hard disk : 40 GB or Higher
Keyboard : Standard
Mouse : Standard
Monitor : SVGA Color
SOFTWARE SPECIFICATION
Operating System : Windows 7 onwards
Front End Tool : Microsoft VB 6.0
Back End Tool : Microsoft SQL Server 2000
SOFTWARE FEATURES
OVERVIEW OF WINDOWS 7
The new features available in Windows 7 are new security tools that user can as help to keep computer more secure, and new technologies that run in the background, making computer more efficiently and reliably.Windows XP has improved upon security, including the new security center, which allows user to check the status of the important security elements on the user’s computer. Windows Firewall, Automatic Updates and Virus Protection Software’s making it easier to understand how to keep the computer better protected against viruses and other security threats. Windows 7 is always dependable and stable, so user can always rely on the performance and effectiveness of the system.
WINDOWS 7 MARKING FEATURES
Desktop : Windows 7 screen and background support new color and
graphics.
Dialog Box : Windows contains text and one or more screen controls that
use to issue instructions to Windows 7. Hot key : The combination of an ALT key press combined with
another key that selects command.
Buttons : The key you press with ALT is displayed with as
underlined letter.
Icons : Small pictures that represent commands and programs in Windows 7.
Kernel : The internal native operating system that console the hardware and software interaction.
OVERVIEW OF MICROSOFT VISUAL BASIC 6.0
VB 1.0 was introduced in 1991. The drag and drop design for creating the user interface is derived from a prototype from generator developed by Alan Cooper and his company called Tripod. Microsoft contracted with Cooper and his associates to develop Tripod into a programmable form system for Windows 3.0, under the code name Ruby (no relation to Ruby programming language).
Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to database using Data Access Objects, Remote Data Objects, or ActiveX Data Objects, and creation of ActiveX controls and objects. Scripting languages such as
VBA and VBScript are syntactically similar to Visual Basic, but perform differently. A programmer can put together an application using the components provided with Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations.
The final release was version 6 in 1998. Microsoft’s extended support ended in March 2008 and the designated successor was Visual Basic .NET (now known as simply as Visual Basic). Microsoft Visual basic 6.0 is a language rapid application development environment that gives you fast, easy, and intuitive tools to quickly develop Windows applications. Using Visual Basic, you can develop simple utilities or sophisticated applications. Data access features allow you to create databases, front-end applications, and scalable server-side components for most popular database formats. ActiveX technologies allow you to use the functionality provided by other applications,
and even automate applications and objects created using the Professional or Enterprise editions of visual basic. Internet capabilities make it easy to
provide access to documents and applications across the Internet or intranet from within your application, or to create Internet Server applications.
Visual Basic 6.0 (Mid 1998) improved in a number of areas including the ability to create web-based applications. VB6 has entered Microsoft’s “non-supported phase” as of March. Although the Visual Basic 6.0 development environment is no longer supported, the runtime is supported on Windows Vista, Windows Server 2008 and Windows 7. Mainstream support for Microsoft visual Basic 6.0 ended on March 31, 2005. Extended support ended in March 2008. In response, the Visual Basic user community expressed its grave concern and lobbied users to sign a petition to keep the product alive. Microsoft has so far refused to change their position on the matter. Ironically, around this time 920050, it was exposed that Microsoft’s new anti-spyware offering, - Microsoft antispyware (part of the GIANT Software purchase), was coded in Visual Basic 6.0. Its replacement, Windows Defender, was rewritten as C++ code.
Visual Basic (VB) is the third-generation event-driven programming language and Integrated Development Environment (IDE) from Microsoft for its COM programming model. VB is also considered a relatively easy to learn and use programming language, because of its graphical development features and BASIC heritage.
Visual Basic was derived from BASIC and enables the Rapid Application Development (RAD) of Graphical User Interface (GUI) application, access to database using Data Access Objects, Remote Data Object, or ActiveX Data Object, and creation of ActiveX data control and object. Scripting languages
such as VBA and VBScript are syntactically similar to Visual Basic, but perform differently.
A programmer can put together an application using the components provided with Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations.
The final release was version 6 in 1998. Microsoft’s extended support ended in March 2008 and the designated successor was Visual Basic.NET (now known simply as Visual Basic).
Like the BASIC programming languages, Visual Basic was designed to be easily learned and used by beginner programmers. The language not only allows programmers to create simple GUI application, but can also develop complex application. Programming in VB is a combination of visually arranging components or control on a form, specifying attributes and actions of those components, and writing additional lines of code for more functionality. Since default attributes and actions are defined for the components, a simple program can be created without the programmer having to write many lines of code. Performance problems were experienced by earlier versions, but with faster computers and native code compilation this has become less of issues.
Although programs can be complied into native code executables from version 5 onwards, they still require the presence of runtime libraries of approximately 1MB in size. This runtime is included by default in Windows 2000 and later, but for earlier versions of Windows like 95/98/NT it must be distributed together with the executable.
Forms are created using drag-and-drop techniques. A tool is used to place controls (eg: text boxes, buttons, etc.) on the form (window). Controls have attributes and even handlers associated with them. Default values are provided
when the control is created, but may be changed by the programmer. Many attribute values can be modified during runtime based on user action or changes in the environment, providing a dynamic application. For example, code can be inserted in to the form resize event handler to reposition a control so that it remains centered on the form="TA4"manrF9="0ob w: w: cal="24"/>
Visual Basic (VB) is the third-generation event-driven programming language and integrated development (IDE) from Microsoft for its COM programming
model. VB is also considered a relatively easy to learn and use programming language, because of its graphical development features and BASIC heritage.
Like the basic programming language, Visual Basic was designed to be easily learned and used by beginner programmers. The language not only allows programmers to create simple GUI applications, but can also develop complex applications. Programming in VB is a combination of visually arranging components, and writing additional lines of code for the components, a simple program can be created without the programmer having to write many lines of code. Performance problems were experienced by earlier version, but with faster computer and native code compilation this has become less of an issue.Visual Basic (VB) is the third-generation event-driven programming language and Integrated Development Environment (IDE) from Microsoft for its COM programming model. VB is also considered a relatively easy to learn and use programming language, because of its graphical development features and BASIC heritage.
Visual Basic was derived from BASIC and enables the Rapid Application Development (RAD) of Graphical User Interface (GUI) application, access to database using Data Access Objects, Remote Data Object, or ActiveX Data Object, and creation of ActiveX data control and object. Scripting languages
such as VBA and VBScript are syntactically similar to Visual Basic, but perform differently.
A programmer can put together an application using the components provided with Visual Basic itself. Programs written in Visual Basic can also use the Windows API, but doing so requires external function declarations.
The final release was version 6 in 1998. Microsoft’s extended support ended in March 2008 and the designated successor was Visual Basic.NET (now known simply as Visual Basic).
Like the BASIC programming languages, Visual Basic was designed to be easily learned and used by beginner programmers. The language not only
allows programmers to create simple GUI application, but can also develop complex application. Programming in VB is a combination of visually arranging components or control on a form, specifying attributes and actions
OVERVIEW OF MICROSOFT SQL SERVER 2000
A relational data base management system (RDBMS) is a database management system (DBMS) that based on the relational model as introduced by Dr.Edgor.F.Codd. RDBMS are powerful because they require few assumptions about how data is related or how it will extracted from the database. So the same database can be viewed in many different ways. An Important features of relational system that a single database can be spread across several tables. Microsoft SQL server is a popular commercial RDBMS for large database.
SQL SERVER is a multi-user DBMS developed by server corporation. It can be used to store and manipulate large amount of information and automate
repetitive task such as maintaining an inventory and generate invoices. Enterprise manager is the main administrative console of SQL Server
installation. It provide you with graphical “birds – eye” view of all the SQL Server installation on your network.
You can perform high-level administrative function that affects one or more servers, schedule common maintenance task or create and modify the structure of individual database. Query Analyzer offers a quick and dirty method for performing queries against any of your SQL server database. It’s a great way to quickly to pull information out of database in response to a user request, test the queries before implementing them in other applications, create/modify stored procedure and execute administrative task.
SQL Profiler provides a window in to the inner working of your database. You can monitor many different events type and observe database performance in real time. SQL profile allows you to capture and replay
system “traces” that log various activities. It’s a great tool for optimizing database with performance issues or trouble shooting particular problem.
Service manager is used to control the MSSQL server(the main SQL Server process), MSTDC (Microsoft Distributed transaction Coordinator) and SQL
Server Agent Process. An icon of these services normally resides in the system tray of machine running SQL server. You can use service manager to start, stop or pause any of these services.
Date Transformation Services(DTS) provide an extremely flexible method for importing and data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the “import and Export data” wizards found in the SQL program group, Books online is an often overlooked resource provided with SQL Server that contains
answers to a verity of administrative, developed and installation issue. It’s great resources to consult before turning in to the Internet.
Here is the concept of “Foreign Key” also. A foreignkey in a table is a field which links that table with another table in the same database. Data Definition Language is a component of SQL used to create, modify and delete database structures but not data. These command are normally not user in general user, who should accessing the database via application. Data Manipulate Language allows changing the data within the database and Data Control Language,components of SQL server access to data and to the database. And Data Query Language allows getting data from the database.
SQL is a language that provides an interface to relation database system. In common usage SQL also encompasses DML (Data Manipulation Language) for Insert, Update, Deletes and DDL (Data Definition Language) used for creating and modifying tables and other database structures.
Within a table records are arranged to common reference value, known as “primary key” or the “key field”. The value in the key field is different for every record and thus help in uniquely identifying records. Since a value in
the table can be replicated across other table there should be a way to maintain a relation between the two tables. This relation is implemented through the concept of “foreign key”. A foreign key in a table is a field, which links that table to another table.
Features of SQL
• SQL can be used by a range of users, including those with little or no programming language.
• It is a non-procedural language
•
• It reduces the amount of time required for creating and maintaining systems.
• It is an English like language.
Date Transformation Services(DTS) provide an extremely flexible method for importing and data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the “import and Export data” wizards found in the SQL program group, Books online is an often overlooked resource provided with SQL Server that contains answers to a verity of administrative, developed and installation issue. .
Here is the concept of “Foreign Key” also. A foreignkey in a table is a field which links that table with another table in the same database. Data Definition Language is a component of SQL used to create, modify and delete database
structures but not data. These command are normally not user in general user, who should accessing the database via application. Data Manipulate Language allows changing the data within the database and Data Control Language,components of SQL server access to data and to the database. And Data Query Language allows getting data from the database.
COST ESTIMATION AND DEVELOPMENT
PROCESS
FEASIBILTY STUDY
The most difficult part of analysis is the identification of the candidate systems and evaluation of their performance. A feasibility study is conducted to select the best system that meets performance requirements. This entails an identification description, an evaluation of candidate systems, and the selection of the best system for the job. The new system has advantages such as we can easily doing transaction in the shop and this application is more user friendly for the employees.
There are three key considerations are involved in feasibility analysis. They are:
• Technical Feasibility
• Economic Feasibility
• Behavioral Feasibility
Technical Feasibility: Technical Feasibility determines whether the technology needed for the proposed system is available and how it can be integrated with in the organization. It centers on the existing computer system and to what extent it can support the proposed addition. It also involves financial considerations to accommodate technical enhancements. The HARDWARE SHOP MANAGEMENT SYSTEM can be done with the current software technology and available personal.
Economical Feasibility: Economic analysis is the most frequently used method for evaluating the effectiveness of a candidate system. More commonly known as cost/benefit analysis, the procedure is to determine the
benefits and savings that are expected from a candidate system and compare them with costs. If benefits out-weight costs, then the decision is made to design and implement the system. Otherwise further justification or alteration in the proposed system will have to be made if it is to have a chance of being approved. This is an ongoing effort that improves in accuracy at each phase of the system life cycle.
Behavioral Feasibility: people are inherently resistant to change, and computers have been known to facilitate change. An estimate should be made of how strong a reaction the user staff is likely to have toward the development of a computerized system. It is common knowledge that computer installed have something to do with turnover, transfers, retraining and changes in employee job status. Therefore it is understandable that the introduction of a candidate system requires special effort to educate, sell, and train the staff on new ways of conducting business.
The current staff can be very much used to run the new system by giving proper training. Most of the staff has the basic knowledge of a computer and thus training them is easy. Operational feasibility ensures the operational integrity of the system.
COST BENEFIT ANALYSIS
In developing cost estimates for a system, we need to consider several cost elements. Among them is hardware, personnel, ability, operating, supply cost.
1. Hardware costs relate to the actual purchase or lease of the computer and peripherals.
2. Personal costs include EPD staff salaries and benefits as well as pay those involved in developing the system.
3. Facility costs are expenses incurred in the preparation of the physical site where the application or the computer will be in operation.
4. Operating of the system.
5. Supply costs are variable costs that increase with increased use of paper, ribbons, disks, and the like. They should be estimated and include in the overall cost of the system.
Cost benefit analysis is the procedure that gives a picture of the various costs, benefit and rules associated with a system. The determination of costs and benefits entails the following steps:
1. Identify the costs and benefit pertaining to a given project.
2. Categorize the various costs and benefit for analysis.
3. Select a method of evaluation.
4. Interpret the result of the analysis.
5. Take action.
PROJECT DESCRIPTION
Hardware shop management system deals with the common operation of a Hardware shop. It handles the registration of item, customer, category, supplier and company. In the item registration it stores details of items. In the company registration it store the necessary company details. The category registration stores details of Hardware the necessary company details. In the customer registration it stores the necessary customer details.
In Purchase ordering is used for ordering item. Using this window we can efficiently order item from registered Supplier. Purchase section is used for purchasing the items that has already ordered through registered customers. The Hardware shop management system handles the purchase order of Hardwares then the efficient handled by this system.
Purchase order Display the details of the ordered items between two particular date, particular dates and all details. But in the case of purchase it display the details of the purchase item between two particular date, particular dates and all details
Facilities for generating necessary report for the efficient management of the Hardware shop are also provided in this system. Hardware shop management system has developed in Microsoft VB 6.0 environment (front end) and use Microsoft SQL Server 2000(back end) for database. The proposed system can easily make reports, can calculate accurate, and as a sum that reduces the man power, number of employees and development of the firm will not be a matter. In the case of cost, initial investment will not affect the ongoing process because the future profit with the proposed system overcomes the problem and it will be greater than manual work. The Hardware shop management system overcomes all the drawbacks of the manual system. It performs efficiently for the better performance of the organization.
INHERENT VIEW OF MODULES
The HARDWARE SHOP MANAGEMENT SYSTEM mainly contains different module like Registration, Transaction and Reports.
They are:
• Company Registration
• CategoryRegistration
• Type Registration
• colour Registration
• Staff Registration
• Customer Registration
• Dealer Registration
• Item registration
• Order
• Purchase
• Sales
REGISTRATIONS
Item Registration
Item registration window is used to store the item details like item id, item name, category name, price and details.
Category Registration
Category registration window is used to store the Hardware Category like Category id, category name,types.
Company Registration
Company registration window is used for storing company details like company id, company name, supplier name and other informations.
Customer Registration
Customer registration window is used to store the customer details like customer id, customer name and contact information’s.
Supplier Registration
Supplier registration is used for storing the supplier details with contact.
Type Registration
Type Registration is used to stores type id ,type name and category.
Colour Registration
Colour registration is used to store colour id and colour name.
Staff Registration
Staff registration stores the staff details.
TRANSACTIONS
Order
Purchase Order window is used for ordering items.
Purchase
Purchase Window is used for purchasing the item that has already ordered through registered Supplier.
Sales
Sales module is used for selling the item. The sub module is
REPORT
The report module contains all the reports. This contains the all, monthly and daily details of the shop.
Order Report
Purchase Report
Sales Report
Item Report
Company Report
Dealer Report
Colour Report
Category Report
Customer Report
Staff Report
Order Report
It displays the details of the ordered items for purchase
Purchase Report
It displays the details of the purchasing items
Sales Report
It displays the details of the soled items.
Item Report
It displays the details of item.
Staff Report
It displays the details of staffs
Customer Report
It displays the details of the customers
Dealer Report
It displays the details of the dealers
Company Registration
It is used to display the details of company.