Creating the conceptual and logical model of a journal database

Hampel György: Creating the conceptual and logical model of a journal database. In: Analecta technica Szegedinensia, (16) 1. pp. 110-121. (2022)

[thumbnail of engineering_2022_001_110-121.pdf]
Preview
Cikk, tanulmány, mű
engineering_2022_001_110-121.pdf

Download (522kB) | Preview

Abstract

This article describes the process of creating the conceptual and logical model of a journal database. To efficiently extract the information from the articles published in the journal so far, the idea of creating a database has emerged. To create a database, it is recommended to design a high-level conceptual model and convert that into a logical data model. The benefit of the thoughtful design is that it shows the structure of the database in an easily comprehensible form. The entity-relationship model is a fast and efficient way to create the conceptual model and it can be easily converted to a relational database model, which is a logical model. The initial version of the entity-relationship model of the journal database had one entity type, 25 attributes, and no relationship. The final version contained three entity types, 39 attributes, and three relationships. This final conceptual model was converted to a logical model, the relational model. The result was ten tables to store entity data with 22 different fields and another three tables to ensure the relationships between the tables. The developed model can be created in a relational database manager and is suitable for serving information needs related to the journal.

Item Type: Article
Journal or Publication Title: Analecta technica Szegedinensia
Date: 2022
Volume: 16
Number: 1
ISSN: 2064-7964
Page Range: pp. 110-121
Language: English
Publisher: University of Szeged, Faculty of Engineering
Place of Publication: Szeged
Related URLs: https://acta.bibl.u-szeged.hu/77815/
DOI: 10.14232/analecta.2022.1.110-121
Uncontrolled Keywords: Adatbázis-tervezés, Adatbázis-kezelés
Additional Information: Bibliogr.: p. 120-121. ; ill. ; összefoglalás angol nyelven
Subjects: 01. Natural sciences
01. Natural sciences > 01.02. Computer and information sciences
Date Deposited: 2022. Dec. 14. 15:41
Last Modified: 2023. Jul. 13. 10:39
URI: http://acta.bibl.u-szeged.hu/id/eprint/77878

Actions (login required)

View Item View Item