Logical 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.

Cardinality constraints and functional dependencies in SQL: Taming data redundancy in logical database design

We investigate the combined class of cardinality constraints and functional dependencies over SQL tables. As our first contribution, we establish a finite ground axiomatization and quadratic-time algorithm for deciding their implication problem. As our second contribution, we characterize when finite Armstrong tables exist for this class, and show how to compute finite representations of Armstrong tables for every given input. While there are extreme cases where the size of an Armstrong representation is logarithmic or necessarily exponential, our extensive experiments suggest that the size is low-degree polynomial on average. As our third contribution, we propose a new family of syntactic normal forms for the logical design of SQL tables, of which the well-known Boyce–Codd Normal Form is a special case. Our normal form characterizes SQL schemata that have an a priori upper bound on the number of records in which any redundant data value may occur in any database instance over the schema. Such bounds tame the number of records requiring updates to preserve data consistency.

Construction of Student Mental Health Education Expert Platform Based on Cloud Native Model

After completing the function and performance requirements of the system, the architecture design of the college students’ mental health expert platform is carried out. The overall design of the platform is introduced as a whole, including the logical architecture, topology architecture, and functional architecture of the system. Due to the particularity of the college student’s mental health expert platform, the framework design of the server and the client is made from the system framework level. Then, it introduces the logical design and physical design of the system database, and finally introduces the detailed design of the core function modules in detail. The corresponding weights of each index in the index system are obtained through AHP, and the evaluation model of the mental health expert platform based on AHP is obtained. After testing, it proved that the platform construction was successful. After investigation, more and more students come to the platform for help, and the students believe that functions such as appointment consultation and online consultation should be added.

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.

Database Design for Distribution Simulation Game

The purpose of this study is to obtain a database design for a distribution simulation game that will be used as a learning medium in a industrial engineering. Distribution simulation games have been used since the 1960s, since the invention of the Beer Game by Jay Wright Forrester. The method used in this research is the System Development Life Cycle including the steps of enterprise modeling, conceptual data modeling, logical database design, physical database design, and database implementation. The results of this study are in the form of a relational database design consisting of five entities namely GameTitle, Retailer, Wholesaler, Distributor, and Maufacturer. GameTitle is a strong entity that owns the other four entities. The design can be implemented well in a Database Management System such as Microsoft Access, MySQL, or others. This database is used as data storage during the game and then used as a data source to analyze the effectiveness of understanding the concept of learning in industrial techniques such as forecasting, inventory planning, and supply chain management. The main conclusion that can be drawn in this study is that the database design for the distribution simulation game can be implemented using Microsoft Access with the condition that transaction data between echelon is stored in a separate table to avoid conflicts when accessing simultaneously. With this database design, it is expected that everyone can develop a distribution simulation game application for improving the learning process in their respective fields of study.

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.

Investigating the Relationship Between SLOC and Logical Database Measures to Improve the Early Estimation of Software Cost

Project planning is a critical activity in the software development life cycle. At the early stages of a project, the managers need to estimate required time, effort and cost to plan, track and then to deliver the project successfully. Many studies have attempted to provide methods for precise software cost estimation. The current software cost estimation methods are mainly based on software size estimation and functional system requirements. The main assumption of this study is that, as the primary source of complexity in today’s software is the interaction between the database and the user, database measures may provide inputs allowing current software estimation methods to achieve more accurate results. Accordingly, this study attempts to gain insights from objective measures, collected through the logical database model of software systems, for better prediction of the software’s effort and hence cost through software lines of code (SLOC) measure. For this purpose, more than 2.5 million lines of code developed by four different companies, for 79 different software packages with their related database design measures, are analyzed. The results of this study show that there is a close correlation between the software size and database design measure, namely, the number of tables which can be collected at the logical database design stage. By adapting this result, the current estimation models could be improved significantly.

Design of business simulation game database for managerial learning

This research is aimed to produce a database design that can be used in business simulation game application to improve decision making ability of industrial engineering students. The method used in this design is SDLC method that begins with simulation modelling, conceptual data modelling, logical database design, physical database design, and database implementation. The results of this design are seven relations consisting of scenario, simulation, period simulation, company, supplier, advertisement, and modes. The design results will be used in the development of business simulation game applications that will be used in the learning process of students.

Corporate environmental information system data storage development and management (Environmental Information System)

Abstract In this article a software implementation of the environmental monitoring is developed and presented, which is responsible for receive, store, process and analysis of data. For logical database design system Computer- Aided Software Engineering (CASE) technology, the AllFusion ERwin Data Modeler was selected. To develop corporate Oracle database management system used. The database contains a set of objects, which store all the primary and additional service information, as well as a set of software modules of business logic. The developed information system makes it possible to find optimal solutions for clean and disposal of the contaminated areas. There are advantages of created databases on the areas to be remediated, such as the analysis of remediation made by using plants.

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.

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.

SELF-MONITORING ANALYSIS RESULTS DATABASE DESIGN FOR WASTEWATER TREATMENT INSTALATION IN MANUFACTURING INDUSTRY PACKAGING CANS

In monitoring the environmental quality, besides it needs the data analysis also requires the presentation of accurate data so as to display an useful information. If the data is not immediately available it is feared worsening quality changes that will lead to difficulties in recovery. Self-monitoring analysis results database design for wastewater treatment instalation in manufacturing industry packaging cans aims to create a new procedure in terms of the storage and management to create a new procedure in termsof the storage and management of data replaces the old method is still conventional. Database design also features graphic user interface (GUI) as a medium for user interaction with the database software. Database database software is designed with the Logical database design method in which the process of making a model of the information used in the company based on the model-specific data, but does not depend on the Database Management System (DBMS). DBMS is a software that allows users to define, create, maintain, and control access to the database. Results to be achieved with the existence of this database is that users can easily perform datastorage, update the data, speed up retrieval of earlier data, and assist to present a report. Given this self-monitoring analysis results database, the data can be stored properly and safely on the database to be managed in the future as well as complementary data sources in reporting self-monitoring of wastewater treatment.keywords : self monitoring, database,DMBS, data update, and wastewater treatment plant

Perancangan Basis Data Improvement Dashboard Application: Studi Kasus pada Padang Karunia Group

Padang Karunia Group received a lot of inputs from its employees for improvement collected manually by an administrator. The more input from employees, the more difficult to be collected manually. Therefore Padang Karunia Group took the initiative to create an intranet application to save the inputs in a database. Based on this problem, a research is done to develop database applications in the form of dashboard to collect criticisms and suggestions of employees over the web. This application is expected to assist and facilitate the management of the company, especially in the gathering criticism and suggestions from employees who are then evaluated for company improvement. We uses the database design method based on database application lifecycle, including requirements collection and analysis, conceptual database design, logical database design, DBMS selection, physical database design, and implementation. The results achieved are a database design anda web-based dashboard application that collects criticisms and suggestions. The advantage of using this application is that the company can easily accept criticism and suggestions from employees, simplify storage and data management criticism and suggestions, create reports, and reduce the cost of data collection and the process that was previously done manually. Through the database created, the data management of criticisms and suggestions of employees can be done better.

THE DEVELOPMENT OF A WEB BASED DATABASE APPLICATIONS OF PROCUREMENT, INVENTORY, AND SALES AT PT. INTERJAYA SURYA MEGAH

The objective of this research is to develop a web based database application for the procurement, inventory and sales at PT. Interjaya Surya Megah. The current system at PT. Interjaya Surya Megah is running manually, so the company has difficulty in carrying out its activities. The methodology, that is used in this research, includes interviews, observation, literature review, conceptual database design, logical database design and physical database design. The results are the establishment of a web-based database application at PT. Interjaya Surya Megah. The conclusion is the company can be easier to run the day-to-day activities because data processing becomes faster and more accurate, faster report generation and more accurate, more secure data storage.Keywords: database; application; procurement; inventory; sales

E-Governance in Higher Education: Concept and Role of Data Warehousing Techniques

In this paper we propose E-governance implementation for higher education system with the use of data warehousing and data mining techniques. For this we intend to frame a logical architecture design for higher education system. On the basis of this architecture we will develop the logical design of database. We aim at demonstrating the advantages and techniques of using data warehouse architecture in e-governance applications, with special reference to higher education system in India.

How do we quantify biodiversity? All the evidence in one place.

Biodiversity is a multi-dimensional concept that is represented by a large variety of measures. This complexity and lack of consistency limits the development of a coherent scientific understanding of biodiversity and how properties, such as ecosystem services, may depend on it. Here, I demonstrate that the formal discipline of creating a relational database (RDB) for information about biodiversity and its measures, is a useful tool in organising such knowledge into coherent sense. Following steps of the logical database design and data normalization to build a RDB, results in a formal definition of biodiversity within a well defined concept structure; mapping rules between the concepts of biodiversity and entities of RDB and a consistent information structure - all in one place. I show how this is then used to support evidence-based objective statements about biodiversity.

How do we quantify biodiversity? All the evidence in one place.

AbstractBiodiversity is a multi-dimensional concept that is represented by a large variety of measures. This complexity and lack of consistency limits the development of a coherent scientific understanding of biodiversity and how properties, such as ecosystem services, may depend on it. Here, I demonstrate that the formal discipline of creating a relational database (RDB) for information about biodiversity and its measures, is a useful tool in organising such knowledge into coherent sense. Following steps of the logical database design and data normalization to build a RDB, results in a formal definition of biodiversity within a well defined concept structure; mapping rules between the concepts of biodiversity and entities of RDB and a consistent information structure - all in one place. I show how this is then used to support evidence-based objective statements about biodiversity.

Adaptive XML to relational mapping: an integrated approach

Storing and querying XML (eXtensible Markup Language) data in relational form can exploit various services offered by modern relational database management systems (RDBMSs). Due to structural complexity of XML, there are many equivalent relational mapping schemes for the same XML data and queries. In this paper, we propose the adaptive XML to relational mapping (AX2RM) system, which considers finding optimal XML to relational (X2R) mapping as four separate but correlated procedures: logical database design, data scale estimation, workload transformation, and physical database design. We view the whole process as an autonomic computing problem and formalize the adaptive X2R mapping problem. Search spaces for each procedure are investigated individually, and five approaches for finding the optimal mapping are studied. We propose an integrated approach with greedy pruning (IT-GP), which views the mapping procedures as a whole and exploits heuristic rules in each procedure to prune impossible mappings as early as possible. Evaluation of these approaches shows the validity and high efficiency of IT-GP.