11-08-2014, 02:30 PM
DEVELOPMENT OF SUPPLIER ADDRESS AND CONTACT DATABASE A PROJECT REPORT
DEVELOPMENT OF SUPPLIER.PDF (Size: 1.38 MB / Downloads: 14)
ABSTRACT
The project was done in the CORPORATE QUALITY ENGINEERING department
of ASHOK LEYLAND, ENNORE. The main objective of this project is the development of a
vendor address and contact information database. The vendor quality assurance is a sub function
of the corporate quality engineering department. The functions of vendor quality assurance are
1. Vendor Approval
2. Vendor Quality Assurance
3. Capability Mapping of Key Characters
4. Vendor Quality Audit Status
5. New Product Development And New Process Establishment
6. Major Customer Complaints (Internal and External) Resolved
7. Vendor Interactive Partnership (VIP)-Engines
The vendor registration, approval, audits, address and contact information were
previously done through vendor registration forms and forms for updating important information.
These data were stored in files and other non conventional methods. Hence data retrieval and
MANUSCRIPT PREPARATION
The candidates shall supply a typed copy of the manuscript to the guide for the purpose
of approval. In the preparation of the manuscript, care should be taken to ensure that all
textual matter is typed to the extent possible in the same format as may be required for
the final project report.
Hence, some of the information required for the final typing of the project report is
included also in this section.
The headings of all items 2 to 11 listed section 4 should be typed in capital letters without
punctuation and centred 50mm below the top of the page. The text should commence 4
spaces below this heading. The page numbering for all items 1 to 8 should be done using
lower case Roman numerals and the pages thereafter should be numbered using Arabic
numerals
TYPING INSTRUCTIONS
General
This section includes additional information for final typing of the project report.
Some information given earlier under ‘Manuscript preparation’ shall also be
referred.
The impressions on the typed copies should be black in colour.
Uniformity in the font of letters in the same project report shall be observed.
A sub-heading at the bottom of a page must have atleast two full lines below it or
else it should be carried over to the next page.
The last word of any page should not be split using a hyphen.
One and a half spacing should be used for typing the general text.
Single spacing should be used for typing:
NUMBERING INSTRUCTIONS
Page Numbering
All pages numbers (whether it be in Roman or Arabic numbers) should be typed
without punctuation on the upper right hand corner 20mm from top with the last
digit in line with the right hand margin. The preliminary pages of the project
report (such as Title page, Acknowledgement, Table of Contents etc.) should be
numbered in lower case Roman numerals. The title page will be numbered as (i)
but this should not be typed. The page immediately following the title page shall
be numbered (ii) and it should appear at the top right hand corner as already
specified. Pages of main text, starting with Chapter 1 should be consecutively
numbered using Arabic numerals.
8.2 Numbering of Chapters, Divisions and Sub-Divisions
The numbering of chapters, divisions and sub-divisions should be done, using
Arabic numerals only and further decimal notation should be used for numbering
the divisions and sub-divisions within a chapter. For example, sub-division 4
under division 3 belonging to chapter 2 should be numbered as 2.3.4. The caption
for the sub-division should immediately follow the number assigned to it.
Every chapter beginning with the first chapter should be serially numbered using
Arabic numerals. Appendices included should also be numbered in an identical
manner starting with Appendix
INTRODUCTION
COMPANY PROFILE
Ashok Leyland is one of india’s leading manufacturers of commercial vehicles. They
also manufacture special vehicles and engines for industrial, genset and marine requirements. For
over five decades they have been a major presence in india’s commercial vehicle industry. These
fifty years have been marked by numerous technological innovations and advancements that
have gone to become industry standards.
Ashok Leyland offers a comprehensive product range with trucks from 7.5T GVW to
125T GTW, buses from 19 to 80 seaters, a host of special application vehicles and diesel engines
for industrial, genset and marine applications. The tradition of technology innovation and
reputation for ruggedness, reliability and operational economy have created a market preference
for Ashok Leyland vehicles.
VENDOR DEVELOPMENT AND STRATEGIC SOURCING
Vendors are Ashok Leylands valued partners in business development and they work
with them in a spirit of mutual co-operation to meet their business objectives.
Vendor Development and Strategic Sourcing are handled by Corporate Materials
Department (CMD). CMD identifies the vendors, rates the vendors based on feedback received
from Supplier Quality Assurance Cell, sends drawings / specifications, calls for quotes with
detailed breakup of operation-wise costs, and negotiates the price at which the parts will be
supplied.
In addition to CMD at Ennore, and the two Units at Hosur, there are Materials
Management Departments (MMDs) for scheduling based on unit production plan
Conceptual Design
The conceptual design stage creates the conceptual schema for the database.
Specifications are developed to a point where implementation can begin. During that stage,
detailed models of user views are created and integrated into a conceptual data model recording
all corporate data elements to be maintained in the database.
Conceptual deign focuses on development of a model of the firm’s reality.
Development of the model is guided by information contained in policy and procedure manuals,
as well as the guidelines and generalized models for the functional areas from requirement
definition. Through in-depth interviews with users and careful examination of company forms,
these models are enhanced. They are then integrated as part of conceptual design and became the
basis for implementation.
The modeling task of the conceptual design step is a key component in the
consultant’s recommendation of the DDLC. First as a firm executes the DDLC, the conceptual
design step consists of creating detailed conceptual models of user views in different functional
areas. These models together constitute the external level in the three-level architecture. Second,
these user views are integrated into a single conceptual model giving the conceptual-level
database schema. With this completed we are ready for implementation
SOFWARE USED IN THE DATABASE
This project is focused in developing a vendor address and contact information
database which is user friendly, which addresses security issues, has a powerful query, eases data
entry and provides reports based on the query. The database uses VISUAL BASIC as front end
and ACCESS as back end. It can be later converted and run using SQL as back end. A step by
step classical SYSTEM DEVELOPMENT LIFE CYCLE (SDLC) procedure has been followed
FILE ORIENTED SYSTEM
Early business computer systems were used primarily for accounting functions.
These functions had to be carried out for a business to operate. Consequently the cost of
computer systems that could perform these functions was easy to justify. The manual effort
required was so great that an automated system that could replace the manual system would pay
for itself in a short time.
Because these systems performed normal record-keeping functions, they were called
data processing systems. Data processing system is an automated system for processing the data
for the records of an organization. The programmers and analysts who designed them followed
their natural inclination to mimic the existing manual procedures in their programming.
System construction
The system construction is the development, installation, and testing of system
components. Here a functional system that fulfills business and design requirements are
developed and the interfaces between the new and the existing system are implemented.
Programming plays a major part of the construction phase.
SYSTEM IMPLEMENTATION
The constructed database after construction has to be implemented in the user
premises for the end users to use it. A smooth transition is provided from the old system to the
new system and the users are trained to use the new system. After testing again in the user
premises for functional errors the database is ready for use. A conversion plan is prepared
whether to have a abrupt cut over, or a parallel conversion, or a location conversion, or a staged
conversion. According to the convenience and availability of backups any one of the conversion
plan is selected and carried out. The database after installation in the user premises has to be
taught how to use. So the end users are trained how to use the newly developed database.
CONCLUSION
Thus the user friendly supplier’s address and contact information database is
successfully designed and implemented in the user premises. The database has speeded up
operations drastically. The operation which previously took days or weeks are completed in
matter of minutes. Thanks to the relational database which has help us to make this possible. It is
helped us reduce the use of paper or other temporary storage mediums. The SDLC helps us to
have a systematic approach in developing a new system whereby a lot of unnecessary wastes or
errors are eliminated. The database is also very flexible to accommodate any future up gradation
or change. The database is secured by passwords for various levels of users and controlled by a
administrator.