Stock Inventory System For The Garment Industry 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.

The main menu has eleven major modules. And each module consists of several sub modules. The system can be installed locally on your own computer, or it can be installed on the network if you want to share it with others. That is this works in a Total Visual Basic Database Environment.

The aim of the project is to modify the existing, manual system to an efficient computerized system. The primary reason for implementing an automated system is to provide an up to date service for the customers and expand the current share by over coming the ever-increasing load of work. The productivity of the employees also will be improved.

Special attention is given for the security of the database. To avoid unauthorized access, special locks are implemented for the transaction details of items, and provide a back up system. So that the data will still be available even at a time of failure in the main system, which would allow the daily operations to be carried out smoothly

This is also aimed at providing flexibility and freedom to the end user while attracting the customer to provide minimal information from their part.

The final Role that is wished to be fulfilled taking in to account all the above mentioned facts is to provide a system which saves time and increase both efficiency and performance.

Operations of Order Proccess:

Once customers submit the Purchase Order forms to Accounts department they will be send it Stock\Warehouse to check whether they have enough materials for the production if not the stock will inform to the Accounts Department that they are less of materials

Operations of Stock Department:

The Stock will store the materials for the production and once the factory needs the materials the stock will transfer the materials through Transport Department. To the production, if the Stock is less, then the stock keeper will inform to the Accounts Department that they are out of stock.

Operations of Production department:

Once the materials has been issued from the Stock the production will be begin Or if there are over Flows of the current materials the stock will be return to the Quality factor and re order a new stock, Once the Production has been completed the end product will be Stored in the Ware-House

Operations of Accounts department:

Once the Production has been sent to the stock, the Stock will give Production details to the Accounts Dept. then the Accounts Dept. will inform the Customer and Issue the Products. The Customer will do the Necessary Payments for the Production

The Products manufactured within the Factory are stored in the Ware-House for Stockiest Order. The Stockiest places goods order to the sales department notifies about the goods order to the accounts department then accounts department analyze it and prepare and place the invoice to the warehouse. Warehouse is the place where the stocks are stored. Then warehouse send the required products to the stockiest through the sales department.

If there are damage goods that the stockiest received, then the stockiest returns the damage to the warehouse through the sales department. Sales department notifies to the account department then the accounts department values them and prepares another invoice to the relevant products or provides the money to the bank. Stockiest pays the credit by chq through the mode of bank

ADMIN LOGIN MODULE

This is the module which gives rights to each employee to access the modules. The user can access this module by typing the specific user name and the pass word. This will be the starting point for all of the work done within the program. This menu consist of

Username

Password

From the information stored in the above module the user of each department obtains the right to access the Main Module. From this module the saved user can also modify the details saved as well as the information of a particular user can be deleted

USER \ ADMIN MODULE

User requests

Access

System User

Results

Results

Main System

User

Login Modulebd05515_

As shown in figure, User Login Module acts as the central access point available for the system users to communicate with the system. The interface of the system has to be designed in a very user-friendly manner in order to cater for the requirements of wide range of users. Special consideration was given when selecting titles of the Forms to ensure that the users clearly understand the functionalities of the system

USER AUTHENTICATION MODULE

MAIN

INTERFACE

Database Results

Validated Results

Authenticate Module

User Detailsbd05515_

Database

As shown in the above diagram, this module queries the user information from database to validate whether the User Name already exists in the database. If so, the new user would be requested to enter a new User Name.

Other Modules of the System

Authentication

User Login of the System

System User

MAIN

SCREEN

Database

Authenticate Modulebd05515_

A filtered statement is used to query the database to validate whether the user is valid or not. The user is notified if the authentication information is not valid. Once authenticated the user is considered valid for the entire session.

DATA ENTRY MODULE

User

Data Entry Module

User Interface Modulebd05515_

System User Confirmation Details

All the Applications, Managers Can Access through this module, once the necessary data is entered, this module will produce a confirmation message of entries

DATA VALIDATION MODULE

Validation Module

Accepted Forms/Data

Accept/Reject Status

Database

Scan Databd05515_

System User

Data Entry Module

DATA VALIDATE MODULE

In this module all the entered Data will be validated according to International Standards and Regulations. The acceptance or Rejection of the forms or Data will notify to the User. The Acceptance Forms/Data will store into the database.

REPORT GENERATION MODULE

Request Report

Results

Database

Report

User Interface Module

User Interface Modulebd05515_

This is the key module in the proposed solution as it carries out the producing of reports. Once the user Request a particular report a special query will generated to retrieve data from Database and Place that data into report format and finally display through User Interface Module.

SECURITY MODULE

Assign Privileges

Security Module

Database

This is also major module in the proposed system since it control all the Users access to the database and protect Important data from Unauthorized access or modification. Here all users will get user name and password to access the system. Privileges will assign to users according to their position in the company. A system administrator will be able to get the list of users and monitors their access. And also he/she can add/remove users.

DATABASE DESIGN

The database handles all the database related activities in a transparent manner. A separate database would be created and the information that needs to be manipulated by the system will be stored in the database. There are several tables in the database, which maintain the specific information required by the system.

DFD DIAGRAM

LEVEL 0 DFD

Issue Damages

Stock Inventory System

0

S

Stock

Keeper

T

Transport

Manager

A

Accountant

Stock details

Return Damages

Production details

Damage Products Details

C

Customer

Consumer Products

P

Production

Manager

Stock Movement Report

Invoice Report

Stock Report

Customer Details

Deliver Orders

Consumer products

Raw Materials

Manufactured Details

Placing Orders

LEVEL 1 DFD

Please Refer the Appendix for rest of the DFD

Data Design by Entity Relationship Diagrams

DATA DESIGN

USER LOGIN

ACCSEBILE

USER LOGIN

#User Password

ADMIN

#Admin ID

User Name \ Password

Respective administrators

Stock Inventory System

#Screen Name

DATABASE

ADMINISTRATOR

#Use Creation

Grant access to users

Accessible

Reserve Rights

PASSWORDS PROTECTION

IN

ACCESSIBLBLE

USER LOGIN

#User_password Protected

CUSTOMER ORDER PROCEDURE

STOCK MANAGER

#User_Name

STOCK KEEPER

#Product_Id

PLACING ORDER

#Order

Can be more than One Order

View Existing Stock

Accept Details

Ask For Product Details

Product Details

Validate Stock

VALIDATION

#Vacancy_Id

Accept Order

ACCOUNTS DEPT.

#User_Id

TRANSPORT DEPT.

#Service_Id

Release

Please Refer the Appendix for rest of the Diagrams

Architectural Design by JSP Charts

Customer Orders

Cusdetails

Please Refer the Appendix for rest of the JSP Charts

Procedural Design by Flow Charts

Display "Error message"

N

Y

Display Welcome ScreenFLOW CHARTS

Start

Get Username & Password

End

1

Username = "Admin" & Password = "123456"

6

Display Main Screen

2

2

4

Update user record

Add new user

Get user Details

Y

Choice = "users"

3

N

Display user Screen

5

4

Continue = "Yes"

N

Y

6

5

Please Refer the Appendix for rest of the Flow Charts

Interface Design

C:\Documents and Settings\Administrator\My Documents\pic\untitled.bmp

C:\Documents and Settings\Administrator\My Documents\pic\untitled1.bmp

Please Refer the Appendix for rest of the interfaces

Hardware and Software Requirements

Hardware Requirements:

Workstations: Server:

Processor (PIV 2.0 GHz) Core2Duo 3.2GHz Processor

Hard Disk (80 GB) 120GB hard disk

(RAM) (512 MB) (RAM) (4 GB)

DVD-ROM DVD-ROM

17" LCD Monitor 17" LCD Monitor

CANON Laser Printer Network card

Keyboard with mouse Keyboard with mouse

Software Requirements:

Windows 98 / Windows 2000 / Win XP

Visual Basic 6.0

Microsoft Access 2003

Crystal Report 8.0

Initial New System requirements:

Ultimately Two computer is required for testing purpose, But All Departments that should be linked with the System are must be fully computerized and connected each other through servers

As it supposes to be Using Microsoft SQL Server 2000.\ Enterprise or Personal Edition minimum Software requirements should be installed e.g.; Win NT System that support the SQL Database

All Computers Should Support Minimum Hardware Requirements

Summary

The purpose of the system design is to provide a clear picture of the proposed system. The design of the system has been provided in different graphical formats.

First the proposed system has been described. On this stage detailed description has been provided. Then the system has been described by using DFD diagrams, Entity relation ship diagrams. It has been drawn to display the relationships between the entities. JSP diagrams and Flow charts provide information with different formats.

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.