scholarly journals Experimental study on the effectiveness of a teaching approach using barker or Bachman notation for conceptual database design

2018 ◽  
Vol 15 (2) ◽  
pp. 421-448 ◽  
Author(s):  
Aida Kamisalic ◽  
Marjan Hericko ◽  
Tatjana Welzer ◽  
Muhamed Turkanovic
Keyword(s):  
Experimental Study ◽  
Conceptual Design ◽  
Learning Process ◽  
Data Model ◽  
Relational Databases ◽  
Education Institution ◽  
Database Design ◽  
Teaching Approach ◽  
Logical Design ◽  
Logical Data

Relational databases are one of the pillars of information systems and as a consequence conceptual and logical design can be seen as the foundation of almost every application regardless of the platform. Nevertheless, little research has been done so far on the effectiveness of teaching approaches to database basic concepts and design. This paper introduces a multi-level experimental study developed to examine the effectiveness of learning database fundamentals, depending on the notation used for conceptual design. The main experiment was carried out at a higher education institution. We developed different experimental instruments to evaluate the effectiveness of a teaching approach using Barker or Bachman notation for conceptual database design. In contrast to Barker notation, Bachman notation incorporates elements of logical design (i.e. foreign keys) in the conceptual design level. Students? achievements were examined with regard to influencing factors throughout the learning process. Introducing the Bachman notation and a manual transformation from a conceptual into a logical data model, could increase students? understanding of conceptual, logical and relational data model concepts. We found that the notation used during the learning process has an impact on students? achievements. Moreover, students achieved better results when solving tasks presented with a notation that incorporates elements of logical design into the conceptual level. Finally, we required the use of manual transformation from a conceptual into a logical data model and the results confirmed an increase in students? understanding.

scholarly journals FORMALIZED REPRESENTATION FOR THE DATA MODEL WITH THE UNIVERSAL BASIS OF RELATIONS

2019 ◽  
pp. 453-460
Author(s):  
Vitalii I. Yesin ◽  
Mikolaj Karpinski ◽  
Maryna V. Yesina ◽  
Vladyslav V. Vilihura
Keyword(s):  
Relational Database ◽  
Data Model ◽  
Relational Databases ◽  
Subject Domain ◽  
Dynamic Changes ◽  
Standard Data ◽  
The Subject ◽  
Logical Design ◽  
The Creation ◽  
Universal Standard

The goal of the article is to develop a universal (standard) data model that allows you to get rid of the need for a costly policy of doing extra work when developing new ones or transforming existing relational databases (RDBs) caused by dynamic changes in the subject domain (SD). The requirements for the developed data model were formulated. In accordance with the formulated requirements, the data model was synthesized. To simplify the process of creating relational database schemas an algorithm for transforming the description of the subject domain into the relations of the universal basis of the developed model was proposed. The scientific novelty of the obtained results is: a data model that, unlike known ones, allows us to simplify the creation of RDB schemas at the stage of logical design of relational databases, under the conditions of dynamic changes in subject domains, due to the introduced universal basis of relations, as a means of describing structures and the presentation of data for various SDs has been developed.

scholarly journals Building Subject Domain Ontology on the Base of a Logical Data Mod

2020 ◽  
Vol 23 (3) ◽  
pp. 390-417
Author(s):  
Alexander M. Gusenkov ◽  
Naille R. Bukharaev ◽  
Evgeny V. Biryaltsev
Keyword(s):  
Data Model ◽  
Relational Databases ◽  
Object Oriented ◽  
Domain Ontology ◽  
Subject Domain ◽  
Description Language ◽  
The Subject ◽  
Owl Ontology ◽  
Oil Company ◽  
Logical Data

The technology of automated construction of the subject domain ontology, based on information extracted from the comments of the TATNEFT oil company relational databases, is considered. The technology is based on building a converter (compiler) translating the logical data model of Epicenter Petrotechnical Open Software Corporation (POSC), presented in the form of ER diagrams and a set of the EXPRESS object-oriented language descriptions, into the OWL ontology description language, recommended by the W3C consortium. The basic syntactic and semantic aspects of the transformation are described.

scholarly journals Using the REA Data Model in Order to Reduce Design Complexity in an Inventory Management Relational Database, and the Need for a Relational Database Complexity Metric.

2021 ◽  
Vol 9 (7) ◽  
pp. 71-78
Author(s):  
Ian Adamson
Keyword(s):  
Inventory Management ◽  
Relational Database ◽  
Data Model ◽  
Relational Databases ◽  
Database Design ◽  
Business Environment ◽  
Design Complexity ◽  
Data Inconsistency ◽  
A Company

With the extensive use of relational databases in the business environment there is a need to reduce database complexity in order to avoid data inconsistency and redundancy, which can provide a company with unreliable and/or meaningless data and information. The use of the REA Data Model in database design can significantly help with this problem.  The model can eliminate the need for unnecessary data artifacts which should only be generated by the system when needed. This paper also addresses the need for a Relational Database Complexity Metric. A simple and easy to understand metric is presented.

scholarly journals Overview of Object-Oriented Paradigm in an Appendix to the Development of Databases

2019 ◽  
Vol 17 (3) ◽  
pp. 123-134
Author(s):  
E. A. Yatsenko
Keyword(s):  
Data Model ◽  
Computer Aided Design ◽  
Relational Databases ◽  
Object Oriented ◽  
Database Design ◽  
Practical Implementation ◽  
Software Products ◽  
Knowledge Based ◽  
Computer Aided ◽  
Production Knowledge

The article provides an overview of projects, technologies, software products developed to implement the ideas of an object-oriented approach to database design. In the 80s of the 20th century, there were many projects devoted to the idea of OODB, many experts expected that in the near future relational databases would be crowded out with objectoriented ones. Despite the impressive number of projects conducted by both teams of scientists and commercial companies focused on practical implementation, there was no clear formulation of an object-oriented data model, each team presented its own vision of applying object-oriented concepts to database design. The absence of a universal data model, with a well-developed mathematical apparatus (as in the case of relational databases), is still the main problem in the distribution of an OODBMS. However, the use of relational DBMS raises a lot of problems that are most acutely felt in areas such as computer-aided design, computer-aided production, knowledge-based systems, and others. OODB allow to combine the program code and data, to avoid differences between the representations of information in the database and the application program, as a result of which modern developers show interest in them. There are a lot of OODBMS, but they cannot compete with the largest storage organization systems.

scholarly journals Analisis dan Perancangan Sistem Basis Data Catatan Waktu Kerja dan Proyek Karyawan pada PT Rekayasa Engineering

2013 ◽  
Vol 4 (2) ◽  
pp. 983
Author(s):  
Rhio Sutoyo ◽  
Franky Hadinata Marpaung
Keyword(s):  
Conceptual Design ◽  
Database Design ◽  
Database System ◽  
Physical Design ◽  
Working Time ◽  
Working Model ◽  
Logical Design

The purpose of this research is to analyze and implement a system for recording employee working time and project time, leave request, overtime request, proposal submission, and paperwork revisions registration at PT Rekayasa Engineering. Collecting information is conducted by surveys to the company, interviews with several employees in the company, and examining documents and procedures used by PT Rekayasa Engineering. The database design is created using lifecycle methodology, namely: conceptual design, logical design, and physical design. The result of this research is a database system which is designed and can be used to process operational procedures of the company and to record the working time and project needed by the PT Rekayasa Engineering. Furthermore, this research also produces a prototype application that can be used as a working model for the system. Using the new database system and the application, information needed by the company is fulfilled. Thus, it allows the company to work more effectively and efficiently.

A Study of the Information Handling Behavior of Designers During Conceptual Design

1994 ◽  
Author(s):  
Vinod Baya ◽  
Larry J. Leifer
Keyword(s):  
Experimental Study ◽  
Social Work ◽  
Work Environment ◽  
Conceptual Design ◽  
Design Process ◽  
Verbal Protocol ◽  
Amount Of Information ◽  
Information Handling ◽  
Tools And Methods

Abstract The research reported in this paper examines the design process from an informational perspective. The study is based on the premise that there is a need to understand and formalize the information generating, accessing and analyzing behavior of designers in order to build tools and methods which can be smoothly integrated with their technical and social work environment. Results from an experimental study, conducted using the verbal protocol method, are discussed. A measure for the amount of information designers handle has been explored. A framework for analyzing the information handling behavior of designers is also presented.

scholarly journals BALINESE ART STUDIOS: THE LEARNING PROCESS OF ART AND CULTURE TO SUPPORT SUSTAINABLE TOURISM

2020 ◽  
Vol 4 (1) ◽  
pp. 68
Author(s):  
I Gde Agus Jaya Sadguna ◽  
I Gusti Agung Mas Krisna Komala Sari ◽  
Kumiko Shishido
Keyword(s):  
Learning Process ◽  
Performing Arts ◽  
Formal Education ◽  
Sustainable Tourism ◽  
Fine Arts ◽  
Education Institution ◽  
Tourism Industry ◽  
Hindu Religion ◽  
Art And Culture ◽  
Negative Impacts

Purpose: A lot of perspectives have been discussed about Bali and this paper will discuss it from the angle of the learning process of art and culture in the Balinese art studios in Gianyar Regency. Research methods: The research was conducted on the months of July and August 2019. Qualitative data was obtained during the research because the method of data collection was interviewing the owner of the dance studio. Results and discussions: One of the A’s in tourism is attraction and Bali have a strong attraction for tourists both domestic and foreign tourists. The art and culture is the breath of tourism in the island of Bali, which is based on the Hindu religion. The resources for these art and culture are nurtured in several forms, which one of them is through sanggar or studios, which is a non-formal education institution for learning Balinese art and culture. Various types of art and culture and developed and nurtured in these studios, such as performing arts, fine arts, and local wisdoms. The tourism industry has given positive and negative impacts for Balinese art and culture, depends on how one may argue if seen through different perspectives. Performing arts have flourished in terms of daily performances taken places in hotels and designated performance theaters. The types which can be easily watched are the music and dance of Bali. Conclusion: Tourism in this sense is not a direct aspect but, in the future, has a direct impact: providing culture resources for performances in tourism objects and destinations. This as a part of social sustainability, also the sanggars, is a part of the sustainable tourism family

Sign in / Sign up

Export Citation Format

Share Document