indroduction_sujithra

7/28/2019 Indroduction_Sujithra

1/33

1. INTRODUCTION

The promoter's rich and established experience in the primary cotton ginning

and trading, the pioneer unit of the group, Arini Impex was promoted 1984. In the

shortest postponing unit. The Present Installed capacity of the group is 35,640

spindles and 1,344 rotors.

The group Uniform wholesale shop units were being modernized by

commissioning the state of the art machineries. This has evolved the group to vie in

the international market. Signet group has acquired a position of its own in the

market. The group has diversified its activities in finance and wind energy.

Indigenous and imported machines have been installed and are periodically

updated to state-of-the-art technology. The vast experience an modern machines used

is the base for producing consistent quality of yarn. Arini Impex group has established

an exceptional way of harmony and cordial handshake with the employees. Fair

wages, incentives and a good working environment motivate the work force to work

more force to work more efficiently with PERSONAL involvement.

1


2/33

1.1 ORGANIZATION PROFILE

The pioneer unit of our group was incorporated on June 22, 1985, with an

initial capacity of 500 Workers. The present workers are 5,000 with the average

turnover of 5 Lakhs for year. It's equipped with all the infrastructures well to satisfy

the demands of the customers in time. To take part in the national power generation,

the company has introduced wind energy by installing wind turbine generators.

Indigenous and imported machines have been installed and are periodically

updated to state-of-the-art technology. The vast experience an modern machines used

is the base for producing consistent quality of yarn. V. Periaswamy & Brothers group

has established an exceptional way of harmony and cordial handshake with the

employees. Fair wages, incentives and a good working environment motivate the

work force to work more force to work more efficiently with PERSONAL

involvement.

The group Uniform wholesale shop units were being modernized by

commissioning the state of the art machineries. This has evolved the group to vie in

the international market. Signet group has acquired a position of its own in the

market. The group has diversified its activities in finance and wind energy.

2


3/33

ARINI IMPEX STRENGTH

Product pricing is always competitive because of bulk purchasing power of

raw material at the right season and prices aided by the company's rich

experience in ginning.

Product mix ranging from 100% cotton Grey and Melange yarn, in various

counts as per Customer's requirements.

Flexible manufacturing, convenient at customers.

Effective handling of customer needs and demonstrating unique service to

the customers.

Quality at utmost priority to the requirement of end use of yarn.

Public Limited company, closely held shares.

A corporate group under an experienced management adopting.

FEATURES OF ARINI IMPEX PRIVATE LIMITED

To the variable control chart Then the process Capability is analyzed such that

it is more than 1. This project is done under the Department of Standard Quality

control (SQC) in which products from Various departments are taken and their

qualities are Tested With Respect to the standard weights. Two modules from this

department are taken and their calculations are computerized under this project.

Public Limited company, closely held shares.

A corporate group under an experienced management adopting.

Annual turnover over USS 33 million

3


4/33

2 SYSTEM ENVIRONMENT

2.1 HARDWARE SPECIFICATION

Name of the system : INTEL

Operating System : APPLE

CPU type : Pentium III

Speed : 550MHz

RAM : 54 MB

Hard disk : 30 GB

Printer : HP, MSP 345

Key board : 104 Keys

Visual display type : EGA/VGA

Base memory : 540 K

Extended memory : 118024 K

Cache memory : 200 K

2.2 SOFTWARE SPECIFICATION

Front end Tool : Visual Basic 6.0

Back end Tool: MS Access 7.0

4


5/33

2.3 SOFTWARE FEATURES

FEATURES OF VISUAL BASIC 6.0

GENERAL FEATURES

The Visual Basic 6.0 is a very open environment that supports the Clint/Server

architecture, ActiveX, Component Object Model (COM), and Distributed Component

Object Model (DCOM). It also supports Open Database Connectivity.

Visual Basic 6.0 is GUI product, which runs under MS-Windows

environment. This product comes form the Microsoft Corporation. It is a graphicalclient/server application development environment. It supports client - server

processing. In a client - Server architecture, the client interacts with the user and the

server process data. The client makes request to the server for data using structured

query language.

MS-ACCESS

MS-Access is very useful for accessing the database to create records, deleting

records, modifying records and it is useful for listing records. It is used as back end

tool for the Visual Basic. A database server is the key to solving the problems of

information management.

All this must be accomplished while delivering high performance. A database

server must also prevent unauthorized access provide efficient solution for failure

recovery.

5


6/33

3. SYSTEM STUDY & DESIGN

3.1 EXISTING SYSTEM

The existing system is manual system. So the personal management field

inconvenient in the operations. The present system is completely GUI based, so user

can select the required data by means of combo box, list box etc. this avoids mainly,

entering the data's fully. Manual effort is many required in many cases. The

customer's time is wasted at the time of estimation & bill preparation.

The existing system is done in VISUAL BASIC 6.0 and MS ACCESS 7.0 it

overcomes the disadvantages of the existing system.

Analyzing data is very important in this project, so several reports are

generated for the user to maintain the cotton stock, uniform stock.

Due to advance features, "TEXTILE MANAGEMENT SYSTEM" is

developed in Visual basic 6.0 as front-end tool with MS Access 7.0 as back end tool.

With the inception of this package the company will be benefited in the

following aspects.

1) Party Master gives party name and Party information like, who are supplying

the Raw materials, lead-time are maintained.

2) Material stocks can be maintained based on the daily issues.

3) Raw materials in the company.

4) The periodical report helps the company to know about stock of the rawmaterials in the company.

5) The Stock makes as easy calculation and accurate checking on availability of

the Bales.

Once the system is studied well and designed properly, coding can be done

much easily. In this project, various intrinsic and extrinsic controls of Visual Basic

has been used. The various controls and their functions are

6


7/33

Label box:

Labels are used to display the caption we enter. This is done by typing the text

we want in its CAPTION property.

Text box:

It is used to enter or display text. It can display upto 2048 characters in it. Its

maximum length is set according to the context. Various methods are writer in its Got

focus, lost focus and Key press events.

Option:

The option buttons are used with its text property to display the name we want

them to display. In the option buttons, only one of them can be selected.

Command button:

The command buttons can be placed anywhere in the form. The text property

of it used to enter the name that is has to display. The size of the command button canbe changed.

MS Flexgrid:

MS Flexgrid is the control added by selecting the component Microsoft

flexgrid control 6.0. It has the set of rows and columns in it. The number of rows and

columns can be added to it. Its index starts from 0. It is used to display contents in a

table format.

Caption:

This property is used to display the name in the screen. The Caption of the

control is typed in and are displayed. The font that we need can be selected from Font

style.

7


8/33

Border style:

There are several border style found in VB. We select the border style as 1-

single border style which displays single border line. The border style is selected for

all the controls used in the form.

Max length:

This can be set to the length which we want a particular control to have. The

control then accepts only the length we set to it. After that, the control will no accept

characters and gives a beep sound.

Auto size:

This property when set true, automatically aligns the border according to the

size of text that has been typed in the control. It is mainly used in table box control.

Open:

This is mainly used in connection of front end with back end.

Cursor location:

The cursor location of the database can be set. It is always set to aduse client

since we want the cursor to move both backward and forward.

Update:

This command is used to update a record in the table. The modifications that

are done in a record in front end can be saved in back end in the table using update

command.

Delete:

This command is used to delete a record in the table. The record once deleted,

no longer exists in the table. The records are mainly deleted based on some criteria.

8


9/33

DRAWBACKS OF THE SYSTEM

The drawbacks

Manual work.

Security of information is low.

Calculations are difficult.

Time taken is large.

Errors occur frequently.

Occupies more resources.

Needs a lot of Manpower.

9


10/33

3.2 SYSTEM DESIGN

System design based on two types of design

1. Logical Design

2. Physical Design

3.2.1. Logical Design

Logical Design is a web design and virtual assistance company providing

business support services from website design and email marketing to administrative

services and desktop publishing. The reliability, flexibility and variety of services we

offer saves you time, money and increases productivity.

This is of three types:

1. Contexts Analysis Diagram

2. Data Flow Diagram

3. Entity Relationship Diagram

10


11/33

Logical design of Textile Management System:

Figure 3.2.1.

11


12/33

3.2.1.1. Contexts Analysis Diagram:

The context analysis diagram has data flows, entities and only process. It

depicts the entire flow of the system along with its input and output.

Figure 3.2.1.1

12

Textile

Management

System

Customer

Suppliers

Management

Employee

Customer details

Other details

Supplier details

Item details

Employee details


13/33

3.2.1.2 Data Flow Diagram

Data flow diagrams (DFD) are the part of the SSADM method (Structured

Systems Analysis and Design Methodology), intended for analysis and information

systems projection. Data flow diagrams are intended for graphical representation of

data flows in the information system and for analysis of data processing during the

structural projection

Level 0 Customer Details

Level 1 Supplier Details

Level 2 Supplier Invoice Details

13

Validate

Customer DetailsCustomer

CustomerCustomer DetailsValidatedCustomer

Details

Validate

Customer DetailsSupplierSupplierSupplier Details

ValidatedSupplierDetails

InvoiceSupplier Invoice

Details

SupplierSupplier Details

Item

Supplier

Item Details

Invoice Details

Figure 3.2.1.2(a)

Figure 3.2.1.2(b)

Figure 3.2.1.2 (c)


14/33

Level 3 Salary Details

Level 2 Bill Generation

14

Bill

Generation

Supplier

Customer

Bill

Customer

Salary Details

Manager

CustomerManagement

Order

Figure 3.2.1.2 (d)

Figure 3.2.1.2.(e)


15/33

3.2.1.3. ENTITY-RELATIONSHIP DIAGRAM

The extended entity-relationship (EER) model is a language for

definition of structuring (and functionality) of database or information

systems. It uses inductive development of structuring. Basic attributes are

assigned o base data types. Complex attributes can be constructed by

applying constructors such as tuple, list or set constructors to attributes

that have already been constructed. Entity types conceptualize structuring

of things of reality through attributes.

15


16/33

ENTITY-RELATIONSHIP DIAGRAM

1-m one to many

m-1 many to one

m-m many to many

Supplier

Item

Customer

TextileManagement

System

supp_id

supp nameAdd

City

Pin

cus id

cus nameAdd

City

Pin

Rate

Item

CatI

tem

Desc

Item

Name

Item

No

m m

m

16


17/33

3.2.2. PHYSICAL DESIGN

The three types of Physical Design:

1. Table Design

2. Input Design

3. Output Design

3.2.2.1. TABLE DESIGN

Table Name : Carding

Description : This table holds the information about the carding

Primary Key : S_No

FIELD NAME FIELD TYPE FIELD DESCRIPTION

S_No Number S.no

M/cno Number M/cno

Count Number Count

No.of laps consumed Number No.of laps consumed

Reason for low production Text Reason for low production

Count no.of lap consumed Number Count no.of lap consumed

17


18/33

Table Name : Spinning

Description : This table holds the information about the Spinning

Primary Key : S_No


S_No Number S.no

Date Number Date

Shift Number Shift

Supervisor Text Supervisor

Maistry(jober) Text Maistry

Count Number Count

No.of frams Number No.of frams

Production Number Production

Allotted spindles Number Allotted spindlesStopped spindles Number Stopped spindles

Worked spindles Number Worked spindles

U%(yarn un even ness) Number U%

Production spindles Number Production spindles

Slow speed hours Number Slow speed hours

Table Name : Hank Meter Reading

Description : This table holds the information about the Attendance

Slip

Primary Key : F_no


F_no Number F.no

Initial hank Number Initial hank

Final hank Number Final hank

Shift Text Shift

Total hank Number Total hank Production Number Production

Waste% Number Waste%

Actial production Number Actial production

Table Name : Comber

Description : This table holds the information about the Comber

Primary Key : S_No


18


19/33

S_No Number S.no

M/cno Number M/cno

Reading Number Reading

Hanks Number Hanks

Production Number Production

Waste Number Waste

Noils% Number Noils%

Remarks Text Remarks

19


20/33

Table Name : Spinning Hank

Description : This table holds the information about the Spinning

Hank

Primary Key : S_No


S_No Number S.no

Count Number Count

Frame no Number Frame no

Final reading Number Final reading

Initial reading Number Initial reading

Hanks Number Hanks

Total hanks Number Total hanksTotal production Number Total production

Waste Number Waste

Actual production Number Actual production

Remarks Text Remarks

20


21/33

3.2.2.2. INPUT DESIGN

Input design is a part of ever system design that requires special attention.

Because it is the common source for data processing error, the goal of designing input

data is to make the entry easy and free from errors.

The computerization of TEXTILE MANAGEMENT SYSTEM has been

developed in a user - friendly manner. The system has been designed so as to get

input form the user. The system prompts the data entry operator with menus and

screens. Drop down boxes have been provided for the list of valid data for certain

fields where user can makes election.

Input design is the process of converting user-originated inputs to a computer -

based format input data are collected and organized into group of similar data. Once

identified, appropriate input media re selected for processing.

21


22/33

INPUT DESIGN

COMBER

22


23/33

CARDING PRODUCTION

23


24/33

HANK METER READING RECORD

24


25/33

SPINNING PRODUCTION DETAILS

25


26/33

3.2.2.3 OUTPUT DESIGN

The following are the output and reports that are generated from system

COMPANY - DETAILS

The company report contains the company name, address, phone, fax, E-Mail,

Website, Esi, Pf.

STAFF-DETAILS

The staff reports give the staff Name, ID, Address, Phone Date-of-Join,Designation, Department.

LABOUR - DETAILS

The labour report gives the labour id, Name, Address, Designation,

Department

INCREMENT - DETAILS

The increment details Staff Id, Staff Name, Current Salary, Net Salary,

Increment, Increment Data.

ATTENDANCE - DETAILS

The attendance detail is report given the date. Staff name, staff id, designation,

total due

MONTHLY LEAVE DETAILS

The Monthly leave details is given the staff id, Name, total, leave.

26


27/33

OUTPUT DESIGN

COMBER

27


28/33

CARDING PRODUCTION

28


29/33

HANK METER READING RECORD

29


30/33

SPINNING PRODUCTION DETAIL

30


31/33

4. CONCLUSION

The computerization of the "TEXTILE MANAGEMENT SYSTEM" has been

developed successfully in Visual Basic with Ms-Access to fully satisfy the objective

set by the user. The very much reduces manual burdens of maintaining the file. A

good amount of user friendly features have been incorporated in the system. This

software has been tested with the test data, satisfactory results are obtained. The

package is developed in such a way that the user can use the package for back up of

data at regular intervals.

Scope for further enhancement

The project title "TEXTILE MANAGEMENT SYSTEM" is developed

successfully from mostly all the modules. The further development of this project can

be to host this project to the Internet.

Advantages:

Time consumption reduces

Fast and economical

Accurate Calculations

31


32/33

5. BIBLIOGRAPHY

BOOKS REFERRED:-

Elias.M. Awad," System Analysis and Design", Galgotia publications,

Second Edition, 1993.

Desai Bipin.C,"Introduction to Database Management System",

Tata McGraw Hill Publication, Second Edition, 1998.

PKCM Bride, "Programming in Visual Basic", RPB Publication,

1999.

Roger.S.Pressman, "Software Engineering", Tata McGraw Hill

Publication, Fourth Edition, 1994.

Renu Vig, Ekta walia,"Fundamentals of DBMS", Irwin McGraw Hill

Publication, First Edition, 1995.

Michael MCKelvy,"Visual Basic 6.0", Tata McGraw Hill Publication,

Fourth Edition, 1997.

Evangelous Petroutsos - "Mastering Database Programming with

VB 6.0", BPB Publications, 1998.

Ian Somerville, "Software Engineering", Addition wisely Publication,

5th Edition 1996.

Jeffrey P. McManus, "VB.NET Developer's Guide to XML, and

ADO.NET", Addison Wesley

Websites

www.vbcity.com

wwvv.vbdotnetheaven.com

vyww.codeguru.com

www.sazele.org

http://www.google.com/conceptsofdatabases.html

www.msdn.microsoft.com

www.microsoft.com

www.clusty.com

32
http://www.vbcity.com/http://wwvv.vbdotnetheaven.com/http://vyww.codeguru.com/http://www.sazele.org/http://www.google.com/conceptsofdatabases.htmlhttp://www.msdn.microsoft.com/http://www.microsoft.com/http://www.clusty.com/http://wwvv.vbdotnetheaven.com/http://vyww.codeguru.com/http://www.sazele.org/http://www.google.com/conceptsofdatabases.htmlhttp://www.msdn.microsoft.com/http://www.microsoft.com/http://www.clusty.com/http://www.vbcity.com/


33/33

indroduction_sujithra

Documents