Sistema de gestión para las inversiones de Suelos del Ministerio de la Agricultura en Granma

Various processes are carried out in the Soil and Fertilizer Department of the Ministry of Agriculture at Granma's province in Cuba, including information management for investment approval. It becomes difficult due to the fact that it is carried out manually and through printed models, leading to insufficiencies in the personnel in charge of recording the information, difficulty in preserving relevant information and delay in the response process. In response to these needs, in this investigation, an informatics system is developed that will enrich the management of the information for the approval of investments of Soils and Fertilizers in Granma. For the development of the system was utilized as methodology of development of software Extreme Programming (XP). PHP 7.3.3 and SQL as server-side, client-side programming languages HTML 5, CSS 3, JavaScript and JQuery 1.2.2. APACHE 2.4.38 web application server, MySQL 5.0.12 as Database manager, CodeIgniter 3.1.10 as Framework and DBDesigner 4 as an aid to database modeling. As a result of investigation, a system validated by means of proofs of software was obtained, which vouch for his correct functioning.

Exploring Feedback and Gamification in a Data Modeling Learning Tool

Data modeling is an essential part of IT studies. Learning how to design and structure a database is important when storing data in a relational database and is common practice in the IT industry. Most students need much practice and tutoring to master the skill of data modeling and database design. When a student is in a learning process, feedback is important. As class sizes grow and teaching is no longer campus based only, providing feedback to each individual student may be difficult. Our study proposes a tool to use when introducing database modeling to students. We have developed a web-based tool named LearnER to teach basic data modeling skills, in a collaborative project between the University of South-Eastern Norway (USN) and Kristiania University College (KUC). The tool has been used in six different courses over a period of four academic years. In LearnER, the student solves modeling assignments with different levels of difficulty. When they are done, or they need help, they receive automated feedback including visual cues. To increase the motivation for solving many assignments, LearnER also includes gamifying elements. Each assignment has a maximum score. When students ask for help, points are deducted from the score. When students manage to solve many assignments with little help, they may end up at a leaderboard. This paper tries to summarize how the students use and experience LearnER. We look to see if the students find the exercises interesting, useful and of reasonable difficulty. Further, we investigate if the automated feedback is valuable, and if the gamifying elements contribute to their learning. As we have made additions and refinements to LearnER over several years, we also compare student responses on surveys and interviews during these years. In addition, we analyze usage data extracted from the application to learn more about student activity. The results are promising. We find that student activity increases in newer versions of LearnER. Most students report that the received feedback helps them to correct mistakes when solving modeling assignments. The gamifying elements are also well received. Based on LearnER usage data, we find and describe typical errors the students do and what types of assignments they prefer to solve.

Tridimensional geotechnical database modeling as a subsidy to the standardization of geospatial geotechnical data

Geotechnical data is often produced and managed by several producers in isolation, in their own formats and standards, which aim to meet the unique needs of specific users, because there is not a defined geospatial geotechnical data storage standard. This article presents the physical implementation of a three-dimensional geotechnical database, based on a data model generated using the Object Modeling Technique for Geographic Applications, composed of information produced by the academy and various administrative institutions of the Federal District Government. More than four thousand quantitative e qualitative geotechnical investigations are available in this structured database that can be accessed by anyone with some geographic information system knowledge using QGIS. Considering that the compiled information was stored by their producers in distinct formats and most of them in a non-digital and without locational information, this work reinforces the need to adoption a standardization of geospatial geotechnical data storage on a unified basis compatible with the National Spatial Data Bank to disseminate this information.

Textual-based DSL for Conceptual Database Modeling: A Controlled Experiment

The variety of database system technologies that have become available in recent years makes it difficult to select tools for entity-relationship modeling (ER) in the teaching-learning context. This paper reports a replicated controlled experiment carried out with 33 subjects in order to compare effort spent (time) and quality, using the harmonic average between precision and recall, of the models produced with two different approaches. The models were produced in a proposed tool (ERtext) with a textual-based DSL and in another tool with a graphical approach (brModelo). Briefly, the data obtained indicate: i) both approaches present similar performance in relation to associated effort, and; ii) that there is a statistically significant difference in relation to the quality of the generated models, with a slightly advantage for the textual approach. Therefore, we conclude that the use of a textual-based DSL is feasible and our proposal is an acceptable solution in the context of conceptual database modeling.

Research on college gymnastics teaching model based on multimedia image and image texture feature analysis

With the rapid development of gymnastics technology, novel movements are also emerging. Due to the emergence of various complicated new movements, higher requirements are put forward for college gymnastics teaching. Therefore, it is necessary to combine the multimedia simulation technology to construct the human body rigid model and combine the image texture features to display the simulation image in texture form. In the study, GeBOD morphological database modeling was used to provide the data needed for the modeling of the whole-body human body of the joint and used for dynamics simulation. Simultaneously, in order to analyze and summarize the technical essentials of the innovative action, this experiment compared and analyzed the hem stage of the cross-headstand movement of the subject and the hem stage of the 180° movement. Research shows that the method proposed in this paper has certain practical effects.

PEMETAAN POTENSI WILAYAH WILAYAH HOME INDUSTRY DI KECAMATAN GIRIMARTO KABUPATEN WONOGIRI

Some residents in Girimarto sub-district make industrial businesses their main source of livelihood. The lack of information about the home industry in the Girimarto District area results in a less than optimal marketing of industrial products and the sale of products produced only around Wonogiri Regency. In addition, the inequality in the provision of facilities from the government has resulted in the very slow development of home industries.Based on these problems, an application will be made system geographic informality mapping the potential of a home industry in the District of Girimarto to provide information on existing home industries and grouping data using a Fuzzy tahani model database modeling to provide the results of classification of home industry data based on variable number of production per year, number of workers and the amount of turnover per year. The results of this system classification / grouping of home industry data in accordance with selected criteria with the highest fire strength value 1 from (interval 0-1). Hopefully this application can help provide information to the public about the home industry in the District of Girimarto and be able to classify home industry data so that it can be used as a decision-making material in how to develop the industry.

Students' Difficulties in Identifying the Use of Ternary Relationships in Data Modeling

The present study examines the difficulties novice data modelers face when asked to provide a data model addressing a given problem. In order to map these difficulties and their causes, two short data modeling problems were given to 82 students who had completed an introductory course in database modeling. Both problems involve three entity sets with relationships between them, either ternary or binary. The students' solutions were classified according to the types of errors they committed. More than half of the students provided faulty solutions. After an analysis of these results, open interviews were conducted with a selected group of students in order to figure out the reasons underlying the students' erroneous decisions regarding the data model. Among the reasons for their erroneous solutions were insufficient experience, lack of reflection on their solution, and lack of immediate feedback. In addition, the authors suggest instructional modifications derived from the research results.

A proposal for pharmacovigilance data restructuring at the teaching hospital

Introduction: The increasing volume of pharmacovigilance data froom reports of Adverse Drug Reaction (ADR) indicates the need for a database (DB) to manage its electronic records. Objective: Thus, the objective of the present study is to prepare a prototype computing environment that will permit data recording, storage and recovery aimed at generating information and creating an effective database within the Pharmacovigilance Unit of the Professor Edgard Santos Teaching Hospital in Salvador, Bahia, Brazil. Methods: This descriptive study managed by pharmacists and development systems professionals whose object of study was based on preexisting electronic spread sheets used to store data on adverse drug reactions since 2000. The work consisted of three principal steps: the normalization of the data, relationships between the data collected, and database modeling with implementation of the information system. Results: This restructuring allows a database to be consolidated quickly and consistently, with reliable data duly completed and analyzed. Conclusion: Thus, the HUPES Pharmacovigilance Information System (SIFAVI) was modeled, which integrates into a web application na easy mechanism for storing and recovering the data stored in the database. This also permits the data on adverse drug reactions to be categorized and crosschecked, enabling more precise inferences to be made, thus rendering this practice simpler for users and improving the culture of notifying and validating adverse drug reactions.