print

Designing a production database: study case in a piston manufacturing company

---

This thesis is made for a piston manufacturing company (pmc) in database design. A pmc is a company that under license from a japanese company and meet customers' quality standards requirements. The standards are usually very high particularly for customers with well known brand names. The tolerance between one grade piston to another with three micron. One piston is checked by approximately one hundred and sixty criteria of rejection production process. This company is currently the biggest piston manufacturing in indonesia that produced piston as genuine parts. Most ot the products are sold in local market with around ten percent exported to japan. nnWith total employees near five hundreds in production division, it is trying to solve problems that related with information system.nnIn preparation of the solution to the above problems with analyze company situation, user's habits considerations, define the problem, define objectives, and define boundaries. In database designing process, the steps that are used: business rule, entity relationship diagram, transformation from entity relationship to logical records structure, logical record structure, relational table, normalization, and physical design.nnBy using query in access 2000, the important production data that are needed, we can be got them. From this data we shall make production report timely and more reliable.

---

Availability

M00017

(wh)

Available

Detail Information

Series Title

-

Call Number

17

Publisher

: Swiss German University., 2002

Collation

-

Language

English

ISBN/ISSN

-

Classification

-

Content Type

-

Media Type

-

Carrier Type

-

Edition

-

Subject(s)

MIT

Specific Detail Info

-

Statement of Responsibility

-

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment