This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.
Inventory management is very important in every organization because a good inventory management can create optimal productivity and lowest. Basically, inventory management work is consists of input, output and refill. Input is a process of buying new productions into the inventory and replacing the old products with the new ones.
Meanwhile, Output is a procedure of taking out the products from the inventory for sales or usage and refill is process of increasing the number of existing product in the inventory in order to fulfill the insufficient products or escalating demands. Most of the retailing market is using traditional way in the inventory management system where a personal is assigned to check and record the stock by hand using pen and paper. This Technique is time-consuming and unavailable especially when the number of stock in the inventory is larger and various in kinds. In addition, it is also a waste of money in hiring manpower to do stock checking and the risks caused by Careless mistakes done by the stuffs occur. Furthermore, when the entire inventory ordering has to be made manually, it will consume time to contact suppliers and normally the process of ordering is only arranged after the stock is found out empty. Consequently, it will cues sluggish in stock refilling and bring negative effects towards productivity.
Having a good inventory management system is never can't without the computer. Therefore, the project goal is to develop a multifunction system that will facilitate retail market in managing their inventory and stock ordering effectively. The development of Inventory Stock Management System aims to increase the efficiency in stock data function and to manage the inventory effectively by sending the order to supplier when the stock is lacking.
1.2 Background of the Study
The project development of Software Inventory Management System (SIMS) is developed for Software Corporation. It is envisioned that the establishment of an effective database management system.
Innovation is the presentation of new things or methods; the presentation for the problems or deficiencies faced by involved employee by using advancements in technology such as the computer Information Technology (IT). IT plays a significant role in this study. The main purpose that are encountered in using the manual system, which are generally the waste of effort and valuable time.
This could be done by using a high speed, user friendly, highly interactive window based environment that can speed up the process of acquiring and using information. To deliver its peak performance every time , the programming language used is Visual Basic 6.0 that has a more interactive and user-friendly environment also SQL coding to speed up particular parts of the system.
There most important advantage with the systems which is possibility of being update and restructure with the development of technology in the future to embrace new feature .
1.4 Objective of the study
The study based on following objectives as stated below:
The General Objective
The general objective of this study is to develop system that is highly functional with features that are capable to support Software Company in improving the efficiency of transaction processing in areas where technology can dramatically reduce.
The specific Objective
The main objectives of this study are:
To illustrate the existing manual system on acquiring information and the existing filling system that the software company is using at present time.
To identify the problems and weaknesses of the existing system.
To show that the designed system is technically, operationally and economically feasible for implementation.
To eliminate duplicate activates particularly in entering data.
1.5 Hypotheses of the study
The hypotheses of this study are:
The existing system operates in manual acquisition of information through filling up paper forms.
The problems encountered in existing manual system are :
Bigger chance of errors.
Large amount of paper work.
The designed system will :
Maintain information in a well organized manner.
Provide more accurate information.
Provide an interactive environment.
Save time and reduce louse paper work.
The designed system is economically, operationally and technically feasible for implementation.
1.6 Project Outline
This Project is broken into four chapters. Each chapter includes several sections. The remainder of the project is organized in the following way.
Chapter2 presents in detail work related to database and so on. In Chapter 3 presents the methodology of the proposed system and illustrate the implantation part of system. The conclusions and future woke presented in chapter4
"Back ground and theory"
All data with the term often encountered. In fact, unknowingly we come across data in our day to day life every day. The name of a person, price of tomato, number of employee in a work, code of the area, etc. are some examples of data. In our life we have to remember so much of data. But it is easier to remember all information for a few individuals, for example, you may be in a name tell accurately the area, position, color of house, height, permit qualification, residential address, etc. of your close friends. But it is too difficult for you to memorize all these information for a large number of individuals. Let us consider the example of School. Every year about one lake students take admission in school. If you are asked to memories records of date of birth, subjects offered and postal address of all these students, it will not be possible.
To treatment with such difficult we construct a database. We make all information about all area in a tabular form. We store all the records so that if asked, 'How many house are there in statistics? There a position to answer .
2.2 Database Management (DBM)
The Database Management allows programmers to store information as a pair of strings; a key, which is used to find the associated value. Essentially, a DBM adds more functionality and better serration during storage to the binary flat-files that it uses. There are several versions of DBMs available, but the most popular is the Berkley Database Manager; also known as the Berkley DB. The Berkley DB is an improvement over normal flat-files, as it provides a way for programmers to use the database without having to worry about how the data is stored or how to retrieve the values. Retrieval of data using the Berkley DB is often much faster than from a flat-file, with the time savings being made by storing data in a way that speeds up the locating of a specific key-value pair.  Creating, editing and deleting data when using the Berkley DB is actually quite simple; once the database has been tied to the script you just use and manipulate the variables as normal. The problem of file locking that plagues flat-file databases is still apparent when using DBM, so you should still take care when planning scripts that utilize it. .
2.3 What is A DATABASE?
The database is a collection of information is stored in a particular place, a real data such as book numbers and names. Let's look to the example of our information for students and provides a sample of 4 students which will be presented in the table 2.1. Each student has 6 items of information which includes, Id, the name, date of birth, sex, mailing address and the topics provided by the student .
DATE OF BIRTH
C36, Sector 2, Bhubaneswar Orissa
Pol Sc, Eco, History, Eng, Hindi
At/Po. Burla, Sambal Pur
Phy, Chem, Biology, Eng, Hindi
A31, Pilani, Rajasthan
Pol Sc, Eco, History, Eng, Hindi
12A, Sheikh Sarai-I, New Delhi
Phy, Chem, Biology, Eng, Hindi
Table 2.1: The student table.
If you take a close look at all these fields, they are not of the same type. Date of birth is date type whereas Name is character type. In database there can be five categories of fields which include Numeric, Character Logic, Memo, Date. All the related fields for a particular event are called a Record. In the example above, all six fields taken together for a particular student is called a record of that student. Hence, since there are six students, it means that there are six records .
2.4 Database Types
The two main kinds of database are flat-file and relational. The best to use for any job depends on certain factors, namely the amount and type of data which needs processing - and, of course, the frequency of its use .
When attempting to replicate more complex data structures flat-file tends to be complicated. Although it is possible to store complex data in a flat-file database, there is more expense in time and processing power than when using a relational database. Storage of more complex data types can give operators difficulties of readability and editing. The style of this database is well-suited to small amounts of data needing to be operator readable and hand edited . Table 2.2 illustrates the flat file model.
Flat File Model
Route No. Miles Activity
Record 1 1-95 12 Overlay
Record 2 1-495 05 Patching
Record 2 SR-301 33 Crack seal
Table 2.2: Flat file database and Spreadsheet
2.4.2 Relational DATABASE
Relational databases, store data in a logical way. Real world objects can be represented in tables where each field acts as an attribute. So a table entitled 'Books' might have the details of each book: title, author and ISBN in columns, with each row representing a new book . The fact that the tables can be linked to each other causes the 'relation'. In this way cross-referencing of an author with an (assumed) authors table is possible, providing more information on the author. Standard flat-file formats would find it difficult to replicate such relatively complex relations. 
The advantages of using relational model are follows:
Relational model is used to prevent duplication of data
maintaining database integrity,
A variety of functions of retrieving, sorting and editing of data are 'built in' to relational databases . Figure 2.2 illustrates the Relational Model example.
Figure 2.2: Relational Model
The basic data structure of the relational model is the table, where information about a particular entity (say, an employee) is represented in rows (also called topples) and columns . In any relational model, we need to determine a key that will be used to uniquely identify a row. This key is called a primary key. Keys are commonly used to join or combine data from two or more tables .
"Methodology and system Design"
This Chapter deals with the methods of research used, Data Gathering Instrument, Analytical Tools, methods for developing the system, justification of the methods for product evaluation.
3.2 Methods of Research Used
This project used different methods of explore that are significant in the creation of the study.
3.2.1 Descriptive Method: assembly
Descriptive method is a process of assembly analyzing, classifying, tabulating data about prevailing condition and accurate interpretation about such data. This method used to retrieve the phenomenal of the current statue to describe "what exists" with respect to variable or conditions in that situation.
The descriptive method is something beyond just data gathering, it's a method that helped to report the true meaning of data collected from the point of view of the objectives and the basic assumptions of the project underway.
3.2.2 Library Method
Library method is used to support our proposal about Software company stock inventory by taking references of well respected authors. There state out through lots inventory report , previous studies encyclopedias , and search on internet web sites for similar kind of applications and ideas, This method is used to gather information that are helpful in understanding of the existing problem as well as best solution and appropriate software system that will solve the proposed problem .
3.2.3 Creative Method
Creative method is reflective thinking in a situation of easy the tie ideas to design and develop system with new functionalities or features. In this project used this method to apply some creativity in the software which will be useful to simplify procedures. The employed Creative method in the proposed project is applied by using simple programming language such as Visual basic with Access database tried to build the system efficient as much as possible without using complicated technology.
3.2.4 The Experimental Method
Experimentation is the name given of the type of the educational research in which the educators controls the educative factors to which groups are subjected during specific period and observe the resulting achievement.
This experimental method can used to can recognize the suitable way for employee to collect information in the most efficient manner. This can be achieved by training a group of employee to test the provided program and use the new software and get the feedback about the new program in order to generate the results of change.
3.3 ER diagram
This document is an entity relationship diagram (ERD) for a system to manage e-resources. An ERD is a model that identifies the concepts or entities that exist in a system and the relationships between those entities. An ERD is often used as a way to visualize a relational database: each entity represents a database table, and the relationship lines represent the keys in one table that point to specific records in related tables. Figure 3.1 illustrate the ER diagram of the Inventory Stock Management System.
Finger 3.1: ER diagram of Inventory Stock Management System
3.4 Data Requirements and Tables
The employee table has 4 entities includes ID, NAME, ADDRESS AND MOBILE. ID will be the primary key. Tables 3.1 illustrate the schemata of Employee table.
Table 3.1: Employee schemata
The Department table has 2 attributes includes ID, and NAME. ID will be the primary key. Tables 3.2 illustrate the schemata of Department table.
Table 3.2: Department schemata
The company block has 2 attributes includes ID, and NAME. ID will be the primary key. Company entities related with Department, Order and supplier. Tables 3.3 illustrate the schemata of Company table.
Table 3.3: Company schemata
The Suppliers table has 2 attributes include ID, and NAME. ID will be the primary key. Tables 3.4 illustrate the schemata of Suppliers table.
Table 3.4: Supplier's schemata
The Order block has 2 attributes include ID, and DATE. ID will be the primary key. Tables 3.5 illustrate the schemata of Order table.
Table 3.5: Order schemata
The Department table has four attributes include ID, NAME, PRICE and QUANTITY. ID will be the primary key. Item entities related with Order. Tables 3.6 illustrate the schemata of Item table.
Table 3.6: Item schemata
3.5 Conceptual Data Design
The conceptual schema of SIMS presented in Table 3.7. Table 3.7 illustrates the type and the primary key of each table of SIM system.
Table 3.7: Conceptual schema of SIMS
3.6 System Implementation
Inventory management is very important in every organization because a good inventory management can create optimal productivity.
Having a good inventory management system is never can't without the computer. Therefore, the goal is to develop a multifunction system that will facilitate retail market in managing their inventory and stock ordering effectively. System aims to the stock, inventory control for production units. This project mainly includes all cost accounting modules.
The main modules of this product we can add supplier details, stock details, etc. In the Transaction file maintenance.
3.6.2 The implantation of the developed system
The designed to deliver its benefits with a user friendly interface. It consists of a number of frames and screens that will be explained as follows:
3.6.3 Main Screen
This is the main Screen in the Inventory system the user can chose any part from the menu. Figure 3.2 illustrates the main screen of Inventory system.
Figure 3.2: Main screen of the (SIMS)
3.6.4 Current Stock Screen
The Current Stock Screen show all the stock number, Item name, Size of the item and all other information about the Current stock Inventory. Figure 3.3 present the current stock screen of the SIMS.
Figure 3.3: Current Stock screen of the (SIMS)
3.6.5 Employee Master Screen
From this screen the Administration Can Add New Employee by adding his name, number, Address, City and phone. Also he can delete employee or search for an employee. Figure 3.4 illustrate Employee Master Screen window.
Figure 3.4: Employee Master Screen of the (SIMS)
3.6.6 Employee Search Screen
This is the search screen where the admin can search about employee in the company by select his name from a combo box and if find the system will show his Full name, and id number. Figure 3.5 present the Employee Search Screen window.
Figure 3.5: Employee Search Screen of the (SIMS)
3.6.7 New Items Entry Screen
This is the New Item Entry screen where the user can add new item to the entry from this screen by adding the Trans Number and select the name and size of the item from combo boxes also enter open stock , then he can save this new item or deleted it . The New Items Entry Screen window illustrate in figure 3.6.
Figure 3.6: New Items Entry Screen of the (SIMS)
3.6.8 Receives Stock Entry Screen
The user can register the receive stock entry from Receive stock entry screen by selected the name and size of the item from combo box and enter the quantity of the item the name of received employee and the date of receiving the item . Figure 3.7 illustrates the RECEIVE STOCK ENTERY of SIMS.
Figure 3.7: RECEIVE STOCK ENTERY Screen of the (SIMS)
3.6.9 Employee Inventory Screens
THE Employee Inventory report screen prints a report for any employee. Figure3.8 illustrate the process of employee inventory screen window
Figure 3.8: Employee Inventory SCREEN of the (SIMS)
This chapter will discuss the summary, conclusion and recommendation of the.
The main objective of this study as mentioned earlier is to develop and implement SIMS. However, the main features of this model are follows:
The interface of SIM system is characterized by easy and smooth for use by the user.
This system only allows the authorized admin with correct login username and password to access this system.
All data with the term of his own in the system.
Store all the records so easily search for in the system
Provides a way for programmers to use the database without having to worry about how data is stored or how to retrieve values.
4.3 Future Work
This work needs to be incorporated and integrated in future research in order to enhance the capability of this system. To do so, the following steps can be addressed in future research:
Adding online features.
Incorporate Multimedia content to represent the SIM systems' items.
Enhancing SIM system by providing website statistic with graphical tools such as chart.
Enhancing SIM system by providing online help.
Facilitate the provision of research methods in the system and the Internet