Conceptual Database Design Research Articles

Enhancing registration systems: Implementing database systems in digital boarding schools

Islamic boarding schools, known as pondok pesantren are specialized schools for Islamic education in Indonesia. With the community's increasing interest in religious education, some pesantren have begun to offer online learning opportunities. Pondok Pesantren Bayt Tamyiz is a Islamic boarding school that has started developing online pesantren education under the name Tamyiz Digittren. This program aims to enhance understanding and translation of the Qur'an using the Tamyiz method. The pondok pesantren requires significant changes in its administrative systems, including the registration process. Information system development is often challenging for the pesantren staffs and software developers. One of the fundamental difficulties lies in the user requirement process. Typically, pesantren need help to provide the information system they need. Such difficulties hinder the development process as developers must conduct numerous experiments. This research aims to design and implement a suitable database for the new student registration system with minimal information and limited time development. The research follows a database development method divided into three stages: Requirement Collection and Analysis, Conceptual Database Design, and Logical Database Design. Database development utilizes MySQL as the Database Management System (DBMS) and PHP as the programming language. This research results in a database design capable of storing and managing student data, payments, and other registration information. We expect the results of this database development to be effective in supporting the registration system and in the future development of information systems at Pondok Pesantren Bayt Tamyiz.

Combining speech processing and text processing in conceptual database design

Combining speech processing and text processing in conceptual database design

Automatic conceptual database design based on heterogeneous source artifacts

The article presents an approach to the automatic derivation of conceptual database models from heterogeneous source artifacts. The approach is based on the integration of conceptual database models that are derived from source artifacts of one single type by already existing tools, whereby those models possess limited certainty given their limited completeness and correctness. The uncertainty of the automatically derived models from specific source artifacts is expressed and managed through the effectiveness measure of the generation of specific concepts of the input conceptual database models. The approach is implemented by the DBomnia tool - the first online web-based tool enabling automatic derivation of conceptual database models from heterogeneous source artifacts (business process models and textual specifications). DBomnia employs other pre-existing tools to derive conceptual models from sources of the same type and then integrates those models. The case study-based evaluation proves that the implemented approach enables effective automatic derivation of the conceptual database model from a set of heterogeneous source artifacts. Moreover, the automatic derivation of the conceptual database model from a set of heterogeneous source artifacts is more effective than each independent automatic derivation of the conceptual database model from sources of one single type only.

Perancangan Basis Data Kawasan Suci Danau Tamblingan dengan Menerapkan Model Data Relasional

The indigenous community of Tamblingan highly reveres the forest as the true source of life (Merta Jati). Within the forest area, there are temples and shrines that are interconnected. Information about these sacred temples and shrines is currently limited to a few individuals who possess specific manuscripts, making it not easily accessible. A database is a crucial component of information technology implementation, as it facilitates faster information retrieval, enhances data security, and reduces data storage redundancy. The Database Lifecycle (DBLC) is a method that outlines the life cycle of a database. In this study, the design of a database for the sacred area of Lake Tamblingan is carried out, starting from conceptual database design to physical database design using a relational model. The design is created using the Power Designer tool. Data collection is conducted through literature review and interviews, while data processing is performed through descriptive analysis. This research aims to produce a database design for the sacred area of Lake Tamblingan that can be utilized for further studies, such as developing an information system for the sacred area of Lake Tamblingan.

Boarding House Search Information System Database Design

Technological advancements are causing humans to produce several inventions and developments to accomplish anything. Which one utilizes internet technology to obtain information as quickly and simply as possible? For example, if someone moves to a new area for work or school, they will need boarding houses. However, this information is difficult to obtain because it is traditionally passed down from person to person, and the boarding house owner finds it difficult to promote his boarding house. As a result, individuals require a computerized system to resolve this issue. This study aims to create a database design for a boarding home information system. This study employs the DBLC (Database Life Cycle) technique, which illustrates the life cycle of a database that may be developed at any time. Database design is separated into three parts: conceptual, logical, and physical database design.

Desain Model Database Layanan Panti Werdha dengan Menerapkan Metode Database Life Cycle

A nursing home is a place where the elderly get care services to live out their parenthood. In the management of nursing homes, many activities are carried out such as nursing services for the elderly, family visit activities, receiving donor assistance, managing elderly contributions, and transferring the elderly. Most of the information about these activities is still referred to manually and some of it is processed using separate applications. The aim of this research is to design the database model needed by the nursing home. The database model design can later be used as a reference for software developers in building an integrated nursing home information system. The form of research carried out is in the form of case studies with data collection methods through interview techniques and documentation studies. Meanwhile, for the analysis and design of the database model itself, it uses Database Life Cycle (DBLC) method which focuses on conceptual database design, logical database design, and physical database design. The result of this design is a relational database consisting of 11 tables and 12 relations. This research is a development from previous research with the same type where the previous research produced 7 tables with 6 relations.

Designing a Payroll System Database for Staff of the Informatics Engineering Department of Universitas Muhammadiyah Yogyakarta

The development of a staff payroll system aims to create a system that can help an administrator recapitulate attendance and payroll data of Informatics Engineering (IE) Department staff quickly and accurately. Such a development requires a database. The database design is divided into four stages: requirement collection and analysis, conceptual database design, logical database design, and physical database design. Design testing was performed on the database by testing the access policies, anomaly check, and view check. The results reveal that the proposed system worked well did not encounter anomalies.

A Study on Information-Preserving Schema Transformations

The problem of determining the relative information capacity between two knowledge bases or schemas, of the same or different models, is inherent when implementing schema transformations. When restructuring one schema into another, one expects that the schema transformation supports the complete and correct mapping of all the information contents from the source schema to the target schema. Such a characteristic is commonly referred to as information capacity preservation or schema dominance. This paper presents a formal and constructive approach to measure the relative information capacity, in the restricted case of first-order schemas related by first-order mappings. It complements the existing definitions of information capacity preservation from the perspective of model theory, showing the exact relationships among the constraints of the involved schemas, the mappings between the components of these schemas, and the database states which the schemas admit. Since satisfying some sort of schema equivalence property is essential in areas such as database conceptual design and database reverse engineering, our approach allows us to characterize the notion of normalization in database design. We review the current literature concerning database normal forms and decompositions. We also review the process of reverse engineering a database schema. In addition, we provide deeper insight into database reverse engineering methodologies, suggesting horizontal decompositions as a useful tool for facilitating the discovery of more specific objects and relationships in the conceptualization phase of the process. With the aid of simple examples, we show the essence behind our reasoning. We discuss the need for an unambiguous means through which objects in the output schema can be identified. Ultimately, the knowledge this paper ensues will be beneficial to database engineers in performing a correct schema transformation.

МЕТОДИКА ОБУЧЕНИЯ БУДУЩИХ IT-СПЕЦИАЛИСТОВ ПРОЕКТИРОВАНИЮ И РАЗРАБОТКЕ БАЗ ДАННЫХ НА ОСНОВЕ ИНТЕРАКТИВНОГО ПОДХОДА

Statement of the problem. The article analyzes and formulates the problems of training in the field of database design and development in preparing students in the field of applied informatics. The article focuses on the problem of learning related with insufficient attention paid directly to the database design process. The purpose of the article is to develop methods for teaching future specialists, first of all, teaching the database design process, step by step mastering the discipline from acquiring basic knowledge and skills in the field of databases to developing a working prototype of an information system, the core of which is a database. Research methodology. The research methodology consists of the analysis and synthesis of research works of foreign and Russian scientists recognized by the scientific community, and the experience of teaching students in designing databases in the field of applied computer science. Research results. The proposed methodology assumes two-stage training with practical work between the stages, which allows, at the beginning of the second stage, to interactively conduct training in the analysis of the subject area and conceptual database design with specific examples of real enterprises and organizations. The results of applying this methodology confirm its effectiveness both in terms of acquiring knowledge, skills and abilities, as well as motivating students to professional activities, forming a holistic picture of the design process, and understanding the practical value of the acquired knowledge. Conclusions. The author’s method of teaching the course “Databases” proposed in the article is based on multi-stage interactive training, in which students return to the same design issues more than once, but at different levels of depth of knowledge. The advantage of the proposed method is the completeness of the scope of the design process until the final software product is obtained.

The design and research based on office automation system

This article focuses on the objective trend of the development of office automation system design technology starting from the requirements of office automation system and functional module design through the analysis and comparison methods of a large number of references, contrast method of office automation system and function modules design are the database used in the system implementation of office automation system and hope to provide an effective reference for office automation system developers. Firstly, this paper is designs for the three dimensional aspect of office automation system function module, office automation system authority design and office automation system interface design. This introduces the requirement of office automation system and function module design. Secondly, from the two aspects of database conceptual design and logic, the paper can be analyze as the design of the database used in the office automation system. Finally, from the two aspects of documental organization structure, office automation system operation interface and code, the paper is studied to be the office automation system realization, hoping that this research will lay a certain theoretical foundation for the design of office automation system.

SPATIAL DATABASE DEVELOPMENT FOR OIL SPILLS POLLUTION AFFECTING WATER QUALITY SYSTEM IN NIGER DELTA

Abstract. The effects of oil spills in the Niger Delta has caused unending menace to the quality of drinking water in most wells and boreholes of the area as most of the wells are shallow and are susceptible to contamination due to the nature of its Geology. The aim of this paper is to develop a database on how oil spills affects water quality which is one of the most crucial resources in the Niger Delta. The study uses existing oil spills data to show the areas and extent of oil pollution in the Niger Delta. Geospatial analysis was used to design an oil spill data base comprising the logical, physical, and conceptual data base design. Visio was used for the design of the entity relationship (ER) diagram of the study. The Kernel density and Getis-Ord G* statistic were used in GIS to map the oil spill areas in the region. Results of spatial spill distribution from the Kernel density and Getis-Ord G* statistic revealed that three states of the Niger Delta namely, Bayelsa, Rivers, and Delta states are the hottest spots for oil spill occurrences and distribution. The ER chart showed the relationships between the pollution sources, their pathways, and the receptors. The ER diagram developed could be of significance to environmentalists and other stakeholders in understanding the processes through which contaminants get to the various compartments of the earth system.

An experiment in model-driven conceptual database design

The article presents the results of an experiment we conducted with database professionals in order to evaluate an approach to automatic design of the initial conceptual database model based on collaborative business process models. The source business process model is represented by BPMN, while the target conceptual model is represented by the UML class diagram. The results confirm those already obtained in a case-study-based evaluation, as well as those of an earlier controlled experiment conducted with undergraduate students. The evaluation implies that the proposed approach and implemented generator enable automatic generation of the target conceptual model with a high percentage of completeness and precision. The experiment also confirms that the automatically generated model can be efficiently used as a starting point for manual design of the target model, since it significantly shortens the estimated efforts and actual time spent to obtain the target model in contrast to the manual design from scratch.

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

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.

Perancangan Database Pada Sistem Asessmen Dan Pemetaan Hasil Asessmen Berbasis Tag Sebagai Pembantu Penyusunan Strategi Pembelajaran

The Assessment and Mapping System of Tag-Based Assessment Results is an online-based system that aims to assist teachers and students in recording and mapping the assessment results for college admission. Information from the recording and mapping is very useful in helping the preparation of learning strategies and strategies to face the next exam. To support this assessment system required a database design. In the design of the database, the design is divided into 4 stages of Data Collection and Analysis, Conceptual Database Design, Logical database design, and Physical Database Design. The design of a conceptual database includes anyone involved in the system, what inputs are required, and what information (output) is desired from the database. While in logical database design, including the determination of Entities and attributes, determination of primary key, Entity Relationship Diagram (ERD). In the physical design, including ERD conversion to table form, normalization and implementation into the form of tables created on MS SQL Server. From the design of the database produces tables without anomalies, ie Eye, Student, Teacher, Testing, Problem, StandardValues, Tags, Groups, GrupMember, Member, EventUjian, Nilai, NomorSoal, PesertaUjian, Clipbooard, and OnGoingExam tables.

On Desirable Semantics of Functional Dependencies over Databases with Incomplete Information

Codd's relational model describes just one possible world. To better cope with incomplete information, extended database models allow several possible worlds. Vague tables are one such convenient extended model where attributes accept sets of possible values (e.g., the manager is either Jill or Bob). However, conceptual database design in such cases remains an open problem. In particular, there is no canonical definition of functional dependencies (FDs) over possible worlds (e.g., each employee has just one manager). We identify several desirable properties that the semantics of such FDs should meet including Armstrong's axioms, the independence from irrelevant attributes, seamless satisfaction and implied by strong satisfaction. We show that we can define FDs such that they have all our desirable properties over vague tables. However, we also show that no notion of FD can satisfy all our desirable properties over a more general model (disjunctive tables). Our work formalizes a trade-off between having a general model and having well-behaved FDs.

Analysis and Design of Web-Based Database Application for Culinary Community

This research is based on the rapid development of the culinary and information technology. The difficulties in communicating with the culinary expert and on recipe documentation make a proper support for media very important. Therefore, a web-based database application for the public is important to help the culinary community in communication, searching and recipe management. The aim of the research was to design a web-based database application that could be used as social media for the culinary community. This research used literature review, user interviews, and questionnaires. Moreover, the database system development life cycle was used as a guide for designing a database especially for conceptual database design, logical database design, and physical design database. Web-based application design used eight golden rules for user interface design. The result of this research is the availability of a web-based database application that can fulfill the needs of users in the culinary field related to communication and recipe management.

Teaching Database Design with Constraint-Based Tutors

Design tasks are difficult to teach, due to large, unstructured solution spaces, underspecified problems, non-existent problem solving algorithms and stopping criteria. In this paper, we comment on our approach to develop KERMIT, a constraint-based tutor that taught database design. In later work, we re-implemented KERMIT as EER-Tutor, and extended its instructional domain. Several evaluation studies performed with KERMIT and EER-Tutor show that they are effective Intelligent Tutoring Systems (ITSs). We also comment on various extensions made to EER-Tutor over the years. There are several contributions of our research, such as developing effective problem-solving support for conceptual database design in terms of interface design. Our database design tutors deal with large solution spaces efficiently by specifying constraints that capture equivalent solution states, and using ideal solutions to capture the semantics of the problem. Instead of requiring a problem solver, the ITS checks whether the student’s database schema is correct by matching it to constraints and the ideal solution. Another contribution of our work is in guidelines for developing effective feedback to the student.

Teaching database systems using a practical example

This article describes how practical lectures can be innovated by the experience of a practical case study. The design and implementation of the geographical information system BotanGIS brought several innovations to the study branch Geoinformatics at the Faculty of Science of Palacky University in Olomouc. This article deals mainly with introducing a new practical example into the course Database Systems. This new theme explains the design and inner structure of the relational database BotanGIS. The valuable contribution lies in the way a real database example from practice is explained to the students in the process of education. The instruction started with a visit to the botanical garden and the collection greenhouses. Subsequently, students worked at a computer laboratory, trying to find some information about plants by various queries in the botanical portal BotanGIS. Finally, a detailed model of the relational database was explained. The teacher’s experience enriched the students’ knowledge in the field of the conceptual database design.

Concepts and evaluation of the extended entity-relationship approach to database design in a multi-paradigm information system modeling tool

Different approaches to information system (IS) development are based on different data models. The selection of a data model for conceptual design, among other things, depends on the problem domain, the knowledge, and the personal preferences of an IS designer. In some situations, a simultaneous usage of different approaches to the conceptual database design and IS development may lead to the most appropriate solutions. In our previous research we have developed a tool that provides an evolutive and incremental approach to IS development, which is based on the form type data model. The approaches based on the Extended Entity-Relationship (EER) and class data models are broadly accepted throughout the community of IS designers. In order to support the simultaneous usage of approaches based on the form type, EER and class data models, we have developed the Multi-Paradigm Information System Modeling Tool (MIST). In this paper, we present a part of our MIST tool that supports EER approach to a database design. MIST components currently provide a formal specification of an EER database schema specification and its transformation into the relational data model, or the class model. Also, MIST allows generation of Structured Query Language code for a database creation and procedural code for implementing database constraints. In addition, Java code that stores and processes data from the database, may be generated from the class model. In this paper, we present the evaluation study of the MIST EER domain-specific language. Users' perceptions of language quality characteristics are used for the evaluation.

Investigating student interactions with tutorial dialogues in EER-Tutor.

Eye-movement tracking and student-system interaction logs provide different types of information which can be used as a potential source of real-time adaptation in learning environments. By analysing student interactions with an intelligent tutoring system (ITS), we can identify sub-optimal behaviour such as not paying attention to important interface components. On the basis of such findings, ITSs can be enhanced to be proactive, rather than reactive, to users’ actions. Tutorial dialogues are one of the teaching strategies used in ITSs which has been shown empirically to significantly improve learning. Enhanced entity-relationship (EER)-Tutor is a constraint-based ITS that teaches conceptual database design. This paper presents the preliminary results of a project that investigates how students interact with the tutorial dialogues in EER-Tutor using both eye-gaze data and student-system interaction logs. Our findings indicate that advanced students are selective of the interface areas they visually focus on, whereas novices waste time by paying attention to interface areas that are inappropriate for the task at hand. Novices are also unaware that they require help with the tutorial dialogues. Furthermore, we have demonstrated that the student’s prior knowledge, the problem complexity and the percentage of the dialogue’s prompts that are answered correctly are factors that can be used to predict future errors. The findings from our study can be used to further enhance EER-Tutor in order to support learning better, including real-time classification of students into novices and advanced students in order to adapt system feedback and interventions.