Database Design Research Articles

Implementation of Relational Database in the STEAM-Problem Based Learning Model in Algorithm and Programming

Currently, digital technology is developing in all fields. The development of this technology certainly has a significant impact on the world of education. A suitable learning model is needed, especially in the Algorithm and Programming course, to face global challenges in the Industrial Revolution 4.0. Students are expected to have skills that include critical and creative thinking in solving problems, communication, and collaboration with the support of technology. The STEAM-Problem Based Learning model can be used in the Algorithm and Programming learning process with seven syntaxes: preparation and knowledge identification; problem identification; plan solution; create and test products; communicate; evaluation and feedback and giving rewards. All activities carried out in the learning process by lecturers and students can be stored in a database. This research attempts to determine the validity of the STEAM-Problem Based Learning database design, which will be implemented in the Algorithm and Programming course. The data analysis technique used is validity analysis, which is based on assessing the data obtained through a questionnaire or a questionnaire using a Likert scale. Data was processed using Aiken’s V validity coefficient formula to test the expert’s judgment. Assessment indicators include correctness, consistency, relevance, completeness, and minimality. The results of the study show that the validity test on the STEAM-Problem Based Learning database design is valid, so it is feasible to implement it in algorithm and programming learning.

Nurse leaders' interpersonal communication competence: A mixed-method systematic review.

To identify and synthesize evidence available on nurse leaders' interpersonal communication competence. Systematic mixed-methods review according to the Preferred Reporting Items for Systematic Reviews and Meta-Analysis checklist. The data were collected following predefined inclusion criteria. Two authors independently performed the study selection using Covidence software. Three authors assessed the quality using Joanna Briggs' Institute's critical appraisal tool and the mixed-methods appraisal tool. The data-based convergent synthesis design and narrative synthesis were used. CINAHL, PubMed, Scopus, Business Source Elite, Academic Search Premier, Communication & Mass Media Complete, PsycInfo, Web of Sciences, Medic and Finna.fi were searched and the screening of citations in relevant articles. The final searches were performed on 17 October 2022. A total of 26 studies-15 quantitative, 9 qualitative and 1 of both mixed-method and multi-method-met the inclusion criteria. The nurse leaders' interpersonal communication competences described in the extant literature were categorized into three themes: message competence, relational competence and task competence. There were considerable differences in the levels of competence, as some competences were considered basic communication skills, while others required more advanced level competences. Furthermore, three competence levels were identified: novice, competent and expert. This study unravels a unique hierarchical description of communication skills across competence categories, supported by the assumption that communication skills are structured hierarchically. The studies reviewed herein had a narrow perception of nurse leaders' interpersonal communication competence and indicated a transmissional understanding of communication. This is the first mixed-methods systematic review that describes and synthesizes the evidence on nurse leaders' communication competencies hierarchically and across competence levels. The study suggests that further research should focus on a broader and more analytical understanding of the cognitive and affective aspects of interpersonal communication competence. CRD42023385058. No patient or public contribution.

Dynamic switching of psychological test questions and design of scalable database: A study of web page data visualization and front-end interaction

As the need for efficient and user-friendly web applications in the field of psychological assessment continues to grow, traditional web development approaches are challenged to provide a dynamic and adaptive user experience. This study focuses on addressing these challenges through a comprehensive study that provides insight into the current state of psychological assessment web development, highlighting the shortcomings of traditional approaches, including the static limitations of Hyper Text Markup Language (HTML) and limited client-side scripting. The result is a user experience that lacks the responsiveness and flexibility that modern users expect. To tackle these problems, the intended solution suggested in this work combines a strong and scalable database design with a dynamic switching mechanism for psychological exam questions. Features-rich, aesthetically pleasing, and functioning client-server Web applications are created using technologies such as Servlets and Java Server Pages (JSP). The research contains practical case studies that demonstrate how Java-based user interface design can be successfully applied in real-world scenarios. The advantages of modularity, code reusability, and maintainability are demonstrated in these case studies. The study examines how selected technologies affect the performance, security, and accessibility of web UI, while also addressing load times, data integrity, and user inclusion issues. To summarize, this investigation underscores the crucial role of dynamic and scalable databases and Java-based technologies in enhancing the design of psychological assessment Web UIs.Developers can create web applications that exceed user expectations and provide superior user experience in the evolving digital landscape by using the proposed frameworks comprehensive toolkit.

Helmet Sales Information System Web based on Studio Shop Jakarta Custom Helmet

Systems information of helmet sales based on the web at Studi Helm Custom Store. The purpose of this study was to analyze and design of web-based sales system in Stores Studio Helm Custom. It is made to increase profits and make it easy for customers to order and buy helmets. This method uses data collection, analysis (surveys, interviews, and literature) and design (form inputs, processes, reports, and database). The results of this study are web-based sales system that can be used by customers 24 hours. The conclusion is a web-based sales system has facilities such as information pages, the page order, and cancel the page.

Minimal coverage of generalized typed inclusion dependencies in databases

The paper discusses the theory and algorithms necessary to construct a minimal covering of generalized typed inclusion dependencies. Traditionally, the construction of minimal covering is used for all types of dependencies in order to obtain a non-redundant and consistent database design. Generalized inclusion dependencies correspond to referential integrity constraints, when several main and several external relations are involved in one constraint, which corresponds to an ultragraph edge. In previous work, based on a study of the properties of dependencies, a system of axioms was presented with proof of consistency and completeness. In this work, the closures were studied for generalized typed inclusion dependencies. An algorithm for constructing closures has been developed and its correctness has been proven. The results obtained are further used to develop an algorithm for constructing a minimal covering. At the end of the article, examples are presented that demonstrate the operation of the algorithms.

Coral Database and Monitoring System Design for Ecological Sustainability

Coral Database and Monitoring System Design for Ecological Sustainability

Optimization of computer ontologies for e-courses in information and communication technologies

A methodology is proposed for modifying computer ontologies (CO) for electronic courses (EC) in the field of information and communication technologies (ICT) for universities, schools, extracurricular institutions, as well as for the professional retraining of specialists. The methodology includes the modification of CO by representing the formal ontograph of CO in the form of a graph and using techniques for working with the graph to find optimal paths on the graph using applied software (SW). A genetic algorithm (GA) is involved in the search for the optimal CO. This will lead to the division of the ontograph into branches and the ability to calculate the best trajectory in a certain sense through the EC educational material, taking into account the syllabus. An example is considered for the ICT course syllabus in terms of a specific topic covering the design and use of databases. It is concluded that for the full implementation of this methodology, a tool is needed that automates this procedure for developing EC and/or electronic textbooks. An algorithm and a prototype of software tools are also proposed, integrating machine methods of working with CO and graphs.

Design and Implementation of Booth Supply System Based on Internet Plus.

With the arrival of the Internet Plus era, the traditional vendor market management mode is facing severe challenges. The purpose of this paper is to propose an innovative management mode through the design and implementation of a stall supply system based on the Internet to solve the problems existing in vendor market management and better promote economic development and social stability. This paper first analyzes the characteristics and challenges of the vendor market in the Internet Plus era. Then, based on the idea of Internet Plus, we propose a design scheme for the vendor supply system, including system architecture, functional modules, and key technologies. In the following section, we elaborate on the implementation steps of the system, including system requirements analysis, database design, and system development. Finally, we verified the feasibility and effectiveness of the system through an actual case study and performed a comprehensive evaluation and in-depth analysis of the operation of the system. The research results show that the vendor supply system based on the Internet can realize the distributed management of the vendor market and optimize the allocation of resources, improve the efficiency and competitiveness of the market, and provide a reference for the development of the traditional vendor market.

Design Warehouse Information System to Increase Stock Accuracy

In its development, the warehouse is currently not only used as a room for storage but has been integrated with the information system used in carrying out its warehousing activities. One of the objectives of the warehousing information system is to achieve stock accuracy according to the Company's target. PT Zoomlion Indonesia Heavy Industry (PT. ZIHI) is one of the heavy equipment industry companies engaged in the provision of heavy equipment, construction and plantations that have used the SAP system in managing their inventory but have not reached the stock accuracy target expected by the Company because in SAP there is no warehouse module. The purpose of this study is to find out what causative factors can affect stock inaccuracies in Jakarta warehouses, find out the dominant factors that cause stock inaccuracies and to find out the improvements made in increasing stock accuracy in PT Zoomlion Indonesia's Jakarta warehouse. The methods used are the DEMATEL (Decision Making Trial and Evaluation Laboratory) method, five why analysis, fishbone diagrams, for further design of the bin location system database. The results showed that (1) the factors causing stock accuracy inaccuracies at PT Zoomlion Indonesia Heavy Industry were due to increased receiving, storage, and shipping activities and limited manpower, and were not supported by a system that facilitates the location of parts. Meanwhile, according to fishbone analysis, the factor diagram that causes stock accuracy is not optimal is done through the five whys approach, which consists of human factors, methods, materials and the environment, (2) the dominant factors that cause inaccuracies in stock accuracy occur at risk (E10) There is no SAP support system for registering Bin location, (3)The web database stock location design developed is a form of improvement effort from the manual monitoring system that is not running smoothly. This stock location database will provide information about materials while in the warehouse room. Therefore, the use of a mobile- based web server can make it easier for users to access the system from a smartphone device.

PENERAPAN FRAMEWORK CODEIGNITER 4 DALAM APLIKASI PENJUALAN PAKAIAN BERBASIS WEB PADA DISTRO DISTROBUTOR

In the rapidly evolving digital era, distribution businesses require an efficient and integrated sales information system to enhance operational performance and customer service. This research aims to implement a web-based shirt sales information system using the CodeIgniter 4 framework for distro distrobutor. The research methodology encompasses stages of needs analysis, system design, implementation using CodeIgniter 4, and application testing. The needs analysis process is conducted to understand user requirements and the business characteristics of distribution distributors. Meanwhile, system design involves database design, user interface, and application architecture. Implementation utilizes the outstanding features of CodeIgniter 4 to construct a responsive and easily manageable sales application. The anticipated outcome of this research is expected to provide a positive contribution to improving the efficiency of clothing sales in distribution distributors. With the adoption of the CodeIgniter 4 framework, it is hoped that the system can deliver an optimal user experience and support the daily operations of distro distrobutor. Additionally, this research is expected to serve as a reference for developers and business owners in adopting information technology on a broader scale in the clothing distribution industry

On Enforcing Dyadic-type Homogeneous Binary Function Product Constraints in MatBase

Homogeneous binary function products are often encountered in the sub-universes modeled by databases, from genealogical trees to sports, from education to healthcare, etc. Their properties must be discovered and enforced by the software applications managing such data to guarantee plausibility. The (Elementary) Mathematical Data Model provides 17 dyadic-type homogeneous binary function product constraint types. MatBase, an intelligent data and knowledge base management system prototype, allows database designers to simply declare them by only clicking corresponding checkboxes and automatically generates code for enforcing them. This paper describes the algorithms that MatBase uses for enforcing all these 17 homogeneous binary function product constraint types, which may also be used by developers not having access to MatBase.

A Systematic Overview of Fuzzy Extended Entity Relationship (Fuzzy EER) Model Using Practical Examples

Most real-world data are vague and imprecise, so traditional relational databases cannot represent, integrate, and manage them effectively. In this research, we gave an overview of the application of fuzzy logic to the conceptual modeling facet of database design, which is an enhancement of the Extended Entity Relationship (EER) model. This is done to give a clearer picture of how imprecise and vague data are represented and managed, especially in multiple-criteria decision-making database systems. To achieve this, an overview of fuzzy attributes, fuzzy values in the attributes, notation for fuzzy representations, fuzzy degree in each value of an attribute, fuzzy degree in a set of values of different attributes, fuzzy degree with its own meaning and fuzzy degree to the model was carried out with practical examples.

Theory-based design principles for unprecedentedly high two-level CO2 utilization of CO2-derived metal-organic frameworks

In this study, we theoretically developed a novel strategy for “two-level” CO2 utilization: the first level is “CO2 content” by directly converting CO2 into metal-organic frameworks (MOFs), and the second level is “CO2 capacity” by storing CO2 gas into their cavity. Despite its conceptual simplicity, experimental realization is rare due to technical difficulties and a lack of design principles for simultaneously maximizing CO2 content and CO2 capacity, leaving many unexplored possibilities. In this study, we designed over 1,500 hypothetical MOFs across 15 types of metal nodes combined with 14 types of newly designed CO2-derived ligands in over 40 topologies. We found that [-CO2NHNHCO2-] ligand assembled with [V2(CO2)4] node on the zeolite-like usf topology can have a large CO2 content of 50 wt%, which exceeds 31.6 wt% for the synthesized CO2-derived MOF. Grand Canonical Monte Carlo Simulation showed that the well-alignment of the paddlewheel in usf topology allows CO2 to be fully exposed to the cavity space, achieving high CO2 adsorption capacity. In addition, the fluorination of the ligand of MOFs significantly increases CO2 capacity and reaches unprecedented high CO2 utilization of up to 62 wt%. The design principles and database from this work provide opportunities and challenges for experimentalists in synthesizing new MOFs with breakthrough CO2 utilization.

GLAZING SYSTEMS WITH SILICA AEROGEL FOR OPTIMIZING ENERGY CONSUMPTION IN HOTEL BUILDING

Due to their high energy consumption hotel buildings have a significant impact on the environment. Such constructions are particularly energy-intensive demanding environments so as to meet the various needs of occupants and ensure their comfort. Guests tend to consume more energy during their stays than they do in their own homes (water, electricity, light, temperature...). In recent years, Algeria has seen a significant increase in the construction of hotels, many of which are concentrated in the Mediterranean region, which experiences particularly high humidity levels in the summer and winter. The new generation of building materials used to enhance comfort and reduce building energy consumption, are progressively sought after all over the world. This work, which studied the performance of silica aerogels for the glazing system of hotel rooms in a Mediterranean climate, can provide a database for hotel designers, an investigation combining experimental work (air and surface temperature measurements and thermography) and numerical simulation (using TRNsys V17) was conducted on an existing hotel building located in Béjaia. The results revealed the insertion of silica aerogel within a 6 mm thick glazing sheet decreases significantly the heating and cooling requirements of the study indoor environment.

Correspondence between Expected, Perceived, and Measured Effects of BoNT-A Treatment in Calf Muscles among Children and Adolescents with Cerebral Palsy: A Mixed Methods Study.

(1) Background: Our study explores the relationship between expected, perceived, and measured effects of botulinum toxin A (BoNT-A) treatment and saline (placebo) in children and adolescents with cerebral palsy (CP) in the calf muscles of 20 children and adolescents with cerebral palsy (CP), aged 4-15 years, using the Gross Motor Function Classification System (GMFCS) I-II. (2) Methods: A mixed methods parallel database design was used. Quantitative and qualitative data were collected at baseline and four weeks after treatment. The primary quantitative measure was gross energy cost (EC) during walking, obtained from a 5-Minute Walk Test (5MWT), while qualitative semi-structured interviews were performed with each parent and child/adolescent individually. (3) Results: Four weeks after treatment, we did not find any correspondence between expected, measured, and perceived effects. Interestingly, parental perceptions of treatment effects were more consistent than the measured outcomes. We also observed a connection between parental treatment expectations and perceived effects, often related to reduced energy expenditure. Children tended to view their parents as treatment experts and had fewer expectations and perceptions themselves. (4) Conclusions: These findings support the importance of child-centered care, which entails actively listening to children's expectations and perceptions during the treatment process.

Experimental Structural Validation of a Landing Gear System for High-Speed Helicopter Applications

The design and technological demonstration of a Landing Gear architecture were addressed for Airbus fast rotorcraft end application within the Clean Sky 2 Racer project. Numerical activities including advanced modelling approaches were carried out to substantiate the feasibility of structural concepts in compliance with industrial standards and CS-29 applicable airworthiness requirements. In order to demonstrate the goodness of design strategies, a true-scale prototype was manufactured and tested for demonstrating its capability to withstand static loads representative of the limit and ultimate cases expected in service. The paper will focus on the qualification of the Nose and Main Landing Gear systems. Sizing process was validated and verified by test whose results allowed for validating/calibrating the FE model. In such a way, the design database could count on a reliable tool available for analysing the effect of any further load condition change.

Effects of malnutrition on child neurodevelopment and mental health

Introduction: Childhood malnutrition, a serious public health problem in children and adolescents, with changes in body composition, homeostasis of the body, neurodevelopment and alterations in mental health. Objective: Describe the effects of malnutrition on neurodevelopment and children's mental health. Methods: Narrative review study, with a documentary, non-systematic and descriptive design in scientific databases: Pubmed, Scopus, SciELO, Redalyc and Google Scholar, using Health Sciences descriptors, whose selection criteria were complete articles published between 2018 -2023, in English and Spanish. Results: Families with better socioeconomic status have children with a higher risk of suffering from malnutrition due to overweight and obesity, while malnutrition is more common in children from low-income families in poorer countries; However, changes in the epidemiology of diseases due to malnutrition with emotional alterations were prevalent in developed countries, considered a global problem. People diagnosed with psychiatric illnesses, reported with childhood trauma, such as abuse and/or maltreatment, may be at greater risk of suffering from malnutrition due to eating disorders. Conclusions: Nutrition is the greatest environmental influence on childhood neurodevelopment, due to the impact on mental health that begins with maternal prenatal malnutrition, alters neurodevelopment and increases the postnatal risk of decreased cognitive function, behavioral disorders and greater susceptibility to neuropsychiatric disorders. Similarly, obesity during pregnancy predisposes the fetus to a phenotype with neurodevelopmental impairments, producing postnatal alterations in executive functions, decreased impulse control, and compulsive eating behaviors

Investigation related to database design for letter of credit

The "Letter of Credit" is a fundamental payment mechanism in global trade, and its efficiency has significantly declined due to the impact of the COVID-19 pandemic. This document delves deeply into the development and execution of a comprehensive database for managing Letters of Credit (L/Cs). It is designed with a real-world case study derived from the International Settlement Department of the Bank of China. The central goal of this database is to enhance the efficient management and simplification of the complex procedures inherent in L/C transactions. The development process follows a systematic approach, commencing with the establishment of three fundamental assumptions to delineate the scope of the study. Subsequently, the database design progresses through stages involving Entity-Relationship Diagram (ERD) development, relational model construction, and normalization procedures. These steps collectively culminate in the creation of an intelligently structured database comprising thirteen distinct tables. In conclusion, this paper not only delves into the design and implementation of the L/C database but also showcases its practicality through real-world scenarios. The database, fueled by meticulous design and thoughtful implementation, is poised to revolutionize the management of L/C operations, offering enhanced efficiency and accuracy in international trade transactions.

The design of relational database and NoSQL database in travel agency database system

The information management systems of travel companies are experiencing greater challenges and expectations as a result of the tourism industrys rapid growth and travellers rising demand for personalized and interactive experiences. This paper aims to study the customer management system of travel agencies, taking into full consideration the characteristics and development trends of the tourism industry. Traditional customer management system uses relational database for data storage and related operations, which cannot fully meet the needs of customers and complex data in the new era. By analysing and comparing relational databases and NoSQL databases, according to their own advantages, a combined solution is proposed, which uses relational databases to store structured data and NoSQL databases to store unstructured data. On the basis of maintaining the original system management function, this solution greatly enhances the storage and processing of interactive data such as images and videos, and better meets the new demand of travel agency customers for sharing and interactive communication.

Database design for course selection and course grading system

In the context of global education, universities and institutions emphasize the importance of proficient academic information management systems. As traditional approaches to course data management become obsolete, there is a growing need to leverage digital transformation for academic management. This paper proposes a novel course database design that centralizes information about subjects, courses, staff, students, buildings, and grades. The database is designed to facilitate the overall academic progress of students by ensuring efficient record keeping, retrieval and updating. The architecture simplifies administrative tasks, underscores the importance of databases in modern educational institutions by providing in-depth student data to support personalized learning, enhance communication among stakeholders, and aid academic research. The conclusion of the experimental test is that a database designer should always ensure they pay attention to avoiding data redundancy and ensuring data diversity when processing data.