CONTENTS
1. INTRODUCTION
2. REQUIREMENT SPECIFICATION
3. SYTSTEM ANALYSIS
4. SYSTEM REQUIREMENTS
5. SYSTEM DESIGN
6. SYSTEM TESTING
AND IMPLEMENTATION
7. SYSTEM MAINTENANCE
8. SCREEN LAYOUT
9. SOURCE CODE
10. ADVANTAGES
11. FUTURE ENHANCEMENT
12. BIBLIOGRAPHY
1
Inventory Control System
1.INTRODUCTION
1.1 OBJECTIVE
.The project entitled “INVENTORY CONTROL
SYS TEM” is
a windows based project which provides the user to test his own intelligence in a simple way.
The major objectives of the project are:
To provide Authentication.
To provide User friendly options.
To make levels independent.
To reduce Software complexity.
To avoid redundancy.
1.2 ABOUT THE PROJECT
The project „INVENTORY CONTROL
SYSTEM”‟ has
bee n
developed using VB as the front end and MS DATA ACCESS as the back end.
This
system can overcome almost all the existing drawbacks in other . for future purposes. The administrator part of this project can simply add more things to each and can view the results of users. It also provides much user friendliness for selecting appropriate fields and gives necessary help to the user to use this software.
The Inventory control system is the software developed in Microsoft Visual Basic 6.0 can be used in big shopes as well as in small shopes for control their marketing. This software can monitor the availability of the stock. We can add a new item and it‟s price though this one. When some one buy the product, it will show the availability of items and the price. After the purchase is made, it will update the available items list. An inventory control system may be used to automate a sales order fulfillment process. Such a system contains a list of order to be filled, and then prompts workers to pick the necessary items, and provides them with packaging and shipping information.
Cybo Tech Computers
2
Inventory Control System
An inventory system also manages in and outwards material of hardware.
An inventory control system is a set of hardware and software based tools that automate the process of tracking inventory. The kinds of inventory tracked with an inventory control system can include almost any type of quantifiable good, including food, clothing, books, equipment, and any other item that consumers, retailers, or wholesalers may purchase.
Inventory control is important to ensure quality control in businesses that handle transactions revolving around consumer goods. Without proper inventory control, a large retail store may run out of stock on an important item. A good inventory control system will alert the retailer when it is time to reorder. Inventory control is also an important means of automatically tracking large shipments.
Cybo Tech Computers
3
Inventory Control System
2.REQUIREMENT SPECIFICATION
2.1 EXISTING SYSTEM
The analysis phase is the detailed study of the existing system, its features and problems. Analysis is done to answer the question, what needs to be done to solve the problem? System analysis is the process of gathering and interpreting facts, diagnosing problems and using the information to recommend the improvements to the system.
System analysis begins when a user or manager requests the study of a program in either an existing system or a projected one. It involves studying the base of organization currently operating, retrieving and processing data information with a goal of determining how work can be done better.
2.1.1 DEMERITS OF EXISTING SYSTEM
Software used is more complex Security is not provided. Levels are dependent Manipulation of data is not provided through the front end.
2.2 PROPOSED SYSTEMS
Add items are included mainly in this.
2.2.1 FEATURES OF PROPOSED SYSTEM
Authentication is provided User friendly click options are provided Administrator can add options. Administrator can view the result of each user Levels are independent
Cybo Tech Computers
4
Inventory Control System
3.SYTSTEM ANALYSIS
3.1 INTRODUCTION
Analysis can be defined as separation of requirements into arts for study and interpretations, detailed examination. In system analysis the substance is the business under investigation and parts are various subsystems had work together to support the business. System analysis begins when a user or manger requests study of program in either an existing system or a proposed one .The system analyst should consult the user to know there needs and to know that the user expect from the proposed system . After getting the requirements of the user analyst can move on to other part of the analysis.
It involves studying the base of an organization currently operating, recognizing future enhancements and processing data to produce information with the goal of determining how to make it work better. System Analysis itself breaks into two stages:
Preliminary Analysis Detailed Analysis
In Preliminary, the analyst lists the objectives of the system. These findings are got during the communication with the client. From Developer should be able develop the system that fully satisfies the needs of the Client. The preliminary analysis document will include all those data‟s and requirements acquired by the analyst.
The Detailed analysis involves gathering facts about the old system , outlining objectives for a new one , estimating cost , listing possible alternatives and making recommendations . After detailed analyst, feasibility study is conducted
Proposed projects are beneficial only if they can be turned into information system that will meet the organization‟s reporting requirements. Financial benefit must be equal and exceeding the cost.
Cybo Tech Computers
5
Inventory Control System
3.2 FEASIBITILY STUDY
The development and implementation of a new system is definitely expensive. It requires system resources, manpower, time and money, so it improves the necessity of the feasibility study based on the proposed system requirements.
During system analysis the feasibility study of the proposed system is to be carried out. The main objective of this study is to determine whether the proposed system is feasible or not, i.e. to ensure that proposed system is not a burden to the company. The study can be categorized into three types. They are
Technical feasibility Behavioral feasibility Economic feasibility
The proposed system must be evaluated from a technical view point first, and if technically feasible there impact on the organization must be assessed. If compatible, behavioral system can be devised. Then they must be tested for economical feasibility.
Technical Feasibility study
This study is carried out to check the technical facility, that is, the technical requirements of the system. The assessment of technical feasibility must be based on an outline design of system requirements in terms of input, output, files, programs, and procedures. This can be qualified in terms of input output, files, programs, and procedures. This can be qualified in terms of volumes of data, trends, frequency of updating, cycles of activity etc., in order to give an introduction of technical system. The system should provide technical guarantee of accuracy, reliability, ease of access and data security and through this the hardware and software requirements should be satisfied. The developed system, IQUEST has a modest technical requirement, as only minimal or null changes are required for implementing this system.
Cybo Tech Computers
6
Inventory Control System
Behavioral Feasibility study
This aspect of study is to check the level of the system by the user. This includes the process of training the system but must accept it as necessity. The levels of acceptance by the user solely depend on the methods that are employed to educate the user about the system and to make him familiar with it. Hi level of confidence must be raised so that he is also able to make some constructive criticism, which is welcomed as he is the final user of the system .IQUEST is very user friendly and it‟s easy to perceive, so not much training is needed to handle the system.
Economic Feasibility study
This study is carried out to check the economic impact that the system will have on the organization. The amount of fund that the company can pour into the research and development of the system is limited and the expenditures must be justified. Thus the developed system was well within the budget and this was achieved because most of the technologies used are freely available.
The technique of cost-benefit analysis is often used as a basis for assessing economical feasibility. IQUEST can be developed at a reasonable cost with the available hardware, software and manpower. Its benefits overweigh the cost. Since it doesn‟t require additional cost for the development of the proposed system, it is economically feasible.
Cybo Tech Computers
7
Inventory Control System
4. SYSTEM REQUIREMENTS
4.1 HARDWARE REQUIREMENTS
Machine
:
Any windows compatible system
Processor
:
Intel Pentium-4 series
Motherboard
:
Intel D845GEBV2
Processor speed
:
2.4 GHZ or above
RAM
:
256 MB or above
Hard Disc
:
40/80 GB or above
Monitor
:
Samsung(15 inch)
Keyboard
:
108SoftTouch
Mouse
:
Two button with center scroll
4.2
SOFTWARE REQUIREMENTS
Languages used
:
Visual Basic 6.0
Platform
:
Windows
Database
:
Microsoft Data Access
4.2.1 OPERATING SYSTEM
An operating system (OS) is an integrated set of programs that is used to manage the various resources and overall operations of a computer system are a master control program that runs the computer acts as a scheduler. It controls a flow of signals‟ from CPU to various parts of the computer .It is the first program loaded into the computer‟s memory after the computer is switched un popular operating systems includes MS –DOS , Windows , UNIX and OS2.
Cybo Tech Computers
8
Inventory Control System
WINDOWS XP
Windows XP is an operating system introduced by Microsoft Corporation. Windows is multitasking; multi-threading Graphical User Interface (GUI) environment that runs on MS-DOS based computers. Windows provides a standard interface based on dropdown menus , Window region on the screen and pointing devices such as mouse programs must be specially designed to take advantages‟ of these features . Mouse is a pointing device
GUI (Graphical User Interface)
Isa graphic based user interface that allows users to select files, programs or commands by pointing to pictorial representation as the serene rather than by typing long. Complex commands from a command prompt. Applications executing window using consistent set of pull-down menus, dialog boxes and rather graphical elements. This consistency among interface element is a major benefit user .GUI„s have emerged for most computing environments.
Multitasking and Multithreading
Windows XP lets to do more than one task at one time by using a preemptive multitasking scheme. Window XP is a preemptive mutiny tasking lets the CPU manage its own time
Devices Independent Program:
Windows lets you write device independent program. You don‟t have to concern yourself with what type of printer, mouse, monitor, keyboard, sound card, CD –ROM, drive or other devices user own.
Standard User –Interface:
This mechanism is the same for all Windows application. Without reading your application, your users know how to execute your application; they can use the icon on the corner of the application Windows to minimize the Window.
Cybo Tech Computers
9
Inventory Control System
The windows XP environment is a boon for users of DOS. An operating system is a set of software tools designed to make it easy for people and programs to make to optimum use of the computer .People who use computers have different levels of needs and interests. These people can be separated into two groups: Administrator and Clients.
Windows XP is currently the most popular operating system PC, consequently almost all vendors ship their PCs with a mouse and windows operating system already installed.
4.2.2 Platform-MS Windows XP
MS Windows XP is a 32-bit Graphical User Interface (GUI) operating system developed by the Microsoft Corporation. It uses pre-emptive multitasking and multithreading, to perform several actions at the same time. The advantages are user friendly environment, faster, Recycle Bin-a place that stores the deleted files which can be cleared later and the inbox which can be used for communication like fax, E-mail etc. Also Windows supports long file names, cut and paste etc. There are different versions of MS Windows. The most popular are:
MS Windows 95/98/2000 MS Windows NT
Visual Basic 6.0
Visual basic is a Windows based event driven programming language that has been developed at Microsoft Corporation. It is one of the Rapid Application Development (RAD) tools as it enables the programmer to develop Windows based applications very easily and quickly. It includes all the necessary extensions to produce Windows based programs. Visual Basic applications are very popular as front-end to many Client/Server database systems like SQL Server, Oracle, MS Access etc. The main features of Visual Basic include:
₃ Event driven programming language, easy to learn and use
₃ Provides graphical user interface
Cybo Tech Computers
10
Inventory Control System
₃ It has built in application setup wizard that can be used to write setup programs
₃ It supports multithreading, Dynamic Data Exchanges (DDE), and Object Linking and Embedding (OLE)
₃ It highly suited for front-end programming
₃ Forms can be designed to suit any GUI requirement; controls are drawn on the form to enhance user interaction, in built facilities to design menus
₃ Database creation and database connectivity tools
₃ The ability to create pop-up menus anywhere in the application
₃ Provides collections of commonly used dialog boxes
₃ Executable file creation is very easy
The programming terminology used in Visual basic includes:
₃ Forms
Forms are the basic objects used in Visual Basic application development. It is a window, initially blank, on which controls are placed to create the screen display. Forms are saved in the disk as a file with the extension “frm”.
₃ Controls
Controls are the building blocks of a Visual Basic application which are used to display text on the screen, accept inputs etc. Some examples are Label, Textbox, Frame, and Command Button.
₃ Module
Code in Visual Basic is stored in modules. There are three kinds of modules: Class Modules, Form Modules and Standard Modules.
Form Module: Contains form level declarations of type constants, variables and external procedures, procedures that handle events and general procedures.
Class Modules: Class modules (.CLS extension) are foundation of object oriented programming in VB.
Cybo Tech Computers
11
Inventory Control System
Standard Modules: Standard Modules (.BAS extension) are containers for procedures and declarations, commonly used by other parts of an application.
₃ Project
The project is the file in which all the form files (*.frm files) and the modules that make up the entire application is kept.
₃ Procedures
Programming task can be simplified by breaking programs into smaller logical components. These components are called procedures. A procedure in VB can be a Sub, Function, or Property procedure.
Relational Database Management System
A relational database management system consists of a collection of tables, each of which is assigned a unique name. Each table has a structure similar to E-R database by tables. A row in a table represents a relationship among a set of correspondence between the concepts of relation, from which the relational data model takes its name.
A modern DBMS acts as an interface between the physical storage and logical representation of data. In practice, it provides a set of flexible and sophisticated tools for handling information. We can see these tools to
₃ Define a database
₃ Query a database
₃ Add, edit and delete data
₃ Modify structure of database
₃ Secure data from public access
₃ Communicate within networks
₃ Export and import data
Because it gives so much control over data, a RDBMS can also serve as the foundation for products that generate applications and generate data.
About Microsoft Access
Microsoft Access is a database management system or DBMS. As the name implies, a DBMS helps you to manage data that‟s stored in a computer database. If you
Cybo Tech Computers
12
Inventory Control System
want the flexibility to display, print and analyze your information in whatever format you wish, you first need to break down that information into small unit of data. After breaking the information into discrete units of data, you can use a database management system, such as Access, to analyze and present that data any way you wish.
In Access, you must break all your information into data that‟s stored in tables. A table is just a collection of data that‟s organized into rows and column. You can put any information that‟s available to you into a table.
Access act as database. Database is a collection of tables. Table is collection of rows and columns. Database management programs are designed to store, manipulate and report large volume of information created by other offices and windows programs. You can insert excel spreadsheet documents directly into an access table.
The ease and flexibility of doing this is impressive. For example, you can cut a portion of a document created by another program and then paste it into an access table. Or, you may prefer to “drag and drop” part of one d ocument into another using your mouse. Finally, you may simply import one kind of document into another.
Cybo Tech Computers
13
Inventory Control System
5. SYSTEM DESIGN
5.1 INTRODUCTION
Design is the first phase in the development phase for any engineered product of system. Design is a creative process. A good design is the key to effective system. the term “Design “is defined as “ the process of a system in sufficient details‟ to permit its physical realization “ it may be defined as the process of applying various techniques and principles for the purpose for defining a device , a process or a system in sufficient detail to permit its physical realization . Soft ware design sits at the technical kernel of soft ware engineering process and is applied regardless of the development paradigm that is used.
From a project management point of you, software design is conducted in to steps. Preliminary design is concerned with the transformations of requirements to the architectural representation that lead to details algorithm data structure and representation of software
In system design high –end decisions are takrn reg arding the basic system architecture, platforms and tools to be used in the system design transforms a logical representation of what a given system is required to be in physical specification. Design starts with the system requirement specification and converts it to physical reality during the development. Important design factors such as reliability, response time, throughput of the system, maintainability, expandability etc should be taken into account
Cybo Tech Computers
14
Inventory Control System
5.2 INPUT DESIGN
The collection of input data is the most expensive part of the system in terms of the equipment used and the number of people involved .In input design , data is accept for computer processing and input into the system is done through mapping via some map support or links
In this project user interphase is done using highly flexible and efficient input design. Input design is the process of converting user inputs into computer- based format.
5.3 OUTPUT DESIGN
Out puts are the most important and direct source of information to the user of the computer system that needs to transmit a secure data. To convey data securely and to the intended recipient, output designs help to display any transmission errors, data loses.
5.4 SYSTEM FLOW DIAGRAM
This section explains the design and architecture of the software and provides a through overview of the process that takes place in the software. The following figure shows the overall modules present in this application.
Cybo Tech Computers
15
Inventory Control System
SYSTEM FLOW DIAGRAM
User
Home
login
Start
Stock Details
Result
Help
Exit
5.5 DATA FLOW DIAGRAM
LEVEL 1:
Login Tab
User id
Password
User
Login
Stock Detail
Checking
Cybo Tech Computers
16
Inventory Control System
LEVEL 2:
Login Tab
User id
Password
Administrator
Login
Add
Checking
5.6 TABLES
Table 1:
The table 1 is used to store the questions which are to be displayed in the normal level. This table consists of five fields. They are the serial number, question, the four choices for the question and the correct answer.
Field
Data type
Description
Name
SL NO
int
Serial number
Q
Varchar(50)
name
C1
Varchar(10)
Choice1
C2
Varchar(10)
Choice 2
C3
Varchar(10)
Choice 3
C4
Varchar(10)
Choice 4
A
Varchar(10)
Correct Choice
Table 2:
The table 2 is used to store the questions which are to be displayed in the medium level. This table consists of five fields. They are the serial number, question, the four choices for the question and the correct answer.
Cybo Tech Computers
17
Inventory Control System
Field
Data type
Description
Name
SL NO
int
Serial number
Q
Varchar(50)
Question
C1
Varchar(10)
Choice number 1
C2
Varchar(10)
Choice number 2
C3
Varchar(10)
Choice number 3
C4
Varchar(10)
Choice number 4
A
Varchar(10)
Correct Choice
Table 3:
The table 3 is used to store the question which is to be displayed in the standard
level. This table consists of five fields. They are the serial number, question, the four
choices for the question and the correct answer.
Field
Data type
Description
Name
SL NO
int
Serial number
Q
Varchar(50)
Question
C1
Varchar(10)
Choice number 1
C2
Varchar(10)
Choice number 2
C3
Varchar(10)
Choice number 3
C4
Varchar(10)
Choice number 4
A
Varchar(10)
Correct Choice
Table 4:
The table 4 stores the name of the user. This table consists of only one field that is the
name of the user.
Field Name
Data type
Description
Name
Varchar(10)
Name of the
user
Table 5:
This table stores the scores of every user. This table consists of only one field that
is the score of the user.
Field Name
Data type
Description
Score
int
List of the user
Cybo Tech Computers
18
Inventory Control System
6. SYSTEM TESTING AND
IMPLEMENTATION
6.1 SYSTEM TESTING
System testing is a critical aspect of Software Quality Assurance and represents the ultimate review of specification, design and coding. Testing is a process of executing a program with the intent of finding an error. A good test is one that has a probability of finding an as yet undiscovered error. The purpose of testing is to identify and correct bugs in the developed system. Nothing is complete without testing. Testing is the vital to the success of the system.
In the code testing the logic of the developed system is tested. For this every module of the program is executed to find an error. To perform specification test, the examination of the specifications stating what the program should do and how it should perform under various conditions.
Unit testing focuses first on the modules in the proposed system to locate errors. This enables to detect errors in the coding and logic that are contained within that module alone. Those resulting from the interaction between modules are initially avoided. In unit testing step each module has to be checked separately.
System testing does not test the software as a whole, but rather than integration of each module in the system. The primary concern is the compatibility of individual modules. One has to find areas where modules have been designed with different specifications of data lengths, type and data element name.
Testing and validation are the most important steps after the implementation of the developed system. The system testing is performed to ensure that there are no errors in the implemented system.
Cybo Tech Computers
19
Inventory Control System
Validation refers to the process of using the new software for the developed system in a live environment i.e., new software inside the organization, in order to find out the errors. The validation phase reveals the failures and the bugs in the developed system. It will be come to know about the practical difficulties the system faces when operated in the true environment. By testing the code of the implemented software, the logic of the program can be examined. A specification test is conducted to check whether the specifications stating the program are performing under various conditions.
Software testing is a critical element of software quality assurance and represents the ultimate review of specification, design, and coding. Testing includes verification of the basic logic of each program and verification that the entire system works properly. The programs facilitate testing by coding as clearly as possible. Test case design focuses on a set of techniques for the creation of test cases that meet overall testing objectives.
The following are the important steps in testing
i) Testing is a process of executing a program with the intent of finding an error.
ii) A good test case is one that has a high probability of finding an undiscovered error.
iii) Constructing the test data for the program.
iv) Analysis of result to delete a program error.
v) Localization of errors and modification of program to eliminate them.
The testing process focus on the logical intervals of the software, ensuring that all statements have been tested and on the functional intervals that is conduction test to uncover errors and ensure that defined input will produce actual results that agree with the required results.
Program level testing, module level testing, and integration testing are carried out successfully. After this acceptance testing was carried out. In it, issues like performance, user friendliness etc were tested.
Cybo Tech Computers
20
Inventory Control System
The data has been prepared for the above tests and detailed test plans were drawn at each stage of testing. Apart from these tests, there are some special tests conducted which are given below:
Peak Load Tests:-
This determines whether the new system will handle the volume of activities when the system is at the peak of its processing demand. The test has revealed that the new software for the agency is capable of handling the demands at the peak time.
Storage Testing:-
This determines the capacity of the new system to store transaction data on a disk or on other files. The proposed software has the required storage space available, because of the use of a number of hard disks.
Performance Time Testing:-
This test determines the length of the time used by the system to process transaction data. The newly designed system should be in the working order but in reality, each should work independently. Now is the time to pull all into one system and test it to determine whether it meets the user requirements. System testing is executing a program to check logic changes made in it and with the intention of finding errors-making the program fail.
Integration Testing
Integration testing is a systematic technique for constructing the program structure, while at the same time conducting test to uncover errors associated with interfacing. In other words, integration testing is the complete testing of the set of modules which makes up the product, using the previously unit tested modules to construct a product. As integration testing is conducted, the tester should identify critical modules.
Form Testing
The following tests were made on the design for data entry will be window open properly based on button based commands
Is all objects contained within the window properly navigable with the mouse and keyboard?
Cybo Tech Computers
21
Inventory Control System
Does the window properly regenerate when it is overwritten and then recalled? Are all relevant pull down menus, tool bars, dialog boxes, icon and other controls available and properly displayed for the window? When multiple windows are displayed, is the window name properly represented? Is the active window properly highlighted? Do multiple or incorrect mouse clicks cause unexpected side effects? Does the window properly close?
Validation Testing
Validation succeeds when the software functions in a manner that can be reasonably expected by the customer. Software validation is achieved through a series of tests that demonstrates conformity with requirements. Once the application was made free of all logical and interface errors, validation checking was done by inputting dummy data to ensure that the software developed satisfied all the requirements of the user. A test case is a set of data that the system process or normal input.
There are two major types:
₃ Black Box Testing.
₃ White Box Testing.
Black Box Testing:
Black-box testing focuses on the functional requirements of the software. That is, black-box checking enables the software engineer to derive a set of input conditions that will fully exercise all functional requirements for a program.
Black-box testing is not an alternative to white-box techniques. Rather, it is complementary approach that is likely to uncover a different class of errors than white-box methods.
Black-box testing attempts to find errors in the following categories:
1. Incorrect or missing functions.
2. Interface errors.
3. Performance in data structures or external data base access.
4. Performance errors.
5. Initialization and termination errors.
Cybo Tech Computers
22
Inventory Control System
All the above-mentioned errors were checked in the process of black box testing and the bugs were fixed.
White Box Testing
White box testing, sometimes called “glass-box test ing”, is a test case design uses the control structure of the procedural design to derive test case. Using white box checking methods, the following tests were made the system:
1. All independent paths within a module have been exercised at least once.
2. All logical decisions were checked for the truth and falsity of the values. Every if structure was checked giving different values. So that the condition has both true and false values, in order to cover both the results and to check the validity of the system.
3. All loops were executed to check their boundary values. This checking was carried out by the system on do while and for loops and bugs were fixed.
4. Internal data-structure was tested for their validity. In our system, checks were made on the data structures: to ensure that variables handle any type of data type variant data types variables were checked for their capacity.
User Interface Testing
The interface between the end user and the software was developed so as to be convenient and easy for the user. Each screen involved in the system has been designed to facilitate easy usage by the user. Thus user interface testing is conducted and it is no exaggeration that the software was able to satisfy the users.
PROGRAM TESTING
Before implementation, the designed system should be tested with row data to ensure that all modules of the system were tested using the following strategies
Unit testing System testing
Unit testing :
Each of the modules were developed and tested independently and where the following considerations were made :-
The module interface tested to check the flow of information.
Cybo Tech Computers
23
Inventory Control System
Boundary conditions are tested. All error-handling paths are checked.
System testing :
Integration testing was done to variety the co-existence of the modules and the forms involved. Bottom-up integration strategy was used. After the unit testing they were integrated from bottom to up by combining the clusters. Finally, when all the modules were developed and integrated, they were tested with the data, which were provided by some individuals as well as the members involved in visualizing this concept.
6.2 SYSTEM IMPLEMENTATION
System implementation is the important stage of the project when the theoretical design is turn into practical system.
The main stages in the implementation are turn into practical system are.
₃ Planning
₃ Training
₃ System Testing
₃ Maintenance
Planning
When implementation is concerned planning plays an important role. The implementation of any system will have to face any practical problems of controlling various activities of people outside their own data processing department. The active co-operation of different users will be essential for successful implementation.
Training
For successful implementation, trained computer staffs are essential. So, we have to select some staffs for the organization and each of them should be trained to use the implemented system.
Cybo Tech Computers
24
Inventory Control System
Maintenance
The next stage is system maintenance. While security modules is specially designed to avoid unauthorized users entering into the system. In this system we provide two level securities. First security for entering into the main module. From this module, we provided second level security to enter into each module. System maintenance is the general process of changing a system after it has been delivered. There are three different types of software maintenance.
Maintenance to repair software faults. Maintenance to adapt the software to a different operating environment. Maintenance to add or modify the system‟s functionality.
Maintenance processes vary considerably depending on the type of software being maintained, the development processes used in an organization and the people involved in the process. At an abstract level all maintenance processes have the aim fundamentals activities of change analysis, release planning, system implementation and releasing a system to customer.
The maintenance process is triggered by a set of change requests from system users, management of logged users
Cybo Tech Computers
25
Inventory Control System
7.SYSTEM MAINTENANCE
The maintenance phase of the software cycle is the time in which software products perform useful work. After a system is successfully implemented, it should be maintained in a proper manner. System maintenance is an important aspect in the software development life cycle. The system maintenance is for it to make adaptable to the changes in the environment. There may be social, technical and other environmental changes, which affect the systems behavior.
Software product enhancements may involve providing new functional capabilities improving use displays and mode of interaction, upgrading the performance characteristic of the system. So only through proper system maintenance procedures, the system can be adapted to come up with these changes.
The first maintenance activity occurs because it is unreasonable to assume that testing will uncover all latent errors in a large software system. During the use of any large program errors will occur and be reported to the developer. The process that includes the diagnosis and connection of one or more errors is called corrective maintenance. The second activity that contributes to a definition of maintenance occurs because rapid change that is encountered in every aspect computing. Therefore adaptive maintenance is an active that modifies software to properly interface with a changing environment is both necessary and commonplace.
The third activity that may be applied to the definition of maintenance occurs when a software package is successful. As the software is used, recommendations for new capabilities, modification for existing functions and general enhancement are received from the users. To satisfy request in this category, prefecture maintenance is performed.
The fourth maintenance activity occurs when the software is changed to improve future maintability or reliability or to provide better basics for future enhancements. This project being on the client and server side, maintenance will be required on both sides. When the server is being maintained, the whole part of the system may temporarily become unavailable to the client.
Cybo Tech Computers
26
Inventory Control System
8. SCREEN LAYOUT
Cybo Tech Computers
27
Inventory Control System
9. SOURCE CODE
Dim username As String
Dim password As String
Dim address As String
Private Sub Command1_Click()
Data1.Recordset.MoveFirst
i = 0
Do Until Data1.Recordset.EOF = True
If Text1.Text = Data1.Recordset.Fields(0) Then
If Text2.Text = Data1.Recordset.Fields(1) Then
i = 1
Form2.Show
Me.Hide
Exit Do
End If
End If
Data1.Recordset.MoveNext
Loop
If i = 0 Then
MsgBox ("Enter the correct username and password..")
End If
End Sub
Private Sub Command2_Click()
Form1.Height = 7830
Label1(1).Visible = True
Label2(1).Visible = True
Label2(2).Visible = True
Label2(3).Visible = True
Label3.Visible = True
Text3.Visible = True
Text4.Visible = True
Text5.Visible = True
Text6.Visible = True
Command3.Visible = True
Data1.Recordset.MoveLast
Data1.Recordset.AddNew
End Sub
Cybo Tech Computers
28
Inventory Control System
Private Sub Command3_Click()
If Text3.Text <> Null And Text4.Text <> Null And Text5.Text <> Null And Text6.Text <> Null Then
If Text4.Text = Text5.Text Then
Data1.Recordset.Update
Form1.Height = 3240
Label1(1).Visible = False
Label2(1).Visible = False
Label2(2).Visible = False
Label2(3).Visible = False
Label3.Visible = False
Text3.Visible = False
Text4.Visible = False
Text5.Visible = False
Text6.Visible = False
Command3.Visible = False
MsgBox ("User created")
Else
MsgBox ("Enter the correct password..")
End If
Else
MsgBox ("Fill all the boxes")
End If
End Sub
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call Command1_Click
End If
End Sub
Private Sub Text2_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call Command1_Click
End If
End Sub
Dim sets As Boolean
Cybo Tech Computers
29
Inventory Control System
Dim prod, meas As String
Dim quan, price, total As Integer Private Sub Command1_Click() Dim str As String
str = "\t..Your Bil..\nProduct: " + prod + "\nQuantity: " + quan + " " + meas + "\nPrice: " + price + "*" + quan + "=" + total
Data1.Recordset.MoveFirst End Sub
Private Sub Command2_Click()
If Not Data1.Recordset.BOF Then
Data1.Recordset.MovePrevious
If Data1.Recordset.BOF Then
Data1.Recordset.MoveNext
End If
End If
End Sub
Private Sub Command3_Click()
If Not Data1.Recordset.EOF Then
Data1.Recordset.MoveNext
If Data1.Recordset.EOF Then
Data1.Recordset.MovePrevious
End If
End If
End Sub
Private Sub Command4_Click()
Data1.Recordset.MoveLast
End Sub
Private Sub Command5_Click() Data1.Recordset.MoveLast Data1.Recordset.AddNew reenter:
Text1.Text = InputBox("Enter product name:") If Text1.Text = "" Then
MsgBox ("Enter the item name properly..") GoTo reenter
End If reenter1:
Text2.Text = InputBox("Enter Available stock:") If Text1.Text = "" Then
MsgBox ("Enter the available stock properly..") GoTo reenter1
End If reenter2:
Cybo Tech Computers
30
Inventory Control System
Text3.Text = InputBox("Enter Quantity:") If Text1.Text = "" Then
MsgBox ("Enter the Quantity properly..") GoTo reenter2
End If reenter3:
Text4.Text = InputBox("Enter price:") If Text1.Text = "" Then
MsgBox ("Enter the price properly..") GoTo reenter3
End If Data1.Recordset.Update
c = MsgBox("New product is added successfully..", vbOKOnly) End Sub
Private Sub Command6_Click() If sets = True Then Text1.Enabled = True Text2.Enabled = True Text3.Enabled = True Text4.Enabled = True Command6.Caption = "OK" End If
If sets = False Then Data1.Recordset.Edit Data1.Recordset.MoveFirst Text1.Enabled = False Text2.Enabled = False Text3.Enabled = False Text4.Enabled = False
Command6.Caption = "Update Stock" End If
sets = Not (sets)
End Sub
Private Sub Command7_Click()
Data1.Recordset.Delete
Data1.Recordset.MoveFirst
End Sub
Private Sub Command8_Click()
Dim avail As Integer
Dim str As String
quan = 0
prod = Text1.Text
Cybo Tech Computers
31
Inventory Control System
price = Val(Text4.Text)
enterAgain:
quan = InputBox("How much you want to buy..?", prod)
If (Not IsNumeric(quan)) Or quan = "" Then
MsgBox ("Enter the value properly..")
GoTo enterAgain
End If
avail = Val(Text2.Text) If avail < quan Then
i = MsgBox("These much stock not available.." & vbCrLf & "Do you want to re enter quantity..?", vbYesNo, "Less stock")
If i = vbYes Then GoTo enterAgain Else
quan = 0 price = 0 End If End If
Text2.Text = avail - quan meas = Text3.Text
total = quan * price
skip:
MsgBox ("***Your bill is here***" & vbCrLf & "--------------------------" & vbCrLf & "
Item : " & prod & vbCrLf & " Quantity : " & quan & vbCrLf & "--------------------------" &
vbCrLf & "Total price : " & quan & "*" & price & "=" & total)
'MsgBox ("you have to pay ")
Data1.Recordset.Edit
Data1.Recordset.MoveFirst
End Sub
Private Sub Form_Load()
sets = True
End Sub
Private Sub Form_Unload(Cancel As Integer)
End
End Sub
Cybo Tech Computers
32
Inventory Control System
10. ADVANTAGES
Advanteges
Easily navigate through the available items. The updation of stock can be made easily. Authentication is provided User friendly options are provided Administrator can add questions Administrator can view the score of each user Levels are independent Software complexity is reduced Total redundancy is avoided
Disadvantages
Searching for an item is difficult, if more items are there. Only one user can operate at a time. Only one database is used for data storage.
Cybo Tech Computers
33
Inventory Control System
11.FUTURE ENHANCEMENT
This project can be developed into a web based one and can be accessed from anywhere anytime, so that more than one user can take it. Also this project can be implemented in a network for adding certain features to it.
Can develop into a web based one. Much Authentication can be provided Barcode reader can be included for identify the item, so that the security become high. Develop the system so that multiple users can use it.
Cybo Tech Computers
34
Inventory Control System
12.BIBLIOGRAPHY
₃ Vikas Gupta , Net Programming , Comdex Computer Publishing.
₃ Cem Kaner, Jack Falk, Hung Quoc Nguyen , Testing Computer Software , Comdex Computer Publishing; Second Edition.
₃ Roger S. Pressman, Software Engineering A Practitioner‟s Approach Mc Graw Hill Companies Inc;5th edition- 2001.
Websites
₃ http:// www.google.com
₃ http://www.howstuffs.com
₃ http://www.quizquestions.com
₃ http://www.vb.com
₃ http://codeproject.com
Cybo Tech Computers
1. INTRODUCTION
2. REQUIREMENT SPECIFICATION
3. SYTSTEM ANALYSIS
4. SYSTEM REQUIREMENTS
5. SYSTEM DESIGN
6. SYSTEM TESTING
AND IMPLEMENTATION
7. SYSTEM MAINTENANCE
8. SCREEN LAYOUT
9. SOURCE CODE
10. ADVANTAGES
11. FUTURE ENHANCEMENT
12. BIBLIOGRAPHY
1
Inventory Control System
1.INTRODUCTION
1.1 OBJECTIVE
.The project entitled “INVENTORY CONTROL
SYS TEM” is
a windows based project which provides the user to test his own intelligence in a simple way.
The major objectives of the project are:
To provide Authentication.
To provide User friendly options.
To make levels independent.
To reduce Software complexity.
To avoid redundancy.
1.2 ABOUT THE PROJECT
The project „INVENTORY CONTROL
SYSTEM”‟ has
bee n
developed using VB as the front end and MS DATA ACCESS as the back end.
This
system can overcome almost all the existing drawbacks in other . for future purposes. The administrator part of this project can simply add more things to each and can view the results of users. It also provides much user friendliness for selecting appropriate fields and gives necessary help to the user to use this software.
The Inventory control system is the software developed in Microsoft Visual Basic 6.0 can be used in big shopes as well as in small shopes for control their marketing. This software can monitor the availability of the stock. We can add a new item and it‟s price though this one. When some one buy the product, it will show the availability of items and the price. After the purchase is made, it will update the available items list. An inventory control system may be used to automate a sales order fulfillment process. Such a system contains a list of order to be filled, and then prompts workers to pick the necessary items, and provides them with packaging and shipping information.
Cybo Tech Computers
2
Inventory Control System
An inventory system also manages in and outwards material of hardware.
An inventory control system is a set of hardware and software based tools that automate the process of tracking inventory. The kinds of inventory tracked with an inventory control system can include almost any type of quantifiable good, including food, clothing, books, equipment, and any other item that consumers, retailers, or wholesalers may purchase.
Inventory control is important to ensure quality control in businesses that handle transactions revolving around consumer goods. Without proper inventory control, a large retail store may run out of stock on an important item. A good inventory control system will alert the retailer when it is time to reorder. Inventory control is also an important means of automatically tracking large shipments.
Cybo Tech Computers
3
Inventory Control System
2.REQUIREMENT SPECIFICATION
2.1 EXISTING SYSTEM
The analysis phase is the detailed study of the existing system, its features and problems. Analysis is done to answer the question, what needs to be done to solve the problem? System analysis is the process of gathering and interpreting facts, diagnosing problems and using the information to recommend the improvements to the system.
System analysis begins when a user or manager requests the study of a program in either an existing system or a projected one. It involves studying the base of organization currently operating, retrieving and processing data information with a goal of determining how work can be done better.
2.1.1 DEMERITS OF EXISTING SYSTEM
Software used is more complex Security is not provided. Levels are dependent Manipulation of data is not provided through the front end.
2.2 PROPOSED SYSTEMS
Add items are included mainly in this.
2.2.1 FEATURES OF PROPOSED SYSTEM
Authentication is provided User friendly click options are provided Administrator can add options. Administrator can view the result of each user Levels are independent
Cybo Tech Computers
4
Inventory Control System
3.SYTSTEM ANALYSIS
3.1 INTRODUCTION
Analysis can be defined as separation of requirements into arts for study and interpretations, detailed examination. In system analysis the substance is the business under investigation and parts are various subsystems had work together to support the business. System analysis begins when a user or manger requests study of program in either an existing system or a proposed one .The system analyst should consult the user to know there needs and to know that the user expect from the proposed system . After getting the requirements of the user analyst can move on to other part of the analysis.
It involves studying the base of an organization currently operating, recognizing future enhancements and processing data to produce information with the goal of determining how to make it work better. System Analysis itself breaks into two stages:
Preliminary Analysis Detailed Analysis
In Preliminary, the analyst lists the objectives of the system. These findings are got during the communication with the client. From Developer should be able develop the system that fully satisfies the needs of the Client. The preliminary analysis document will include all those data‟s and requirements acquired by the analyst.
The Detailed analysis involves gathering facts about the old system , outlining objectives for a new one , estimating cost , listing possible alternatives and making recommendations . After detailed analyst, feasibility study is conducted
Proposed projects are beneficial only if they can be turned into information system that will meet the organization‟s reporting requirements. Financial benefit must be equal and exceeding the cost.
Cybo Tech Computers
5
Inventory Control System
3.2 FEASIBITILY STUDY
The development and implementation of a new system is definitely expensive. It requires system resources, manpower, time and money, so it improves the necessity of the feasibility study based on the proposed system requirements.
During system analysis the feasibility study of the proposed system is to be carried out. The main objective of this study is to determine whether the proposed system is feasible or not, i.e. to ensure that proposed system is not a burden to the company. The study can be categorized into three types. They are
Technical feasibility Behavioral feasibility Economic feasibility
The proposed system must be evaluated from a technical view point first, and if technically feasible there impact on the organization must be assessed. If compatible, behavioral system can be devised. Then they must be tested for economical feasibility.
Technical Feasibility study
This study is carried out to check the technical facility, that is, the technical requirements of the system. The assessment of technical feasibility must be based on an outline design of system requirements in terms of input, output, files, programs, and procedures. This can be qualified in terms of input output, files, programs, and procedures. This can be qualified in terms of volumes of data, trends, frequency of updating, cycles of activity etc., in order to give an introduction of technical system. The system should provide technical guarantee of accuracy, reliability, ease of access and data security and through this the hardware and software requirements should be satisfied. The developed system, IQUEST has a modest technical requirement, as only minimal or null changes are required for implementing this system.
Cybo Tech Computers
6
Inventory Control System
Behavioral Feasibility study
This aspect of study is to check the level of the system by the user. This includes the process of training the system but must accept it as necessity. The levels of acceptance by the user solely depend on the methods that are employed to educate the user about the system and to make him familiar with it. Hi level of confidence must be raised so that he is also able to make some constructive criticism, which is welcomed as he is the final user of the system .IQUEST is very user friendly and it‟s easy to perceive, so not much training is needed to handle the system.
Economic Feasibility study
This study is carried out to check the economic impact that the system will have on the organization. The amount of fund that the company can pour into the research and development of the system is limited and the expenditures must be justified. Thus the developed system was well within the budget and this was achieved because most of the technologies used are freely available.
The technique of cost-benefit analysis is often used as a basis for assessing economical feasibility. IQUEST can be developed at a reasonable cost with the available hardware, software and manpower. Its benefits overweigh the cost. Since it doesn‟t require additional cost for the development of the proposed system, it is economically feasible.
Cybo Tech Computers
7
Inventory Control System
4. SYSTEM REQUIREMENTS
4.1 HARDWARE REQUIREMENTS
Machine
:
Any windows compatible system
Processor
:
Intel Pentium-4 series
Motherboard
:
Intel D845GEBV2
Processor speed
:
2.4 GHZ or above
RAM
:
256 MB or above
Hard Disc
:
40/80 GB or above
Monitor
:
Samsung(15 inch)
Keyboard
:
108SoftTouch
Mouse
:
Two button with center scroll
4.2
SOFTWARE REQUIREMENTS
Languages used
:
Visual Basic 6.0
Platform
:
Windows
Database
:
Microsoft Data Access
4.2.1 OPERATING SYSTEM
An operating system (OS) is an integrated set of programs that is used to manage the various resources and overall operations of a computer system are a master control program that runs the computer acts as a scheduler. It controls a flow of signals‟ from CPU to various parts of the computer .It is the first program loaded into the computer‟s memory after the computer is switched un popular operating systems includes MS –DOS , Windows , UNIX and OS2.
Cybo Tech Computers
8
Inventory Control System
WINDOWS XP
Windows XP is an operating system introduced by Microsoft Corporation. Windows is multitasking; multi-threading Graphical User Interface (GUI) environment that runs on MS-DOS based computers. Windows provides a standard interface based on dropdown menus , Window region on the screen and pointing devices such as mouse programs must be specially designed to take advantages‟ of these features . Mouse is a pointing device
GUI (Graphical User Interface)
Isa graphic based user interface that allows users to select files, programs or commands by pointing to pictorial representation as the serene rather than by typing long. Complex commands from a command prompt. Applications executing window using consistent set of pull-down menus, dialog boxes and rather graphical elements. This consistency among interface element is a major benefit user .GUI„s have emerged for most computing environments.
Multitasking and Multithreading
Windows XP lets to do more than one task at one time by using a preemptive multitasking scheme. Window XP is a preemptive mutiny tasking lets the CPU manage its own time
Devices Independent Program:
Windows lets you write device independent program. You don‟t have to concern yourself with what type of printer, mouse, monitor, keyboard, sound card, CD –ROM, drive or other devices user own.
Standard User –Interface:
This mechanism is the same for all Windows application. Without reading your application, your users know how to execute your application; they can use the icon on the corner of the application Windows to minimize the Window.
Cybo Tech Computers
9
Inventory Control System
The windows XP environment is a boon for users of DOS. An operating system is a set of software tools designed to make it easy for people and programs to make to optimum use of the computer .People who use computers have different levels of needs and interests. These people can be separated into two groups: Administrator and Clients.
Windows XP is currently the most popular operating system PC, consequently almost all vendors ship their PCs with a mouse and windows operating system already installed.
4.2.2 Platform-MS Windows XP
MS Windows XP is a 32-bit Graphical User Interface (GUI) operating system developed by the Microsoft Corporation. It uses pre-emptive multitasking and multithreading, to perform several actions at the same time. The advantages are user friendly environment, faster, Recycle Bin-a place that stores the deleted files which can be cleared later and the inbox which can be used for communication like fax, E-mail etc. Also Windows supports long file names, cut and paste etc. There are different versions of MS Windows. The most popular are:
MS Windows 95/98/2000 MS Windows NT
Visual Basic 6.0
Visual basic is a Windows based event driven programming language that has been developed at Microsoft Corporation. It is one of the Rapid Application Development (RAD) tools as it enables the programmer to develop Windows based applications very easily and quickly. It includes all the necessary extensions to produce Windows based programs. Visual Basic applications are very popular as front-end to many Client/Server database systems like SQL Server, Oracle, MS Access etc. The main features of Visual Basic include:
₃ Event driven programming language, easy to learn and use
₃ Provides graphical user interface
Cybo Tech Computers
10
Inventory Control System
₃ It has built in application setup wizard that can be used to write setup programs
₃ It supports multithreading, Dynamic Data Exchanges (DDE), and Object Linking and Embedding (OLE)
₃ It highly suited for front-end programming
₃ Forms can be designed to suit any GUI requirement; controls are drawn on the form to enhance user interaction, in built facilities to design menus
₃ Database creation and database connectivity tools
₃ The ability to create pop-up menus anywhere in the application
₃ Provides collections of commonly used dialog boxes
₃ Executable file creation is very easy
The programming terminology used in Visual basic includes:
₃ Forms
Forms are the basic objects used in Visual Basic application development. It is a window, initially blank, on which controls are placed to create the screen display. Forms are saved in the disk as a file with the extension “frm”.
₃ Controls
Controls are the building blocks of a Visual Basic application which are used to display text on the screen, accept inputs etc. Some examples are Label, Textbox, Frame, and Command Button.
₃ Module
Code in Visual Basic is stored in modules. There are three kinds of modules: Class Modules, Form Modules and Standard Modules.
Form Module: Contains form level declarations of type constants, variables and external procedures, procedures that handle events and general procedures.
Class Modules: Class modules (.CLS extension) are foundation of object oriented programming in VB.
Cybo Tech Computers
11
Inventory Control System
Standard Modules: Standard Modules (.BAS extension) are containers for procedures and declarations, commonly used by other parts of an application.
₃ Project
The project is the file in which all the form files (*.frm files) and the modules that make up the entire application is kept.
₃ Procedures
Programming task can be simplified by breaking programs into smaller logical components. These components are called procedures. A procedure in VB can be a Sub, Function, or Property procedure.
Relational Database Management System
A relational database management system consists of a collection of tables, each of which is assigned a unique name. Each table has a structure similar to E-R database by tables. A row in a table represents a relationship among a set of correspondence between the concepts of relation, from which the relational data model takes its name.
A modern DBMS acts as an interface between the physical storage and logical representation of data. In practice, it provides a set of flexible and sophisticated tools for handling information. We can see these tools to
₃ Define a database
₃ Query a database
₃ Add, edit and delete data
₃ Modify structure of database
₃ Secure data from public access
₃ Communicate within networks
₃ Export and import data
Because it gives so much control over data, a RDBMS can also serve as the foundation for products that generate applications and generate data.
About Microsoft Access
Microsoft Access is a database management system or DBMS. As the name implies, a DBMS helps you to manage data that‟s stored in a computer database. If you
Cybo Tech Computers
12
Inventory Control System
want the flexibility to display, print and analyze your information in whatever format you wish, you first need to break down that information into small unit of data. After breaking the information into discrete units of data, you can use a database management system, such as Access, to analyze and present that data any way you wish.
In Access, you must break all your information into data that‟s stored in tables. A table is just a collection of data that‟s organized into rows and column. You can put any information that‟s available to you into a table.
Access act as database. Database is a collection of tables. Table is collection of rows and columns. Database management programs are designed to store, manipulate and report large volume of information created by other offices and windows programs. You can insert excel spreadsheet documents directly into an access table.
The ease and flexibility of doing this is impressive. For example, you can cut a portion of a document created by another program and then paste it into an access table. Or, you may prefer to “drag and drop” part of one d ocument into another using your mouse. Finally, you may simply import one kind of document into another.
Cybo Tech Computers
13
Inventory Control System
5. SYSTEM DESIGN
5.1 INTRODUCTION
Design is the first phase in the development phase for any engineered product of system. Design is a creative process. A good design is the key to effective system. the term “Design “is defined as “ the process of a system in sufficient details‟ to permit its physical realization “ it may be defined as the process of applying various techniques and principles for the purpose for defining a device , a process or a system in sufficient detail to permit its physical realization . Soft ware design sits at the technical kernel of soft ware engineering process and is applied regardless of the development paradigm that is used.
From a project management point of you, software design is conducted in to steps. Preliminary design is concerned with the transformations of requirements to the architectural representation that lead to details algorithm data structure and representation of software
In system design high –end decisions are takrn reg arding the basic system architecture, platforms and tools to be used in the system design transforms a logical representation of what a given system is required to be in physical specification. Design starts with the system requirement specification and converts it to physical reality during the development. Important design factors such as reliability, response time, throughput of the system, maintainability, expandability etc should be taken into account
Cybo Tech Computers
14
Inventory Control System
5.2 INPUT DESIGN
The collection of input data is the most expensive part of the system in terms of the equipment used and the number of people involved .In input design , data is accept for computer processing and input into the system is done through mapping via some map support or links
In this project user interphase is done using highly flexible and efficient input design. Input design is the process of converting user inputs into computer- based format.
5.3 OUTPUT DESIGN
Out puts are the most important and direct source of information to the user of the computer system that needs to transmit a secure data. To convey data securely and to the intended recipient, output designs help to display any transmission errors, data loses.
5.4 SYSTEM FLOW DIAGRAM
This section explains the design and architecture of the software and provides a through overview of the process that takes place in the software. The following figure shows the overall modules present in this application.
Cybo Tech Computers
15
Inventory Control System
SYSTEM FLOW DIAGRAM
User
Home
login
Start
Stock Details
Result
Help
Exit
5.5 DATA FLOW DIAGRAM
LEVEL 1:
Login Tab
User id
Password
User
Login
Stock Detail
Checking
Cybo Tech Computers
16
Inventory Control System
LEVEL 2:
Login Tab
User id
Password
Administrator
Login
Add
Checking
5.6 TABLES
Table 1:
The table 1 is used to store the questions which are to be displayed in the normal level. This table consists of five fields. They are the serial number, question, the four choices for the question and the correct answer.
Field
Data type
Description
Name
SL NO
int
Serial number
Q
Varchar(50)
name
C1
Varchar(10)
Choice1
C2
Varchar(10)
Choice 2
C3
Varchar(10)
Choice 3
C4
Varchar(10)
Choice 4
A
Varchar(10)
Correct Choice
Table 2:
The table 2 is used to store the questions which are to be displayed in the medium level. This table consists of five fields. They are the serial number, question, the four choices for the question and the correct answer.
Cybo Tech Computers
17
Inventory Control System
Field
Data type
Description
Name
SL NO
int
Serial number
Q
Varchar(50)
Question
C1
Varchar(10)
Choice number 1
C2
Varchar(10)
Choice number 2
C3
Varchar(10)
Choice number 3
C4
Varchar(10)
Choice number 4
A
Varchar(10)
Correct Choice
Table 3:
The table 3 is used to store the question which is to be displayed in the standard
level. This table consists of five fields. They are the serial number, question, the four
choices for the question and the correct answer.
Field
Data type
Description
Name
SL NO
int
Serial number
Q
Varchar(50)
Question
C1
Varchar(10)
Choice number 1
C2
Varchar(10)
Choice number 2
C3
Varchar(10)
Choice number 3
C4
Varchar(10)
Choice number 4
A
Varchar(10)
Correct Choice
Table 4:
The table 4 stores the name of the user. This table consists of only one field that is the
name of the user.
Field Name
Data type
Description
Name
Varchar(10)
Name of the
user
Table 5:
This table stores the scores of every user. This table consists of only one field that
is the score of the user.
Field Name
Data type
Description
Score
int
List of the user
Cybo Tech Computers
18
Inventory Control System
6. SYSTEM TESTING AND
IMPLEMENTATION
6.1 SYSTEM TESTING
System testing is a critical aspect of Software Quality Assurance and represents the ultimate review of specification, design and coding. Testing is a process of executing a program with the intent of finding an error. A good test is one that has a probability of finding an as yet undiscovered error. The purpose of testing is to identify and correct bugs in the developed system. Nothing is complete without testing. Testing is the vital to the success of the system.
In the code testing the logic of the developed system is tested. For this every module of the program is executed to find an error. To perform specification test, the examination of the specifications stating what the program should do and how it should perform under various conditions.
Unit testing focuses first on the modules in the proposed system to locate errors. This enables to detect errors in the coding and logic that are contained within that module alone. Those resulting from the interaction between modules are initially avoided. In unit testing step each module has to be checked separately.
System testing does not test the software as a whole, but rather than integration of each module in the system. The primary concern is the compatibility of individual modules. One has to find areas where modules have been designed with different specifications of data lengths, type and data element name.
Testing and validation are the most important steps after the implementation of the developed system. The system testing is performed to ensure that there are no errors in the implemented system.
Cybo Tech Computers
19
Inventory Control System
Validation refers to the process of using the new software for the developed system in a live environment i.e., new software inside the organization, in order to find out the errors. The validation phase reveals the failures and the bugs in the developed system. It will be come to know about the practical difficulties the system faces when operated in the true environment. By testing the code of the implemented software, the logic of the program can be examined. A specification test is conducted to check whether the specifications stating the program are performing under various conditions.
Software testing is a critical element of software quality assurance and represents the ultimate review of specification, design, and coding. Testing includes verification of the basic logic of each program and verification that the entire system works properly. The programs facilitate testing by coding as clearly as possible. Test case design focuses on a set of techniques for the creation of test cases that meet overall testing objectives.
The following are the important steps in testing
i) Testing is a process of executing a program with the intent of finding an error.
ii) A good test case is one that has a high probability of finding an undiscovered error.
iii) Constructing the test data for the program.
iv) Analysis of result to delete a program error.
v) Localization of errors and modification of program to eliminate them.
The testing process focus on the logical intervals of the software, ensuring that all statements have been tested and on the functional intervals that is conduction test to uncover errors and ensure that defined input will produce actual results that agree with the required results.
Program level testing, module level testing, and integration testing are carried out successfully. After this acceptance testing was carried out. In it, issues like performance, user friendliness etc were tested.
Cybo Tech Computers
20
Inventory Control System
The data has been prepared for the above tests and detailed test plans were drawn at each stage of testing. Apart from these tests, there are some special tests conducted which are given below:
Peak Load Tests:-
This determines whether the new system will handle the volume of activities when the system is at the peak of its processing demand. The test has revealed that the new software for the agency is capable of handling the demands at the peak time.
Storage Testing:-
This determines the capacity of the new system to store transaction data on a disk or on other files. The proposed software has the required storage space available, because of the use of a number of hard disks.
Performance Time Testing:-
This test determines the length of the time used by the system to process transaction data. The newly designed system should be in the working order but in reality, each should work independently. Now is the time to pull all into one system and test it to determine whether it meets the user requirements. System testing is executing a program to check logic changes made in it and with the intention of finding errors-making the program fail.
Integration Testing
Integration testing is a systematic technique for constructing the program structure, while at the same time conducting test to uncover errors associated with interfacing. In other words, integration testing is the complete testing of the set of modules which makes up the product, using the previously unit tested modules to construct a product. As integration testing is conducted, the tester should identify critical modules.
Form Testing
The following tests were made on the design for data entry will be window open properly based on button based commands
Is all objects contained within the window properly navigable with the mouse and keyboard?
Cybo Tech Computers
21
Inventory Control System
Does the window properly regenerate when it is overwritten and then recalled? Are all relevant pull down menus, tool bars, dialog boxes, icon and other controls available and properly displayed for the window? When multiple windows are displayed, is the window name properly represented? Is the active window properly highlighted? Do multiple or incorrect mouse clicks cause unexpected side effects? Does the window properly close?
Validation Testing
Validation succeeds when the software functions in a manner that can be reasonably expected by the customer. Software validation is achieved through a series of tests that demonstrates conformity with requirements. Once the application was made free of all logical and interface errors, validation checking was done by inputting dummy data to ensure that the software developed satisfied all the requirements of the user. A test case is a set of data that the system process or normal input.
There are two major types:
₃ Black Box Testing.
₃ White Box Testing.
Black Box Testing:
Black-box testing focuses on the functional requirements of the software. That is, black-box checking enables the software engineer to derive a set of input conditions that will fully exercise all functional requirements for a program.
Black-box testing is not an alternative to white-box techniques. Rather, it is complementary approach that is likely to uncover a different class of errors than white-box methods.
Black-box testing attempts to find errors in the following categories:
1. Incorrect or missing functions.
2. Interface errors.
3. Performance in data structures or external data base access.
4. Performance errors.
5. Initialization and termination errors.
Cybo Tech Computers
22
Inventory Control System
All the above-mentioned errors were checked in the process of black box testing and the bugs were fixed.
White Box Testing
White box testing, sometimes called “glass-box test ing”, is a test case design uses the control structure of the procedural design to derive test case. Using white box checking methods, the following tests were made the system:
1. All independent paths within a module have been exercised at least once.
2. All logical decisions were checked for the truth and falsity of the values. Every if structure was checked giving different values. So that the condition has both true and false values, in order to cover both the results and to check the validity of the system.
3. All loops were executed to check their boundary values. This checking was carried out by the system on do while and for loops and bugs were fixed.
4. Internal data-structure was tested for their validity. In our system, checks were made on the data structures: to ensure that variables handle any type of data type variant data types variables were checked for their capacity.
User Interface Testing
The interface between the end user and the software was developed so as to be convenient and easy for the user. Each screen involved in the system has been designed to facilitate easy usage by the user. Thus user interface testing is conducted and it is no exaggeration that the software was able to satisfy the users.
PROGRAM TESTING
Before implementation, the designed system should be tested with row data to ensure that all modules of the system were tested using the following strategies
Unit testing System testing
Unit testing :
Each of the modules were developed and tested independently and where the following considerations were made :-
The module interface tested to check the flow of information.
Cybo Tech Computers
23
Inventory Control System
Boundary conditions are tested. All error-handling paths are checked.
System testing :
Integration testing was done to variety the co-existence of the modules and the forms involved. Bottom-up integration strategy was used. After the unit testing they were integrated from bottom to up by combining the clusters. Finally, when all the modules were developed and integrated, they were tested with the data, which were provided by some individuals as well as the members involved in visualizing this concept.
6.2 SYSTEM IMPLEMENTATION
System implementation is the important stage of the project when the theoretical design is turn into practical system.
The main stages in the implementation are turn into practical system are.
₃ Planning
₃ Training
₃ System Testing
₃ Maintenance
Planning
When implementation is concerned planning plays an important role. The implementation of any system will have to face any practical problems of controlling various activities of people outside their own data processing department. The active co-operation of different users will be essential for successful implementation.
Training
For successful implementation, trained computer staffs are essential. So, we have to select some staffs for the organization and each of them should be trained to use the implemented system.
Cybo Tech Computers
24
Inventory Control System
Maintenance
The next stage is system maintenance. While security modules is specially designed to avoid unauthorized users entering into the system. In this system we provide two level securities. First security for entering into the main module. From this module, we provided second level security to enter into each module. System maintenance is the general process of changing a system after it has been delivered. There are three different types of software maintenance.
Maintenance to repair software faults. Maintenance to adapt the software to a different operating environment. Maintenance to add or modify the system‟s functionality.
Maintenance processes vary considerably depending on the type of software being maintained, the development processes used in an organization and the people involved in the process. At an abstract level all maintenance processes have the aim fundamentals activities of change analysis, release planning, system implementation and releasing a system to customer.
The maintenance process is triggered by a set of change requests from system users, management of logged users
Cybo Tech Computers
25
Inventory Control System
7.SYSTEM MAINTENANCE
The maintenance phase of the software cycle is the time in which software products perform useful work. After a system is successfully implemented, it should be maintained in a proper manner. System maintenance is an important aspect in the software development life cycle. The system maintenance is for it to make adaptable to the changes in the environment. There may be social, technical and other environmental changes, which affect the systems behavior.
Software product enhancements may involve providing new functional capabilities improving use displays and mode of interaction, upgrading the performance characteristic of the system. So only through proper system maintenance procedures, the system can be adapted to come up with these changes.
The first maintenance activity occurs because it is unreasonable to assume that testing will uncover all latent errors in a large software system. During the use of any large program errors will occur and be reported to the developer. The process that includes the diagnosis and connection of one or more errors is called corrective maintenance. The second activity that contributes to a definition of maintenance occurs because rapid change that is encountered in every aspect computing. Therefore adaptive maintenance is an active that modifies software to properly interface with a changing environment is both necessary and commonplace.
The third activity that may be applied to the definition of maintenance occurs when a software package is successful. As the software is used, recommendations for new capabilities, modification for existing functions and general enhancement are received from the users. To satisfy request in this category, prefecture maintenance is performed.
The fourth maintenance activity occurs when the software is changed to improve future maintability or reliability or to provide better basics for future enhancements. This project being on the client and server side, maintenance will be required on both sides. When the server is being maintained, the whole part of the system may temporarily become unavailable to the client.
Cybo Tech Computers
26
Inventory Control System
8. SCREEN LAYOUT
Cybo Tech Computers
27
Inventory Control System
9. SOURCE CODE
Dim username As String
Dim password As String
Dim address As String
Private Sub Command1_Click()
Data1.Recordset.MoveFirst
i = 0
Do Until Data1.Recordset.EOF = True
If Text1.Text = Data1.Recordset.Fields(0) Then
If Text2.Text = Data1.Recordset.Fields(1) Then
i = 1
Form2.Show
Me.Hide
Exit Do
End If
End If
Data1.Recordset.MoveNext
Loop
If i = 0 Then
MsgBox ("Enter the correct username and password..")
End If
End Sub
Private Sub Command2_Click()
Form1.Height = 7830
Label1(1).Visible = True
Label2(1).Visible = True
Label2(2).Visible = True
Label2(3).Visible = True
Label3.Visible = True
Text3.Visible = True
Text4.Visible = True
Text5.Visible = True
Text6.Visible = True
Command3.Visible = True
Data1.Recordset.MoveLast
Data1.Recordset.AddNew
End Sub
Cybo Tech Computers
28
Inventory Control System
Private Sub Command3_Click()
If Text3.Text <> Null And Text4.Text <> Null And Text5.Text <> Null And Text6.Text <> Null Then
If Text4.Text = Text5.Text Then
Data1.Recordset.Update
Form1.Height = 3240
Label1(1).Visible = False
Label2(1).Visible = False
Label2(2).Visible = False
Label2(3).Visible = False
Label3.Visible = False
Text3.Visible = False
Text4.Visible = False
Text5.Visible = False
Text6.Visible = False
Command3.Visible = False
MsgBox ("User created")
Else
MsgBox ("Enter the correct password..")
End If
Else
MsgBox ("Fill all the boxes")
End If
End Sub
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call Command1_Click
End If
End Sub
Private Sub Text2_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call Command1_Click
End If
End Sub
Dim sets As Boolean
Cybo Tech Computers
29
Inventory Control System
Dim prod, meas As String
Dim quan, price, total As Integer Private Sub Command1_Click() Dim str As String
str = "\t..Your Bil..\nProduct: " + prod + "\nQuantity: " + quan + " " + meas + "\nPrice: " + price + "*" + quan + "=" + total
Data1.Recordset.MoveFirst End Sub
Private Sub Command2_Click()
If Not Data1.Recordset.BOF Then
Data1.Recordset.MovePrevious
If Data1.Recordset.BOF Then
Data1.Recordset.MoveNext
End If
End If
End Sub
Private Sub Command3_Click()
If Not Data1.Recordset.EOF Then
Data1.Recordset.MoveNext
If Data1.Recordset.EOF Then
Data1.Recordset.MovePrevious
End If
End If
End Sub
Private Sub Command4_Click()
Data1.Recordset.MoveLast
End Sub
Private Sub Command5_Click() Data1.Recordset.MoveLast Data1.Recordset.AddNew reenter:
Text1.Text = InputBox("Enter product name:") If Text1.Text = "" Then
MsgBox ("Enter the item name properly..") GoTo reenter
End If reenter1:
Text2.Text = InputBox("Enter Available stock:") If Text1.Text = "" Then
MsgBox ("Enter the available stock properly..") GoTo reenter1
End If reenter2:
Cybo Tech Computers
30
Inventory Control System
Text3.Text = InputBox("Enter Quantity:") If Text1.Text = "" Then
MsgBox ("Enter the Quantity properly..") GoTo reenter2
End If reenter3:
Text4.Text = InputBox("Enter price:") If Text1.Text = "" Then
MsgBox ("Enter the price properly..") GoTo reenter3
End If Data1.Recordset.Update
c = MsgBox("New product is added successfully..", vbOKOnly) End Sub
Private Sub Command6_Click() If sets = True Then Text1.Enabled = True Text2.Enabled = True Text3.Enabled = True Text4.Enabled = True Command6.Caption = "OK" End If
If sets = False Then Data1.Recordset.Edit Data1.Recordset.MoveFirst Text1.Enabled = False Text2.Enabled = False Text3.Enabled = False Text4.Enabled = False
Command6.Caption = "Update Stock" End If
sets = Not (sets)
End Sub
Private Sub Command7_Click()
Data1.Recordset.Delete
Data1.Recordset.MoveFirst
End Sub
Private Sub Command8_Click()
Dim avail As Integer
Dim str As String
quan = 0
prod = Text1.Text
Cybo Tech Computers
31
Inventory Control System
price = Val(Text4.Text)
enterAgain:
quan = InputBox("How much you want to buy..?", prod)
If (Not IsNumeric(quan)) Or quan = "" Then
MsgBox ("Enter the value properly..")
GoTo enterAgain
End If
avail = Val(Text2.Text) If avail < quan Then
i = MsgBox("These much stock not available.." & vbCrLf & "Do you want to re enter quantity..?", vbYesNo, "Less stock")
If i = vbYes Then GoTo enterAgain Else
quan = 0 price = 0 End If End If
Text2.Text = avail - quan meas = Text3.Text
total = quan * price
skip:
MsgBox ("***Your bill is here***" & vbCrLf & "--------------------------" & vbCrLf & "
Item : " & prod & vbCrLf & " Quantity : " & quan & vbCrLf & "--------------------------" &
vbCrLf & "Total price : " & quan & "*" & price & "=" & total)
'MsgBox ("you have to pay ")
Data1.Recordset.Edit
Data1.Recordset.MoveFirst
End Sub
Private Sub Form_Load()
sets = True
End Sub
Private Sub Form_Unload(Cancel As Integer)
End
End Sub
Cybo Tech Computers
32
Inventory Control System
10. ADVANTAGES
Advanteges
Easily navigate through the available items. The updation of stock can be made easily. Authentication is provided User friendly options are provided Administrator can add questions Administrator can view the score of each user Levels are independent Software complexity is reduced Total redundancy is avoided
Disadvantages
Searching for an item is difficult, if more items are there. Only one user can operate at a time. Only one database is used for data storage.
Cybo Tech Computers
33
Inventory Control System
11.FUTURE ENHANCEMENT
This project can be developed into a web based one and can be accessed from anywhere anytime, so that more than one user can take it. Also this project can be implemented in a network for adding certain features to it.
Can develop into a web based one. Much Authentication can be provided Barcode reader can be included for identify the item, so that the security become high. Develop the system so that multiple users can use it.
Cybo Tech Computers
34
Inventory Control System
12.BIBLIOGRAPHY
₃ Vikas Gupta , Net Programming , Comdex Computer Publishing.
₃ Cem Kaner, Jack Falk, Hung Quoc Nguyen , Testing Computer Software , Comdex Computer Publishing; Second Edition.
₃ Roger S. Pressman, Software Engineering A Practitioner‟s Approach Mc Graw Hill Companies Inc;5th edition- 2001.
Websites
₃ http:// www.google.com
₃ http://www.howstuffs.com
₃ http://www.quizquestions.com
₃ http://www.vb.com
₃ http://codeproject.com
Cybo Tech Computers
No comments:
Post a Comment