Abstract:Abstract: This activity was carried out on SMEs producing snacks from sweet potatoes, namely opaque located in Medan under the name UD. Opak Minang Yolanda. Based on the observations, several problems were found, namely…
the texture is too fragile so it breaks easily, the taste has only one taste (original taste), the size is too large and the packaging is too simple. This activity is intended to assist UD. Opak Minang Yolanda in solving the main problems as described previously.The specific target in this activity is to improve product by diversifying products including texture, taste, size, packaging. The methods used in this activity are observations, interviews and seeking information from various literatures in the form of books, articles in journals, newspapers, relevant magazines and searching online. This activity also used a coaching pattern. The achievement of this study is the idea of opaque diversification for improvement in the sustainability of UD. Opak Minang Yolanda is an improvement in texture by thickening the volume of the opaque when formed, flavors made into various variants that are tailored to consumer tastes, sizes are made into two variants, namely large and small, making the packaging more attractive.
Keywords: observation; opaque; snacks
Abstrak: Studi ini dilakukan pada UMKM di Medan yang menghasilkan opak yaitu makanan ringan dari ubi dengan nama UD. Opak Minang Yolanda. Berdasarkan hasil observasi ditemukan beberapa permasalahan yaitu tekstur (permukaan) yang terlalu rapuh sehingga mudah pecah, hanya satu rasa yaitu original, ukuran (bentuk) yang terlalu besar dan kemasan (bungkus) yang terlalu sederhana. Kegiatan ini bertujuan untuk membimbing UD. Opak Minang Yolanda dalam menyelesaikan kesulitan utamanya seperti yang diuraikan sebelumnya. Sasaran utama kegiatan ini adalah membenahi produk dengan diversifikasi produk meliputi tekstur, cita rasa, ukuran, kemasan. Metode yang dilakukan pada kegiatan ini adalah melangsungkan pengamatan, tanya jawab, dan menggali fakta-fakta dari berbagai referensi seperti buku, artikel pada jurnal, surat kabar, majalah yang relevan dan juga pencarian informasi secara online. Selain itu dilakukan pembinaan untuk merubah kualitas produk UD. Opak Minang Yolanda. Capaian luaran kegiatan ini adalah buah pikiran melalui diversifikasi opak untuk memperbaharui dan keberlanjutan UD. Opak Minang Yolanda yaitu pada tekstur dengan cara lebih menambah volume opak ketika dibentuk, cita rasa yang lebih bervarian yang disesuaikan dengan selera konsumen, ukuran menjadi 2 (dua) varian yaitu besar dan kecil serta menciptakan kemasan menjadi lebih menarik.
Kata kunci: makanan ringan; observasi; opak
Abstract:Abstract: The development of globalization and digitalization requires businesses to not only focus on product quality, but also on the ability to build and maintain long-term relationships with customers. Customer loyalty…
ty has become a strategic asset that influences business sustainability and competitiveness. Handmade Willy, a creative business engaged in the production and sale of handicrafts, faces various problems in customer management, such as difficulties in identifying customer preferences, limitations in ongoing communication, suboptimal customer segmentation, and the absence of a structured system for monitoring customer satisfaction and feedback. These problems have an impact on the ineffectiveness of marketing strategies and the potential decline in customer loyalty. This study aims to optimize customer relationships at Handmade Willy through the application of the Customer Relationship Management (CRM) concept. The research method used is descriptive analysis with a qualitative approach through data collection from observation, interviews, and literature studies. The blackbox testing results show that the system runs smoothly without any obstacles. The implementation of CRM helps Handmade Willy understand customer characteristics and preferences, perform more accurate segmentation, improve communication effectiveness, and systematically monitor customer satisfaction.
Keyword: customer loyalty; customer relationship management; handmade willy.
Abstrak: Perkembangan era globalisasi dan digitalisasi menuntut pelaku usaha untuk tidak hanya berfokus pada kualitas produk, tetapi juga pada kemampuan membangun dan mempertahankan hubungan jangka panjang dengan pelanggan. Loyalitas pelanggan menjadi aset strategis yang berpengaruh terhadap keberlanjutan dan daya saing bisnis. Handmade Willy sebagai usaha kreatif yang bergerak di bidang produksi dan penjualan kerajinan tangan menghadapi berbagai permasalahan dalam pengelolaan pelanggan seperti kesulitan dalam mengidentifikasi preferensi pelanggan, keterbatasan komunikasi berkelanjutan, belum optimalnya segmentasi pelanggan serta belum adanya sistem yang terstruktur untuk memantau kepuasan dan umpan balik pelanggan. Permasalahan tersebut berdampak pada kurang efektifnya strategi pemasaran dan potensi penurunan loyalitas pelanggan. Penelitian ini bertujuan untuk mengoptimalkan hubungan pelanggan pada Handmade Willy melalui penerapan konsep Customer Relationship Management (CRM). Metode penelitian yang digunakan adalah analisis deskriptif dengan pendekatan kualitatif melalui pengumpulan data observasi, wawancara dan studi literatur. Hasil pengujian blackbox menunjukkan sistem yang dibuat berjalan dengan lancar tanpa ada kendala. Dengan penerapan CRM mampu membantu Handmade Willy dalam memahami karakteristik dan preferensi pelanggan, melakukan segmentasi yang lebih tepat, meningkatkan efektivitas komunikasi serta memantau kepuasan pelanggan secara sistematis.
Kata kunci: customer relationship management; kerajinan tangan willy; loyalitas pelanggan.
Abstract:Abstract: The development of digital learning systems requires not only effective content delivery but also database consistency and performance, particularly when used at scale by lecturers and students. Weaknesses in database…
atabase design can lead to data duplication, relational violations, and transaction failures that compromise system reliability. This study designed the Royal Mengajar application using PHP and MySQL, supported by JavaScript, HTML, and Bootstrap 5. The Crowdsourced Academic Content model enables lecturers to contribute learning materials openly, while students evaluate them through a user rating system. The objective of this research is to design and optimize the database architecture of the Royal Mengajar application by implementing multiple control mechanisms—namely views, triggers, transactions, and constraints—to enhance data efficiency, consistency, and integrity in digital learning environments. Database optimization focuses on the use of views to improve query efficiency, triggers to maintain automatic consistency, transactions to ensure atomicity in multi-table operations, and constraints to preserve data integrity. The results show that views reduced the average query execution time to 0.12 seconds, triggers maintained consistency without manual intervention, and constraints achieved 100% referential integrity. The application of these mechanisms significantly improved system speed, reduced data redundancy, and enhanced information reliability, thus reinforcing the sustainability of Royal Mengajar as a community-driven learning platform
Keywords: crowdsourced academic content; constraint; database optimization; trigger.
Abstrak: Pengembangan sistem pembelajaran digital tidak hanya menuntut penyajian materi, tetapi juga konsistensi serta kinerja basis data ketika sistem digunakan secara masif oleh dosen dan mahasiswa. Kelemahan rancangan database dapat menimbulkan duplikasi data, pelanggaran relasi, dan kegagalan transaksi yang memengaruhi keandalan sistem. Penelitian ini merancang aplikasi Royal Mengajar berbasis PHP dan MySQL dengan dukungan JavaScript, HTML, dan Bootstrap 5. Model Crowdsourced Academic Content memungkinkan dosen berkontribusi secara terbuka, sedangkan mahasiswa melakukan evaluasi melalui user rating system. Tujuan penelitian ini adalah untuk merancang dan mengoptimalkan basis data aplikasi Royal Mengajar melalui penerapan berbagai mekanisme pengendali, seperti view, trigger, transaction, dan constraint, guna meningkatkan efisiensi, konsistensi, dan integritas data dalam sistem pembelajaran digital. Optimalisasi database difokuskan pada penerapan view untuk efisiensi query, trigger untuk menjaga konsistensi otomatis, transaction untuk memastikan atomicity pada operasi multi-tabel, serta constraint guna menjamin integritas data. Hasil pengujian menunjukkan view menurunkan rata-rata waktu eksekusi query menjadi 0,12 detik, trigger menjaga konsistensi tanpa intervensi manual, dan constraint memastikan integritas referensial tercapai 100%. Penerapan mekanisme ini berdampak pada peningkatan kecepatan sistem, berkurangnya redundansi, serta keandalan informasi yang lebih tinggi, sehingga mendukung keberlanjutan Royal Mengajar sebagai platform pembelajaran berbasis kontribusi komunitas.
Kata kunci: basis data; optimasi; trigger; constraint; crowdsourced academic content.
Abstract:Abstract: Preventing stunting in toddlers is crucial for improving children's health and growth. Stunting occurs due to chronic nutritional deficiencies during the first 1,000 days of a child's life, affecting their height,…
ht, cognitive development, and immune system, which can reduce their future potential. Fruits play an important role in a toddler's diet because they are rich in vitamins, minerals, fiber, antioxidants, and other bioactive compounds that support physical growth and brain development. However, selecting the right fruits is vital because some fruits can cause digestive issues or allergies in toddlers. To assist parents in choosing the right fruits, a mobile-based expert system using the Certainty Factor method has been developed. This system provides recommendations based on the toddler's health condition and evaluates the nutritional content of fruits. With this system, parents can ensure that their toddlers receive optimal nutrition, contributing to stunting prevention and ensuring that the toddlers grow up healthy, intelligent, and with full potential in the future Choosing the right fruits and maintaining a balanced nutrition are crucial parts of supporting the sustainability of stunting prevention efforts.
Keywords: certainty factor method; expert system; fruit selection; stunting prevention; toddler nutrition
Abstrak: Pencegahan stunting pada batita sangat penting untuk meningkatkan kualitas kesehatan dan pertumbuhan anak. Stunting terjadi akibat kekurangan gizi kronis pada 1.000 hari pertama kehidupan batita, memengaruhi tinggi badan, perkembangan kognitif, dan sistem imun anak, yang berisiko mengurangi potensi masa depan mereka. Buah-buahan memiliki peran penting dalam pola makan batita, karena kaya akan vitamin, mineral, serat, antioksidan, dan senyawa bioaktif yang mendukung pertumbuhan fisik dan perkembangan otak. Namun, pemilihan buah yang tepat sangat penting karena beberapa buah dapat menyebabkan masalah pencernaan atau alergi pada batita. Untuk membantu orang tua dalam memilih buah yang sesuai, dikembangkan sistem pakar berbasis mobile dengan metode Certainty Factor. Sistem ini memberikan rekomendasi berdasarkan kondisi kesehatan batita, serta mengevaluasi kandungan nutrisinya. Dengan sistem ini, orang tua dapat memastikan bahwa batita mendapatkan nutrisi yang optimal dengan berkontribusi dalam pencegahan stunting dengan memastikan batita tumbuh sehat, cerdas, dan memiliki potensi penuh di masa depan. Pemilihan buah yang tepat dan nutrisi yang seimbang menjadi bagian penting dalam mendukung upaya keberlanjutan pencegahan stunting.
Kata kunci: batita; metode certainty factor; pemilihan buah; pencegahan stunting; sistem cerdas
Abstract:Abstract: The design of Smart Village Enterprise Architecture for village government systems serves to support sustainability in facilitating the creation of Good Governance in a Village Government. One significant role…
in achieving Good Governance in a village is Education. Education plays a crucial role in enhancing and developing Good Governance and the SDGs values of a village. The conducted research focuses on the design of Enterprise Architecture of the Smart Village concept, with a focus on Village Services' dimension that specifically targets Education Services in a village in the Special Region of Yogyakarta. The research method utilized the TOGAF ADM 9.2 framework. The focus domain in this study includes the preliminary phase, architecture vision, business architecture, data architecture, application architecture, technology architecture, opportunities and solutions, and migration planning for the Education service in the Pagerharjo Village Government. The research result is an Enterprise Architecture blueprint as a solution to the issues that occur in the Education service in the Pagerharjo Village Government, along with an IT Roadmap as a reference for the village government in project development. It is hoped that the recommendations provided can enhance the Education services offered by the Pagerharjo village, thereby aiding the Pagerharjo Village Government in improving its score for the fourth SDGs, Quality Education.
Keywords: Enterprise Architecture, Smart Village, SDGs, TOGAF ADM 9.2.
Abstrak: Perancangan Enterprise Architecture Smart Village pada sistem pemerintahan Desa befungsi mendukung sustainability dalam membantu terciptanya Good Governance di suatu Pemerintahan Desa. Salah satu peranan penting terciptanya Good Governance di suatu Desa adalah Pendidikan. Pendidikan memiliki peran penting dalam peningkatan maupun pembangunan Good Governance dan nilai SDGs Desa. Penelitian yang dilakukan berfokus pada perancangan Enterprise Architecture konsep Smart Village dimensi Village Services yang berfokus pada Education Services di Desa Daerah Istimewa Yogyakarta. Metode penelitian dilakukan dengan menggunakan framework TOGAF ADM 9.2. Fokus domain yang diambil dalam penelitian ini mencakup fase preliminary phase, architecture vision, arsitektur bisnis, arsitektur data, arsitektur aplikasi, arsitektur teknologi, opportunities and solutions, dan migration planning pada layanan Pendidikan di Pemerintahan Desa Pagerharjo. Hasil dari penelitian yang dilakukan berupa blueprint Enterprise Architecture sebagai solusi dari permasalahan yang terjadi pada layanan Pendidikan di Pemerintahan Desa Pagerharjo serta IT Roadmap sebagai acuan Pemerintah Desa dalam melakukan pengembangan proyek. Diharapkan, rekomendasi yang diberikan dapat meningkatkan layanan Pendidikan yang disediakan oleh Desa Pagerharjo, sehingga mampu membantu Pemerintah Desa Pagerharjo meningkatkan score nilai SDGs ke-empat, Pendidikan yang Berkualitas.
Kata kunci: Enterprise Architecture, Smart Village, SDGs, TOGAF ADM 9.2
Abstract:Abstract: In its implementation, fiber optic is a cable that has fiber material that uses light as a transmission medium in sending data. The speed in data management becomes faster; there is the easy maintenance of tools.…
s. Handling this fiber optic disturbance, the company has complex data in big data wherein its management good processing is needed so that data redundancy does not occur. Still, accuracy and speed in data management are very important in big data management. Quality improvement for the company is the most important thing; even to achieve good quality, the company will do things that can support that quality; with the quality of the company being able to have long sustainability, a six sigma approach is carried out so that it can support quality improvements that the company can make.
Keywords: Big Data; Fiber Optic; Six Sigma
Abstrak : implementasinya fiber optic merupakan kabel yang memiliki bahan serat yang menggunakan cahaya sebagai media transmisi dalam mengikirimkan data sehingga kecepatan dalam pengelolaan data menjadi lebih cepat, terdapat kemudahan perawatan tools. Penanganan terhadap gangguan fiber optic ini perusahaan memiliki data yang kompleks dalam suatu bigdata dimana dalam pengelolaannya dibutuhkan suatu pengolahan yang baik agar tidak terjadi redudansi data, akan tetapi ketepatan dan kecepatan dalam pengelolaan data menjadi hal yang sangat penting dalam pengelolaan big data. Peningkatan kualitas bagi perusahaan menjadi hal yang paling penting, bahkan untuk mencapai kualitas yang baik perusahaan akan melakukan hal yang dapat menunjang kepada kualitas tersebut, dengan kualitas perusahaan dapat memiliki sustainable yang lama maka dilakukan pendekatan six sigma sehingga dapat mengdukung perbaikan kualitas yang dapat dilakukan oleh perusahaan.
Kata kunci : Big data; Fiber Optik; six Sigma
Abstract:Abstract: Information on the availability of marine fish culture seeds is very important for marine fish cultivators, because availability affects prices and the sustainability of ongoing operations that require a supply…
of marine fish. In addition, suppliers are required to be able to meet demand for supply and keep it in balance with market demand so that market prices remain stable. The most basic problem is that the order or request process carried out by marine fish cultivators is still placing orders directly at that location. In addition, the fish supply may not be sufficient. Of course, this will take a lot of time during the order or request process between marine fish cultivators and suppliers. Another problem with suppliers is that when they are ready to harvest the fish industry, they must also be able to provide it to all parties who need a supply of fish. The purpose of this research is to design and build a web-based supply and demand system for marine aquaculture products, which is expected to encourage the supply and demand process for marine aquaculture products. The method used to analyze needs / needs in this study is structured analysis to obtain design results based on user needs.
Keywords: information systems; results of marine fish farming; supply and demand system.
Abstrak: Informasi tentang ketersediaan bibit budidaya ikan laut sangat penting bagi pelaku pembudidaya ikan laut, karena ketersediaan mempengaruhi harga dan keberlangsungan operasi yang sedang berlangsung yang membutuhkan pasokan ikan laut. Selain itu, pemasok dituntut untuk dapat memenuhi permintaan penawaran dan menjaganya tetap seimbang dengan permintaan pasar agar harga pasar tetap stabil. Permasalahan yang paling mendasar adalah proses order atau request yang dilakukan oleh pembudidaya ikan laut masih melakukan order langsung ditempatkan di lokasi tersebut. Selain itu, pasokan ikan mungkin tidak mencukupi. Tentunya hal ini akan menyita banyak waktu saat proses pemesanan atau request antara pelaku pembudidaya ikan laut dan supplier. Masalah lain dengan pemasok adalah ketika mereka siap memanen industri ikan, mereka juga harus bisa menyediakannya kepada semua pihak yang membutuhkan pasokan ikan. Tujuan dari penelitian ini adalah merancang dan membangun sistem supply and demand produk budidaya ikan laut berbasis web, yang diharapkan dapat mendorong proses supply and demand produk budidaya ikan laut. Metode yang digunakan untuk menganalisis kebutuhan / kebutuhan dalam penelitian ini adalah analisis terstruktur untuk mendapatkan hasil perancangan berdasarkan kebutuhan pengguna.
Kata kunci: sistem informasi; supply and demand system; hasil budidaya ikan laut.
Abstract:Kutai Kartanegara Regency, East Kalimantan Province, has long depended on coal mining and petroleum as its primary economic drivers. This dependence creates structural vulnerability to global commodity price fluctuations…
and long-term sustainability challenges. This article presents a systematic literature review examining tourism as an alternative sector for regional economic transformation in Kutai Kartanegara. Drawing on 15 peer-reviewed studies from 2016–2024, the review synthesizes evidence on: (1) the role of tourism-led growth and its multiplier effects on local economies; (2) community-based tourism (CBT) as an inclusive development model; (3) structural transformation theory as a framework for economic diversification; and (4) the specific potentials and constraints facing tourism development in resource-dependent regions. The review finds that tourism exhibits significant forward and backward economic linkages, stimulates SME growth and creative economy, and can meaningfully reduce reliance on extractive industries. Key barriers include infrastructure gaps, limited human resource capacity, and suboptimal governance coordination. The findings provide a theoretical and empirical foundation for the ongoing field research into tourism's transformative role in Kutai Kartanegara's regional economy.
Abstract:This study analyzes the judicial reasoning behind Putusan Pengadilan Negeri Sidoarjo No. 199/Pid.Sus/2023/PN Sda, a landmark decision involving corporate criminal liability for environmental violations in Indonesia. The…
case centers on PT Surya Prima Semesta’s illegal disposal of hazardous waste (fly ash and bottom ash) without an environmental permit, resulting in the prosecution of its corporate director. Employing a normative juridical method, the research examines the court’s application of doctrines such as strict liability and identification theory within the framework of Law No. 32 of 2009 on Environmental Protection and Management. The findings show that the court adopted a formalistic, text-based legal reasoning model, treating permit violations as inherently punishable acts regardless of actual environmental harm. While the decision reinforces regulatory compliance and affirms corporate culpability, it lacks engagement with broader organizational responsibility and foundational environmental law principles like the precautionary principle and sustainability. This study argues for a more integrated doctrinal approach one that balances rule-based logic with value-oriented reasoning to enhance legal consistency, advance environmental justice, and align Indonesia’s corporate accountability framework with international standards.
Abstract:Public-private collaboration is a vital strategy in managing sustainable tourism destinations, integrating diverse stakeholders to balance economic growth, environmental sustainability, and social equity. Despite the hospitality…
pitality sector’s key role in tourism governance, research on its collaboration with public institutions, particularly in Makassar, Indonesia, remains limited. This study examines MaxOne Resort and Hotel Makassar to explore the mechanisms, challenges, and outcomes of public-private partnerships (PPPs) in sustainable tourism destination management (STDM). Using a qualitative case study approach, the research employs in-depth interviews, participatory observation, and policy analysis to investigate how MaxOne Resort collaborates with local government and communities to implement sustainability initiatives. The findings reveal that structured mechanisms such as formal agreements, joint projects, and stakeholder committees facilitate sustainable governance. MaxOne Resort actively engages in environmental conservation, community empowerment, and responsible tourism practices, positioning itself as a sustainability model within the hospitality sector. However, regulatory misalignments, funding constraints, and inconsistent stakeholder engagement present significant challenges. The study underscores the relevance of the Penta-Helix framework, highlighting how collaboration among government, private sector, academia, community, and media enhances the legitimacy and effectiveness of sustainability initiatives. This research contributes to the literature by providing a localized analysis of PPPs in Makassar, bridging the gap between theoretical models and practical applications. The findings offer policy recommendations to strengthen stakeholder collaboration, optimize governance structures, and support sustainable tourism development in emerging destinations.