Creating the Relational Model of a Database Containing the Data of a Journal

Abstract

A total of 482 articles by 895 authors have been published in Contemporary Social and Economic Processes since its first publication. In order to efficiently extract the information published so far and in future issues, the idea of creating a database has emerged. To create the database, it was necessary to design a high-level conceptual model and then build a logical data model based on it. In the context of the journal, this meant designing the entity-relationship model and then converting it to a relational model; the latter is the subject of this writing. The entity-relationship model consisted of 3 entity sets with 39 attributes, and 3 relationships. With the conversion, 10 tables were created to store the data of the entities – with a total of 22 different fields (columns) – and another 3 tables to ensure the relationships between the entity sets. The developed model can be created in a relational database manager and is suitable for serving information needs related to the journal.