Representation of Data Structures Using the Entity Relationship Model and the Transformation in Relational Databases

This paper ist dedicated to support data modelling in the ESPRIT project CAPISCE (Computer Architecture for Production Information Systems in a Competitive Environment). The CAPISCE project aims at developing a system architecture and information tools to support and integrate company operations at strategic, tactical and operational levels in the process industries. A main task in this project is the development of general purpose data structures for the architecture mentioned above. This paper should help to get a common understanding on data modelling methods to use for the practical work. It describes how to use the method Entity Relationship Model (ERM), gives comments on special modelling questions and describes how date structures can be transformed into a relational data base using the SQL language.