CONCEPTUAL AND LOGICAL DESIGN OF RELATIONAL DATABASES: A CASE STUDY

Authors

  • Tamara Taseska Faculty of Economics - Prilep
  • Ilija Hristoski Faculty of Economics - Prilep

DOI:

https://doi.org/10.20544/NEWHORIZONS.1.1.24.P03

Keywords:

relational database, driving school, E-R diagram, relational schema, relational algebra

Abstract

In a time of increasingly accelerated and ubiquitous digitalization, and in conditions where technology, especially information and communication is available to everyone, business entities are becoming the subject of intensive digital transformation that allows them to fundamentally change the way they work to deliver more value to the customers. Today, technologies are the main driving force of businesses, and the information obtained through data processing and analysis processes is the lifeblood of knowledge-based economies, as well as of the entire digitized society. The wave of digital transformation also swept through the segment of driving schools for training future drivers at the global and local levels, a large number of driving schools previously carried out automation of manual processes using ICT-based software solutions, some introduced management information systems, and some completely migrated their operations to a cloud environment. Regardless of the form and degree of digitization, the common denominator of all these technical-technological advances is the use of relational databases. Based on the ‘database first’ principle, the main goal of this research is to offer a conceptual and logical design of a relational database (RDB) that can later be physically implemented in any relational database management system (RDBMS) to meet the needs of accurate, timely, and complete information about any driving school. Throughout the development of a generic RDB, the power of conceptual design has been demonstrated through the use of E-R diagrams, as one of the leading methodologies for modeling. Through the proposed user questionnaires, the power of relational algebra has been demonstrated as the main formal, theoretical, and procedural query language and mathematical notation of SQL data manipulation operations (SQL DML) performed on the RDB.

Downloads

Download data is not yet available.

Downloads

Published

2024-04-12

How to Cite

CONCEPTUAL AND LOGICAL DESIGN OF RELATIONAL DATABASES: A CASE STUDY. (2024). New Horizons - Journal of Student Research, 1(1), 27-38. https://doi.org/10.20544/NEWHORIZONS.1.1.24.P03