Development Of Software Inventory Management System Computer Science Essay

Published:

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.

1.3 Innovation

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 :

Time consuming.

Bigger chance of errors.

Boring.

Old fashion.

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

Chapter Two

"Back ground and theory"

2.1 Introduction

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 [4].

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[2]. 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. [2] 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].

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 [3].

Id

NAME

DATE OF BIRTH

SEX

ADDRESS

SUBJECTS

9721001

Subrat Das

21.05.1980

M

C36, Sector 2, Bhubaneswar Orissa

Pol Sc, Eco, History, Eng, Hindi

9721002

Aditya Bhoi

12.06.1981

M

At/Po. Burla, Sambal Pur

Phy, Chem, Biology, Eng, Hindi

9732012

 

Madhu Jain

03.01.1979

F

A31, Pilani, Rajasthan

Pol Sc, Eco, History, Eng, Hindi

9724004

 

Ahmad Ali

23.11.1979

M

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 [3].

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 [1].

2.4.1 Flat-File

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 [4]. 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 [4]. 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. [3]

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 [7]. Figure 2.2 illustrates the Relational Model example.

Relational Model

Activity

Code

Activity

Name

23

Patching

24

Overlay

25

Crack Sealing

Activity

Code

Date

Route No

24

01/12/01

1-95

24

02/08/01

1-66

Date

Activity

Code

Route No.

01/12/01

24

1-95

01/15/01

23

1-495

02/08/01

24

1-66

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 [5]. 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 [5].

Chapter Three

"Methodology and system Design"

3.1 Introduction

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

3.4.1Employee

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.

Employee

ID {PK}

D_ID{fk}

Name

Address

Mobile

Table 3.1: Employee schemata

3.4.2 Department

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.

Department

D_ID{pk}

Name

Table 3.2: Department schemata

3.4.3 Company

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.

Company

Name

D_ID{fk}

Table 3.3: Company schemata

3.4.4 Suppliers

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.

Suppliers

Name

S_ID{Pk}

Table 3.4: Supplier's schemata

3.4.5 ORDER

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.

Order

ID{Pk}

Date

Item_id{fk}

S_ID{fk}

Table 3.5: Order schemata

3.4.6 Item

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.

item

id{pk}

Price

Name

quantity

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.

Employee

ID {PK}

D_ID{fk}

Name

Address

Mobile

integer

integer

character

character

integer

Department

D_ID{pk}

Name

integer

character

Company

D_ID{fk}

Name

integer

character

Suppliers

S_ID{Pk}

Name

integer

character

Order

ID{Pk}

Date

Item_id{fk}

S_ID{fk}

integer

dd/mm/yyyy

integer

integer

Item

id{pk}

Price

Name

quantity

integer

Currency

c integer

character

Table 3.7: Conceptual schema of SIMS

3.6 System Implementation

3.6.1 Introduction

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)

Chapter Four

"Conclusion"

4.1 Introduction

This chapter will discuss the summary, conclusion and recommendation of the.

4.2 Conclusion

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

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.