MySQL Database Research Articles

A Real Time Facial Recognition and Tracking System for Personnel Presence

Abstract: Our project aims to revolutionize the conventional attendance system by implementing a facial recognition-based solution. The existing manual methods are prone to human error and require significant maintenance. By leveraging facial recognition technology, our system will offer improved precision and efficiency, reducing the need for manual work. The system will maintain a database of students' images, matching them during class to mark attendance accurately. Utilizing machine learning techniques, specially the Haar-Cascade classifier and local binary pattern histogram method for face detection and recognition, respectively, our system will ensure reliable attendance tracking. The attendance data will be stored in a MySQL database and Microsoft Excel file, providing a streamlined and secure alternative to the traditional attendance process.

Smart Slot Assignment for Urban EV Charging Using Folium API Integration

Abstract: Efficient management of electric vehicle (EV) charging distribution in urban areas is crucial amid increasing demand and varying traffic conditions. This study proposes a novel web-based solution that integrates Folium Map API for realtime location tracking and Python Flask backend with MySQL database storage to allocate charging demands. By leveraging real-time traffic information from the Folium Map API, the proposed model optimizes charging resource allocation across multiple stations and road networks. The web interface, built using HTML, CSS, and JavaScript, allows users to interact with the system seamlessly. Charging allocation is dynamically adjusted based on real-time data, prioritizing maxi- mum returns. Additionally, an emergency charge counter facility is introduced to cater to unforeseen charging needs, enhancing user flexibility. The system offers two interfaces and a dashboard for both station administrators and users, en- abling pre-booking services for travelers during their journey, facilitating access to nearby charging stations, and providing a facility for prebooking. These features contribute to improved station revenue and pile utilization, highlighting the efficacy of the proposed web-based approach. By leveraging advanced web technologies and APIs, this comprehensive strategy enhances charging infrastructure efficiency, fosters the widespread adoption of electric vehicles, and contributes to sustainable urban mobility management.

Design of Web-based Report Card Processing Information System at MTS Negeri 4 Kebumen

Based on observations made, the processing of report card scores in MTs N 4 Kebumen is currently still manual, so a lot of time and energy is needed to carry out the task. In addition, the distribution of report cards is also still conventional because parents must come to school to take them, for this reason, a report card application is needed that can improve services to students quickly in terms of distributing report card scores while making it easier for teachers to fill in report cards. The purpose of this study is to design a web-based value processing application. In designing this application, the author uses the stages of SDLC development with the Waterfall process model. The design of this web-based report card processing information system can improve the quality of report card processing in MTs N 4 Kebumen. The programming language that the author uses is PHP and uses a MySQL database. To test the feasibility of the system, the authors used blak bock testing. The final result of this research is the creation of a web-based MTs N 4 Kebumen report card application.

OTOMATISASI ADMINISTRASI KEPENDUDUKAN BERBASIS WEB

Abstract: This study aims to design and build a Web-Based Population Automatic Archive Application for the Brang Kolong Village Office which can facilitate village officials in archiving population data. However, the system still does not have features designed for archiving population data, with the Web-Based Population Auto-Archive Application it can facilitate the process of archiving population data. As well as being a storage medium for data and information about population data. Web-based applications are built using the help of the PHP language and MySQL database using Laravel as a framework. System planning uses object-oriented methods by defining UML designs such as Use Cases, Activity Diagrams, Sequence Diagrams, and Class Diagrams. And tested using the BlackBox Testing method

Information System for Operational Goods Management at the Career Guidance and Entrepreneurship Center Malikussaleh University

Managing operational goods manually leads to slow and inefficient work performance, hence the design and implementation of an information system that can efficiently manage operational goods needs to be done in a structured manner and work optimally. Analysis of operational goods needs is conducted through observation and interviews with relevant parties to discuss the problems faced and identify the required features. Some key features implemented in this system include complaint management for operational goods needs, which can be managed and utilized for effective procurement or requests for goods according to requirements. This system is designed using the PHP programming language with the Codeigniter framework and MySQL database for database management. With this system in place, it is expected to assist in the more effective and systematic management of operational goods needs at the Career Guidance and Entrepreneurship Center of Malikussaleh University.

Custom Application Booking Information System at PT Mitra Tekno Nusantara

Information systems can provide strategic opportunities in facing business competition when implemented to support a business process. PT. Mitra Tekno Nusantara (PT. MTN) is a company engaged in the Information Technology sector that produces various kinds of software and hardware. The process of recording custom application order transactions that are still manual has weaknesses in terms of speed of recording transaction processes. In addition, the deadline on a project is rarely monitored so that there are projects whose progress exceeds the specified time target. This of course of course from customers. To fix this problem, the researcher proposes to design a website-based computerized system to manage custom application order transaction data at PT. MTN. The design of the custom application ordering information system that the author proposes is made using the PHP Native programming language and MySQL database. The proposed information system design uses the Software Development Life Cycle (SDLC) method with the Waterfall model. With the design of this custom application ordering system, it is hoped that it will make it easier for admins to record transaction data for custom application orders. In addition, it makes it easier for the project head to monitor the deadline date of each project being worked on.

Web-Based Community Data Collection Information System at the Central Statistics Agency of Sragen Regency

The community data collection information system is a technological solution designed to efficiently collect, manage, and analyze information from various layers of the community. The main objective of this system is to support data-driven decision-making by facilitating the collection of accurate, fast, and measurable information. The limitation of manual community data collection at the Central Statistics Agency (Badan Pusat Statistik) in Sragen Regency has led to data damage, loss of data, and ambiguity in data due to the information being written on questionnaire papers using pencils. Due to the abundance of population data that needs to be stored and to support the performance of officers, there is a need for a computerized web-based system as a tool for officers to carry out their activities. The aim of this research is to design a Web-Based Community Data Collection Information System at the Central Statistics Agency in Sragen Regency. The researcher uses the Waterfall method in the system development process and the PHP programming language, along with the MySQL database. The system designed by the researcher is expected to produce an application that can accommodate all community data accessible via the web by administrators and field officers at the Central Statistics Agency in Sragen Regency.

Information System for the Inventory of Census Needs at the Central Statistics Agency of Sragen Regency

The inventory system is a system used to input inventory data into a database to avoid errors in entering, retrieving, and losing inventory data. The limitation of manual inventory recording for census purposes at the Central Statistics Agency (Badan Pusat Statistik) in Sragen Regency causes a relatively long reporting time for inventory and the possibility of errors in data collection. To support the performance of employees, a computerized system is needed as a tool for employees to carry out their activities. Considering the increasing amount of inventory data that needs to be stored at the Central Statistics Agency in Sragen Regency, there is a need for a web-based inventory information system for census purposes. The aim of this research is to design an inventory information system for the needs of the census at the Central Statistics Agency in Sragen Regency. The author uses the Waterfall method in the system development process and the PHP programming language, along with the MySQL database. The system designed by the author is expected to produce an application that can record inventory accessible via the web so that the leadership can directly see the inventory at the Central Statistics Agency in Sragen Regency.

Design of Web-Based Customer Savings Data Information System at Sumber Rejeki Jaya Abadi Cooperative Klaten

Koperasi Sumber Rejeki Jaya Abadi is a business entity engaged in financial savings and loans in Klaten Regency. Customers in the cooperative are required to have savings and before applying for loans, they must conduct deposit transactions and maintain a savings account.The cooperative faces issues with manual recording of customer savings transactions, where data is recorded using physical books. This manual process leads to inconsistent data and inefficiency in managing customer savings transactions since data must be accessed one book at a time. Additionally, the use of physical books for reporting transactions means that the reporting process lacks organization. To address these challenges, the author utilizes the System Development Life Cycle (SDLC) methodology in developing the information system. The system is being built using the PHP programming language with the Laravel framework and utilizes the MySQL database. The primary objective of this research is to create an information system that can assist the administration department in managing customer savings at Koperasi Sumber Rejeki Jaya Abadi in Klaten. By implementing the new system, the cooperative aims to improve data consistency and the efficiency of customer savings transactions, eliminating the need to search through physical books, and enhancing the overall reporting process.

Pengembangan Sistem E-learning Berbasis Web Pada Sekolah Tingi Teknologi Informatika Sony Sugema

Sony Sugema College of Information Technology is one of the educational institutions that has a data processing system, so it requires that all data can be processed properly, stored in an orderly manner and its origin can be easily traced. However, the academic system used still has shortcomings, namely not optimal course participation, management of student data, teacher data, course schedules, course allocation and the absence of an online learning system throughout the semester. Then, to overcome deficiencies in the academic system, the author aims to develop the academic system of the Sony Sugema College of Information Technology using the Waterfall software development method. Then develop a system using the Hypertext Preprocessor (PHP) programming language, MySQL database and bootstrap framework, as well as Visual Studio Code as a coding tool. By creating this information system, it is hoped that it can help schools in managing learning data. The final result of this research is a web-based E-learning system that can optimize attendance information services, manage student data, lecturer data, lecture schedules, course classification, course division, and online learning systems during the semester period.

Turf Tracker Application

Abstract: To solve the Sports venues booking problems, Turf Tracker Application is designed, combining the experience of the existing online booking systems, the main methods and the major ideal of building these systems in different cities. The basic functions of the system are designed according to the general requirement analysis, including user's registration and login, online sports venue booking, personal center and database construction. The development of the system used Java programming language, J2EE for backend development, Spring Boot (a Web platform development technology), MySQL database processing technology, ReactJS for frontend and Visual Studio Code. The system has accomplished such functions as online Turf booking, view user bookings, add grounds, add indoor court and view grounds/court. The tests of the system are run in good conditions. The use of the system has made up for the current luck of sports venues management, solved the problems of the online booking of sports venues, improved the efficiency of the venues and meet the needs of efficient use of the venues.

Perancangan Sistem Informasi Perpustakaan Berbasis Web SMK Negeri 3 Karawang

Perancangan Sistem Informasi Perpustakaan Berbasis Web SMK Negeri 3 Karawang

Pengembangan Aplikasi Absensi Siswa Berbasis Web Pada SMKN 1 Karawang

The Student Attendance System application is a platform that provides information regarding student attendance records at school. At SMKN 1 Karawang, the process of recording student attendance has been carried out manually, starting from recording student attendance, managing attendance data, to preparing the final report. Manual approach This has proven to be less efficient and often produces inaccurate attendance data. Other problems that often arise related to document archiving include loss of notebooks or archives, difficulties in searching for data, and damage to archives. The aim of this research is to design a student attendance system that can makes it easier to manage student attendance data, especially by utilizing a web-based student attendance information system. This approach involves the use of Waterfall model development software and the PHP programming language with a MySQL database. The advantages and results of this web-based student attendance information system are that it provides a variety of features that will make it easier for teachers to manage student attendance data.

The Mode Exploration of Combining Chinese Traditional Culture Content with Computer Aided Instruction in Moral Education of Colleges and Universities

According to the characteristics of learning style, this paper classifies the traditional cultural classics according to the school. Audio, video, text, pictures and other forms are collected to match students' learning styles. The system uses the three-layer structure of My Batis+ Spring MVC, and uses Ajax+ Free marker+ JS technology, MySQL database, Apache Tomcat8 manager, Eclipse development platform, WebStorm and other network front-end development tools. In addition, auxiliary tools such as Camtasia Studio and PhotoshopCS5 are used to generate prototype systems for traditional culture learning. Its data processing is fast.

Assessment of training data on visual acuity of evaluators in plant diseases, carried out through the web tool SiTAV

The present study analyzed the data compiled after the training of the precision and visual accuracy of the evaluators of both genders in plant diseases, using the SiTAV (Visual Acuity Training System) website. The training data were analyzed through the exploratory analysis, with the aid of the statistical program SAS 9.4. With 52,495 training data being stored in the system's MySQL database identified. The tabulation of training data ranked the evaluations in three classes of accuracy of major hits (underestimated, precise and overestimated), where 30.36% (15.938) training were classified as accurate. The distribution of training data between accuracy classes and five hit categories (excellent, optimal, good, fair and poor) indicated that the level of excellent severity obtained 30.04% (15,772) of training data of the six levels of severity, level 1 (0 to 3% of real severity) reached 33.31% (17,486) of training data. It is concluded that the smaller the lesion size of plant diseases, the greater the accuracy of the evaluator.

Web Scraping for E-Commerce Websites

e internet is a rapidly expanding environment where a vast amount of info is available, yet obtaining it might be challenging. Web scraping is therefore a crucial technique for obtaining data.Data can be extracted from different websites using a process called web scraping. Depending on the technology used, end users can obtain the data in spreadsheet, csv, json, xml, and database forms. Numerous fields, including e-commerce, market research, brand monitoring, and others, use web scraping.Our solution suggests a way to compare product details that are retrieved from e-commerce websites.Various tools are used for data extraction, including BeautifulSoup, Selenium, Scrapy, and others. BeautifulSoup is used by our system to extract data. Data is stored in a MySQL database following extraction. Our webapp then presents this data in a format that is similar. It takes time to visit each website individually and compare product details; therefore, in order to help the user compare products, our system will show all of the product details from different websites.

Improving Inventory Control Through a Web-Based System in a Retail Company

Background Currently, retail companies that fail to digitise their logistics processes experience difficulties in controlling stock, resulting in inaccuracies in the quantity of products and excess amounts in the warehouse. Consequently, the aim was to introduce a web-based system to enhance inventory control in retail firms within the city of Huaraz. Methods The Extreme Programming methodology was implemented in four phases. During the planning phase, roles and user stories were established. In the coding phase, Hypertext Preprocessor and JavaScript programming languages were utilised alongside the MySQL database management system. The testing phase involved evaluating each interface’s functionality to ensure that it was a part of the web system. The objective of this was to develop the web system and utilise it as an inventory control tool. Results The utilization of the web-based system within the logistics sector led to enhanced indicators, as seen through a 52.94% increase in inventory precision rate and 91.94% rise in the stock turnover rate. Conclusions The web system facilitates the minimisation of input errors in product quantity records while also enabling visualisation of such data. It further provides an illustrated representation, in the form of a bar graph, of each product’s indicator behaviour.

Design and evaluation of a web-based electronic health record for amblyopia.

Amblyopia, or lazy eye, is a type of visual impairment in which the eyesight is not complete, even with the use of glasses. For the treatment of this disease, accurate and continuous examinations are needed. Nowadays, patient-centered care, by relying on web-based electronic records for amblyopia, has the potential to reduce treatment costs, increase the quality of care, and improve the safety and effectiveness of treatment. Therefore, the purpose of this study is to design and evaluate an Electronic Health Record (EHR) for patients with amblyopia. The present study is applied developmental research. Using a Morgan table as a sampling tool, a straightforward random sampling technique selected 150 records from 1,500 records that were free of flaws. The design of the electronic version proceeded in a cascading manner so that after the design of each part, it was presented to the amblyopia experts, and if approved, the next part was designed. To design this EHR, the C# programming language and MySQL database were used. A system evaluation was performed by entering and recording patient information. For this purpose, the standard Questionnaire of User Interaction Satisfaction (QUIS), consisting of 18 questions, was used. According to the amblyopia EHR data elements, the data of physician and patient, examinations, website members, and members' roles were determined. After defining the fields and classes that explain the tables, the EHR was designed. The usability evaluation of the system showed that the mean selection of very good and good options by the users of EHRs was over 90%, indicating the patients' acceptance of web-based EHRs. The design of an EHR for amblyopia is an effective step toward integrating and improving the information management of these patients. It will also enable the storage and retrieval of patients' information to reduce and facilitate the control of amblyopia complications.

IMPLEMENTASI SISTEM PRESENSI BERBASIS IOT (INTERNET OF THINGS) MENGGUNAKAN PLATFORM BLYNK DI SMK CENDIKIA RANCAKALONG

An IoT (Internet of Things) based attendance system using the Blynk Platform with NodeMCU and ESP32-CAM is a teacher attendance management and monitoring system. This system combines Radio Frequency Identification (RFID) technology for time and attendance detection, NodeMCU and ESP32-CAM microcontroller hardware for data processing, and a MySQL database for storage and management of time and attendance data. Using an RFID card, teachers can easily record attendance via a reader connected to the NodeMCU, and the ESP32-CAM provides the ability to capture facial images as an additional verification step. Attendance data is stored in a MySQL database in a structured manner, enabling efficient data management and accurate attendance reporting.

Design and Build Features Chat on Renting Book Application Based Web Technology

This research is motivated by the development of innovation in the field of technology from time to time. The existence of a book rental application makes it easy for users to carry out book rental activities, users need communication so that rental activities can run well. Communication is needed to exchange messages between message senders and message recipients, chat features are needed in book rental applications. The addition of the chat feature to the book rental application is needed so that communication between tenants and landlords can be easily carried out and run well. By using the PHP programming language and mySql database to organize, store, and manage the data needed in application design, it is hoped that it can be developed by developers easily so that applications can run on mobile devices so that applications can be used on all devices. This study uses the literature study method and also from the author's observations on chat applications that currently exist. In its implementation, this feature works well and efficiently, the result is that users can communicate between users in the book rental application