Stock Control Management Syestem

Table of Contents
Table of Contents 01
Abstract 03
1) CRAPTER 01
1. Systems Introduction. 03
1.1. Description of the project: 03
Objectives of the system: 03
 General objective 03
 Specific objective 03
1.2. Methodologies for Data Collection: 04
1.2.1. Primary data collection……………………………………………………. 04
1.2.2. Secondary data collection. ..................................................................... 04
1.3. Software Requirement Specification: …………………………….. 04
1.3.1. Introduction................................................................................................ 04
1.3.2. Purpose. ....................................................................................................... 04
1.3.3. Scope. ............................................................................................................ 04
1.3.4. Definitions, Acronyms and Abbreviations...................................... 04
2. Overall Description of the Proposed System: ...................................... 05
2.1. Product Perspective. 05
2.1.1. Interfaces. 05
2.1.2. Hardware Interfaces 05
2.1.3. Software Interfaces 05
2.1.4. Operations 05
2.2. Product Functions 05
2.2.1 Description 06
2.3. User Characteristics 06
2.4. System Features 06
3. Logical Database Requirements. ..............................................................06
4. Software System Attributes. ..............................................................................07
2) CRAPTER 02
 System Design: 07
2.1. Introduction…………………………………………………... 07
 Physical design 07
 Database design 08
2.2. E-R Diagram ……………………………………….………. 09
2.3. Data Dictionary ……………………….…………….……… 09
3) CRAPTER 03
Scope of Improvement, Summary and Conclusion
3.1. Conclusion…………………………………………………….… 10
3.2........................................................................................................Future
enhancements…………………………………..……….. 10
3.3. Limitations……………………………………………..……….. 10
3.4. Bibliography ……………………………………………………. 10
3.5. Web references ………………………………………………… 10

ABSTRACT
 The goal of this project is to develop Stock control database Management
System.
 To get relevant data both primary and secondary data were collected. After
the data collection process ends, it was analyzed by descriptive statistics
like percentage and table.
CRAPTER 01
1. Systems Introduction.
1.1. Description of the project:
Objectives of the system:
 The basic objective of inventory management is to maximize customer
service through maintaining appropriate amount of inventory with
minimum possible costs. Inventory costs are costs associated with
operation of an inventory system.
General objective
 The objective of inventory management is to meet customer needs while
keeping inventory cost at a reasonable level to produce a profit for the
firm. The objective is not simply to reduce cost of ordering and holding
inventory, nor is it just meeting customer demand.
 These two objectives are clearly opposed to each other when considered by
them. To reduce inventory cost, we may simply hold no stock and reorder
only when customer place order. This will result in low inventory cost.
Specific objective
 The specific objectives of the study were:
To know and evaluate cause and effect of under or over stocking of
inventory.
To identify the responsible body to manage inventory.
To know the storage system.
To know cost associated with inventory.
To know the existence of sufficient warehouse.
1.2. Methodologies for Data Collection:
1.1.1. Primary data collection.

 Primary data was collected by questionnaire and interview.
1.1.2. Secondary data collection.
 Secondary data was obtained from published documents and from internet.
1.3. Software Requirement Specification:

1.3.1. Introduction.
 The introduction of the Software Requirements Specification provides an
overview of the entire Software Requirements Specification with purpose,
scope, definitions, acronyms, abbreviations, references and overview of the
Software Requirements Specification.
1.3.2. Purpose.
 The purpose of the document is to collect and analyze all assorted ideas
that have come up to define the system, its requirements with respect to
consumers.
1.3.3. Scope.
 The standard can be used to create software requirements specifications
directly or can be used as a model for defining a organization or project
specific standard. It does not identify any specific method, nomenclature or
tool for preparing an SRS.
1.3.4. Definitions, Acronyms and Abbreviations.

 SDLC stands for software delivery lifecycle.
 SRS stands for Software Requirement Specification.
2. Overall Description of the Proposed System:
2.1. Product Perspective.
2.1.1. Interfaces.
2.1.2. Hardware Interfaces
 Here are some of hardware interface :
RAM: 8 GB or above
Hard Disk: 500 GB or above
Input Devices: Keyboard, Mouse
Processor: Pentium IV and motherboard
Output Devices: Monitor; -14” VGA
Printer: HP laser jet
2.1.3. Software Interfaces
 Here are some software interface of inventory controlling management
Operating System: Windows 7
Microsoft office 2007
Microsoft office Visio 2013
MySQL database
2.2. Product Functions
 Advantage of stock control management system
Increased inventory accuracy
Effective management control
Reduced staffing levels
Reduced equipment usage and related overheads
Provides put away functionality for palletizing. etc
Allows segregation of stock types within a warehouse.
 Disadvantage of stock control management system
Increased master data maintenance.
Additional process step for receipt and picking.
Requires expert knowledge to configure for maximum benefit.
More complex to resolve problems caused by incorrect processing.
2.2.1. Description
 This project records only user and password of the user.
2.3. User Characteristics
Demand (patterns and Characteristic)
Lead team
Review policy
Excess demand
Changing inventory
2.4. System Features

Real time tracking
Advanced sorting and filtering
Mobile accessibility
Bar code scanning
Multiplatform support
Multiple location accessibility
Secured inventory database
Cloud support
Manage sales and purchase orders
Generation of sales and profit reports
E-mail orders
Database management
3. Logical Database Requirements

 Some of Logical Database Requirements and The proposed information
system contain the following data tables in its database collection.
Entity name Relationship

Entity relationship Foreign key
Attribute
4. Software System Attributes
 Software system Attributes are:
Correctness Readability
Reliability Extensibility
Adequacy Testability
Learn ability Efficiency and
Robustness Portability.
Maintainability
CRAPTER 02
2. System Design:
2.1. Introduction
 The goal of the design process is to produce a model that can be used later
to build that system. The produced model is called design of the system.
Physical design
 The physical design of the database specifies the physical configuration of
the database on the storage media. This includes detailed specification

of data elements , data types , indexing options and other parameters residing in
the DBMS data dictionary .
 Some of physical Database design requirements are:
primary key
Foreign key
table name
column name
column data type
Database Physical design
Database design
 Database design is the organization of data according to a Chambers . The
designer determines what data must be stored and how the data elements
interrelate.
 Database design involves classifying data and identifying
interrelationships. This theoretical representation of the data is called
an ontology . The ontology is the theory behind the database's design.
2.1. E-R Diagram
Stock Management System ER Diagram
 This ER (Entity Relationship) Diagram represents the model of Stock
Management System Entity. The entity-relationship diagram of Stock
Management System shows all the visual instrument of database tables and
the relations between Product, Bill, Stock, Store etc.
 It used structure data and to define the relationships between structured
data groups of Stock Management System functionalities. The main entities
of the Stock Management System are purchase order, purchase order detail,
Product master, reciving details, reciving slip and vendor.
ER Diagram For Stock Management System
2.2. Data Dictionary

 Data Dictionary is a simply repositories to store information about all data items.
A data dictionary contains a list of all files in the database, the number of
records in each file, and the names and types of each field. Most database
management systems keep the data dictionary hidden from users to present them
from accidentally destroying its contents.
Reciving table Details
Name- Reciving Details

Name Type Size Description
Reciving ID Integer 25 ID of the Doctor
Purchase order id Varchar 50 ID of the Purchase order
vendor Varchar 150 Vendor of the Reciving
Date of recepit Varchar 90 Date of the recepit
Vendor order number Varchar 100 Vendor of the order number
CRAPTER 03
Scope of Improvement, Summary and Conclusion
3.1. Conclusion
 Inventory management is important for keeping costs down, while meeting
regulations. Supply and demand is a delicate balance, and Inventory
management hopes to ensure that the balance is undisturbed.
 Inventory management system can help to manage inventory well during
business operation.
 Overcome some business problems, like overstock and transaction record.
3.2. Future enhancements
 It has nothing to do with the management of stock management.
3.3. Limitations
 Efficient Inventory management control methods cannot eliminate business
risk.
 The objectives of better sales through improved service to customer,
reduction in inventories to reduce size of investment and reducing cost of
production by smoother production operations are conflicting with each
other.
 The control of inventories is complex because of the many functions it
performs. It should be view as shared responsibilities.
3.4. Bibliography
 Companion site to the book inventory accuracy, people, process and
technology-By David J Piasecki.
3.5. Web references
 https://shsu-ir.tdl.org/shsu ir/bitstream/handle/20.500.11875/1164/0781.pdf?
sequence=1
 https://ieeexplore.ieee.org/document/6208293/
 https://ieeexplore.ieee.org/document/4679917/
Group 2 Members
NO Student Name OBT NUMBER

1 TSEHAYE TAFERE OBT/275/11
2 WENDU GIZAT OBT/276/11
3 MELESE HASAMO OBT/266/11
4 BIRITU GEMEDA OBT/256/11
5 TOYBA AMAN OBT/273/11
6 ANENE TESHOME OBT/253/11

Stock Control Management Syestem

Uploaded by

Copyright:

Available Formats

Stock Control Management Syestem

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Stock Control Management Syestem

Uploaded by

Copyright:

Available Formats

Table of Contents

4. Software System Attributes. ..............................................................................07

2.2. E-R Diagram ……………………………………….………. 09

2.3. Data Dictionary ……………………….…………….……… 09

Scope of Improvement, Summary and Conclusion

3.4. Bibliography ……………………………………………………. 10

3.5. Web references ………………………………………………… 10

1.1.1. Primary data collection.

1.3. Software Requirement Specification:

1.3.4. Definitions, Acronyms and Abbreviations.

2.4. System Features

3. Logical Database Requirements

Entity name Relationship

the database on the storage media. This includes detailed specification

2.2. Data Dictionary

Name- Reciving Details

NO Student Name OBT NUMBER

You might also like