Conceptual and Logical Design of Relational Databases: A Case Study
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...
Main Authors: | , |
---|---|
Format: | Article in Journal/Newspaper |
Language: | English |
Published: |
"St. Kliment Ohridski" University - Bitola
2024
|
Subjects: | |
Online Access: | https://eprints.uklo.edu.mk/id/eprint/9940/ https://uklo.edu.mk/ojs/index.php/nhjsr/article/view/366/324 https://eprints.uklo.edu.mk/id/eprint/9940/1/New_Horizons_pp_27-38.pdf https://doi.org/10.20544/NEWHORIZONS.1.1.24.P03 |
Summary: | 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 digitalized society. The wave of digital transformation also swept through the segment of driving schools for training future drivers at the global and local levels, so that a large number of driving schools that previously carried out automated manual processes now use 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 digitalization, the common denominator of all these technical-technological advances is the usage 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. |
---|