Claim Missing Document
Check
Articles

Found 4 Documents
Search
Journal : Journal of Computer Science Advancements

Gas Store Data Analysis Using ERD Method and Constitutional Data Warehouse Model Risaldi, Fahmi; Terisia, Vany; Arman, Shevty Arbekti; Yusuf, Diana
Journal of Computer Science Advancements Vol. 1 No. 3 (2023)
Publisher : Yayasan Adra Karima Hubbi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70177/jsca.v1i3.540

Abstract

A data warehouse is a data storage system that plays a crucial role in business analysis. It collects, integrates, and stores data from multiple sources in a structured format, providing holistic insight into organizational performance. Entity-Relationship Model (ERD) is a visual tool for designing database structures. It uses entities to represent real-world objects and the relationships between them. ERD helps plan an efficient and coherent database design. A conceptual model is an abstract visual representation of information structures and relationships within a domain. It covers key concepts and business rules, assisting in building a solid foundation of understanding before technical designing begins. All three are interrelated in the development of successful information systems. Data warehouses use conceptual models to direct effective data storage design, while ERD helps describe the entities and relationships to be stored in the data warehouse. The combination of all three enables organizations to design, develop, and maintain adequate information systems, based on a deep understanding of data and its relationships. This results in better decision making, more efficient innovation, and optimal utilization of resources. The purpose of this study is to produce optimal data using the ERD method. The main objective is to explain how much data in an information system in the Company and how data management is crucial for effective decision making.
DESIGN OF A WEB-BASED GOODS DELIVERY INFORMATION SYSTEM WITH API SERVICES AND IOT INTEGRATION AT PT. ESA MANDIRI RUBBER Putri, Nadia Natasya; Terisia, Vany; Syamsu, Muhajir
Journal of Computer Science Advancements Vol. 3 No. 3 (2025)
Publisher : Yayasan Adra Karima Hubbi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70177/jsca.v3i3.2415

Abstract

The advancement of information technology has driven various industrial sectors, including manufacturing, to transform toward more efficient and responsive distribution systems. PT. Esa Mandiri Rubber, a rubber manufacturing company, still relies on manual processes in managing goods delivery, resulting in various issues such as delays, distribution errors, and a lack of transparency in tracking. This study aims to design a web-based goods delivery information system integrated with Internet of Things (IoT) technology and API services. The system development method used is the Waterfall method, which consists of five stages: requirement analysis, system design, implementation, testing, and maintenance. The developed system includes delivery recording, real-time tracking, IoT device data integration, and access to information through a web interface. The results of the study show that the designed system successfully replaces the previously used manual processes, enhances distribution effectiveness, and facilitates easier monitoring and reporting. Thus, this system is capable of improving operational efficiency and the quality of logistics services at PT. Esa Mandiri Rubber.
WEB-BASED FINANCIAL MANAGEMENT INFORMATION SYSTEM FOR MSMES USING RAD METHOD Rizky, Haikal; Terisia, Vany; Syamsu, Muhajir
Journal of Computer Science Advancements Vol. 3 No. 6 (2025)
Publisher : Yayasan Adra Karima Hubbi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70177/jsca.v3i6.2416

Abstract

Micro, Small, and Medium Enterprises (MSMEs), such as the Sukamurni Cracker Factory, often rely on manual financial recording, a practice prone to human error, data loss, and significant inefficiencies in generating financial reports. This research addresses these challenges by developing a web-based financial management information system tailored to the operational needs of MSMEs. The primary objective was to design and implement a system that improves the effectiveness, efficiency, and accuracy of financial record-keeping. The study employed the Rapid Application Development (RAD) methodology, encompassing requirements planning, user design, rapid construction, and system validation. The resulting system was built using the Laravel framework, PHP programming language, and a MySQL database. Functional validation was conducted through Black Box testing, which confirmed that all system modules—including income and expense tracking, automated report generation, and role-based access control for Admins and Staff—operate as specified. The novelty of this work lies in its practical application of the RAD model to create a user-centric and rapidly deployable solution for a resource-constrained MSME environment. This research provides a functional model for digital transformation in small-scale businesses, demonstrating that a well-designed system can significantly enhance operational efficiency and support strategic decision-making.
STUDENT GRADUATION PREDICTION USING DECISION TREE ALGORITHM WITH CRISP-DM METHOD (CASE STUDY: ITB AHMAD DAHLAN) Husni, Kholilah; Sestri, Elliya; Terisia, Vany
Journal of Computer Science Advancements Vol. 3 No. 5 (2025)
Publisher : Yayasan Adra Karima Hubbi

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.70177/jsca.v3i5.2429

Abstract

On-time graduation is an important indicator of higher education effectiveness; however, delays in student graduation are still observed at ITB Ahmad Dahlan Jakarta. This study develops a student graduation prediction system using the Cross-Industry Standard Process for Data Mining (CRISP-DM) methodology and the Decision Tree algorithm based on historical academic data. The model was built through six CRISP-DM stages, including problem understanding, data preparation, modeling, and evaluation. Testing results indicate high performance with an Accuracy of 97.44%, Precision of 97.14%, Recall of 100%, and F1-Score of 98.55%. This system has the potential to support strategic decision-making to enhance academic quality through data-driven approaches.