Aplicação da modelagem entidade-relacionamento visando a proposta de um banco de dados para o gerenciamento de mudanças de engenharia no desenvolvimento de produtos

Abstract

This work applies the Entity-Relationship Modeling to propose a database for Engineering Changes Management in the Product Development Process (NPD). First, the study began with a literature review of Management Information Systems, Entity Relationship Modeling and New Product Development. Thus, were identified the three stages of modeling, Conceptual Design, Logical Design and Physical Design and applied in the Case Study for an Automotive Industry. There the Engineering Changes Management process was used to support the development of components for the main product. Nevertheless, the Entity-Relationship Diagram was obtained as study result and all the process functions necessary for the maintenance and update were considered. From the indicial evaluation, there were seven controls or entities, which corresponding to Microsoft Excel spreadsheets, and 184 attributes. After this proposal, the process will use 16 entities and 83 attributes as the final result. Therefore, it was concluded the application of the Entity-Relationship Modeling to database contributes to the work’s rationalization in dynamic environments.