Abstract:Abstract: Information technology era requires speed and processing to obtain information. Users are required to quickly obtain and process information as needed. The use of the internet covers many fields of education but…
t the use of the internet also covers the scope of business and transactions. Development of internet technology is widely used in business and sales transactions. Because the internet can create new entrepreneurs. Internet-based social media is an application service that is widely used as a means for the purpose of publishing a service or product. In the implementation of the service, the pre-test method was used which was given to the mothers of the village of RT 03 RW 01 by giving a questionnaire to measure their understanding of social media. Furthermore, given the delivery of material on understanding social media and the internet. The next method is carried out in practice to implement it. This will provide benefits in understanding social media and the internet for business ventures, both businesses that are established individually or in groups. Because social media can be used as a promotional media, see market developments, provide experiences for consumers and serve as social media for competitors. The results obtained from this service, the community / village mothers have business facilities, namely using the social media Facebook. With this media, the native mothers of the village can promote or sell their products there..
Keywords: internet; social media; transactions
Abstrak: Era teknologi informasi memerlukan kecepatan dan pemrosesan untuk mendapatkan informasi. Pengguna dituntut untuk lebih cepat memperoleh dan mengolah informasi sesuai kebutuhan. Penggunaan internet mencangkup banyak bidang pendidikan tetapi penggunaan internet juga mencangkup lingkup bidang usaha dan transaksi.Perkembagan teknologi internet banyak digunakan dalam bidang usaha dan transaksi penjualan. Kerena internet bisa menciptakan para enterpreneur yang baru. Internet berbasis media sosial merupakan suatu layanan aplikasi yang banyak dimanfaatkan sebagai sarana untuk tujuan mempublikasikan suatu jasa atau produk. Dalam pelaksanaan pengabdian digunakan metode pra test yang diberikan kepada ibu-ibu tiban kampung RT 03 RW 01 dengan memberikan koesioner untuk mengukur pemahaman tentang media social. Selanjutnya diberikan penyampaian materi tentang pemahaman media social dan internet. Metode selanjutnya di lakukan pelaksaan prakterk untuk mengimplemantasikannya. Hal ini akan memberikan pemanfaatand dalam pemahaman media social dan internet untuk usaha bisnis, baik usaha yang didirikan secara individual maupun kelompok. Karena media sosial dapat dijadikan suatu media promosi, melihat perkembangan pasar, memberikan pengalaman bagi konsumen dan sebagai media sosial kompetitor. Hasil yang didapat dari pengabdian ini, masyarakat/ibu-ibu tiban kampung mempunyai sarana usaha yaitu menggunakan media sosial facebook. Dengan media tersebut ibu-ibu tiban kampung dapat mempromosikan atau menjual produknya di sana.
Kata kunci : media sosia; internet; transaksi
Abstract:Abstract : The application of the ITE Law in Indonesia must be understood by all groups, not least for students of SMA Negeri 3 Kisaran. Providing information to all students regarding the application of Law No. 11/2008…
on Information and Electronic Transactions (ITE) is a must to do, because now we see many school children vulnerable to violations of the ITE Law. The Information and Electronic Transaction Law (abbreviated as ITE Law) or Law number 11 of 2008 is the law that regulates information and electronic transactions, or information technology in general. This law has jurisdiction applicable to every person who commits legal acts as regulated in this Act, both within the territory of Indonesia and outside the jurisdiction of Indonesia, which has legal consequences in the jurisdiction of Indonesia and / or outside the jurisdiction of Indonesia and harm the interests of Indonesia. Many people want article 27 paragraph 3 in Law No. 11 of 2008 concerning Information and Electronic Transactions (ITE) for deletion. The reason is because article 27 paragraph 3 of the ITE Law which is commonly referred to as the rubber article is a dangerous law. Moreover, if applied by parties who do not understand about cyberspace.
Keywords: Application, Law
Abstrak : Penerapan UU ITE di Indonesia harus benar-benar dipahami semua kalangan tidak terkecuali juga bagi siswa dan siswi SMA Negeri 3 Kisaran. Memberikan informasi kepada seluruh siswa-siswi berkaitan penerapan UU Nomor 11 Tahun 2008 tentang Informasi dan Transaksi Elektronik (ITE) merupakan hal yang harus dilaksanakan, sebab saat ini kita lihat banyak anak sekolah rentan terhadap pelanggaran UU ITE. Undang-undang Informasi dan Transaksi Elektronik (disingkat UU ITE) atau Undang-undang nomor 11 Tahun 2008 adalah UU yang mengatur tentang informasi serta transaksi elektronik, atau teknologi informasi secara umum. UU ini memiliki yurisdiksi yang berlaku untuk setiap orang yang melakukan perbuatan hukum sebagaimana diatur dalam Undang-Undang ini, baik yang berada di wilayah Indonesia maupun di luar wilayah hukum Indonesia, yang memiliki akibat hukum di wilayah hukum Indonesia dan/atau di luar wilayah hukum Indonesia dan merugikan kepentingan Indonesia. Banyak kalangan menginginkan pasal 27 ayat 3 di Undang-undang No. 11 tahun 2008 tentang Informasi dan Transaksi Elektronik (ITE) untuk dihapus. Alasannya, karena pasal 27 ayat 3 UU ITE yang biasa disebut dengan pasal karet sebagai undang-undang yang berbahaya. Terlebih lagi jika diterapkan oleh pihak-pihak yang tak paham soal dunia maya.
Kata kunci: Penerapan, Undang-Undang
Abstract:Nowadays almost all aspects of life use technology. Progress in technology will also be accompanied by developments in information and communication technology. The development of technology and communication using internet…
net media that is widely used today is social media. Some people use social media for means of social integration, communication and publicizing activities, but in its development social media can also be used for business activities in terms of promotion and marketing. The use of social media for business activities has a very positive impact on improving the welfare of the community economically. To achieve these objectives, training and coaching to the public regarding the use of social media are held. The training was carried out at the Pesona Rhabayu Housing Community of Patam Lestari Village, Sekupang District, Batam. The training was conducted by monitoring and tutorials on how to use social media properly, including information dissemination on the Information and Electronic Transaction Law (UU ITE) so that the community has a legal basis for using social media. The first result of this dedication is that people's understanding of the ITE Law can be seen from discussions and questions and answers, secondly, people's ability to access and utilize social media for business facilities by forming a social media group as a forum for the community to promote their efforts.
Keywords: Law, social media and ITE
Abstract:Abstract: Toko Zuma faces challenges in optimizing customer relationship management and transaction recording due to conventional manual systems, which hinder real-time loyalty monitoring and sales analysis. This research…
h aims to design a digital Electronic Customer Relationship Management (E-CRM) system as an integrative solution for systematic and centralized management. The design method employs Unified Modeling Language (UML) for requirements analysis, user interface design, and Black-box Testing for validation. Results demonstrate a 100% success rate across all primary modules. The platform features Point Reward, automated transaction management, and live chat for direct interaction. Implementation enables personalized promotional strategies based on accurate data to increase customer retention. In conclusion, the Digital E-CRM system effectively automates business processes, serving as a strategic instrument for transparent and measurable customer relationship management.
Keywords: digital e-crm; relationship management; toko zuma; transaction activities.
Abstrak: Toko Zuma menghadapi kendala dalam optimalisasi manajemen hubungan pelanggan dan pencatatan transaksi karena masih menggunakan sistem manual konvensional. Penelitian ini bertujuan merancang sistem Electronic Customer Relationship Management (E-CRM) digital sebagai solusi integratif untuk pengelolaan basis data dan transaksi secara terpusat. Metode perancangan meliputi analisis kebutuhan menggunakan Unified Modeling Language (UML), desain antarmuka, dan validasi fungsional melalui Black-box Testing. Hasil pengujian menunjukkan tingkat keberhasilan 100% pada seluruh modul utama. Platform ini dilengkapi fitur Point Reward, manajemen transaksi otomatis, dan media interaksi live chat. Implementasi sistem ini memungkinkan strategi promosi personal berdasarkan data akurat untuk meningkatkan retensi pelanggan. Simpulannya, sistem E-CRM digital berhasil mengotomatisasi proses bisnis dan menjadi instrumen strategis dalam manajemen hubungan pelanggan yang transparan dan terukur.
Kata kunci: aktivitas transaksi; digital e-crm; pengelolaan relasi; toko zuma.
Abstract:Abstract: The development of information technology encourages retail businesses to manage customer and transaction data more effectively. However, many small-scale retailers still rely on manual record-keeping, resulting…
g in unintegrated data and limited decision-making support. This study aims to design and implement a web-based Electronic Customer Relationship Management (E-CRM) system called MySaffana for Saffana Gallery Boutique to optimize customer and transaction data management. The research method includes requirement analysis, system design using UML, implementation using PHP and MySQL, and system testing using black box testing. The results show that the MySaffana system is able to manage customer data, products, transactions, and sales reports in an integrated and efficient manner. System testing indicates that all main features function properly and meet user requirements. Therefore, the developed E-CRM system provides an effective and practical solution for strengthening data-driven decision-making in small-scale retail businesses.
Keywords: boutique; customer data management; customer profiling; E-CRM.
Abstrak: Perkembangan teknologi informasi mendorong usaha ritel untuk mengelola data pelanggan dan transaksi secara lebih efektif. Namun, banyak usaha ritel skala kecil masih melakukan pencatatan secara manual sehingga data tidak terintegrasi dan kurang optimal dalam mendukung keputusan. Penelitian ini bertujuan untuk merancang dan mengimplementasikan sistem Electronic Customer Relationship Management (E-CRM) berbasis web bernama MySaffana pada Butik Saffana Gallery yang dapat mengoptimalkan pengelolaan data pelanggan dan transaksi. Metode penelitian meliputi analisis kebutuhan, perancangan sistem menggunakan UML, implementasi dengan PHP dan MySQL, serta pengujian menggunakan metode black box testing. Hasil penelitian menunjukkan bahwa sistem MySaffana mampu mengelola data pelanggan, produk, transaksi, dan laporan penjualan secara terintegrasi dan efisien. Pengujian sistem membuktikan seluruh fitur berjalan sesuai fungsi dan kebutuhan pengguna. Dengan demikian, sistem E-CRM berbasis web ini dapat menjadi solusi yang efektif dalam mendukung pengelolaan data dan pengambilan keputusan berbasis data bagi usaha ritel skala kecil.
Kata kunci: butik; E-CRM; profil pelanggan; pengelolaan data pelanggan.
Abstract:Abstract: This research is motivated by the problem of building material inventory management at Jaqfar Building Store, which is still done manually and based on subjective estimates. This often results in inaccuracies in…
n determining stock levels, either in the form of overstock or understock, which hinders operational effectiveness. The purpose of this study is to apply the Multiple Linear Regression method to analyze the relationship between incoming stock (X1) and outgoing stock (X2) variables with the ending stock variable (Y) to produce an optimal inventory prediction model. The research methodology used includes collecting historical transaction data for building materials such as cement, ceramics, zinc, plywood, and iron. This web-based prediction system was developed using the PHP programming language and a MySQL database. The analysis results show that the resulting regression model can provide a mathematical picture of future inventory patterns based on historical data. Implementation of this system is expected to assist the management of Jaqfar Building Materials Store in making strategic decisions regarding purchasing and sales in a more measured and efficient manner.
Keyword: building materials; data mining; inventory; multiple linear regression
Abstrak: Penelitian ini dilatarbelakangi oleh permasalahan pengelolaan persediaan bahan bangunan di Toko Bangunan Jaqfar yang masih dilakukan secara manual dan berdasarkan perkiraan subjektif. Hal ini menyebabkan sering terjadinya ketidaktepatan dalam menentukan jumlah stok, baik berupa kelebihan barang (overstock) maupun kekurangan barang (understock) yang menghambat efektivitas operasional. Tujuan dari penelitian ini adalah menerapkan metode Multiple Linear Regression (Regresi Linear Berganda) untuk menganalisis hubungan antara variabel stok masuk (X1) dan stok keluar (X2) terhadap variabel stok akhir (Y) guna menghasilkan model prediksi persediaan yang optimal. Metodologi penelitian yang digunakan mencakup pengumpulan data historis transaksi bahan bangunan seperti semen, keramik, seng, triplek, dan besi. Sistem prediksi ini dikembangkan berbasis web menggunakan bahasa pemrograman PHP dan basis data MySQL. Hasil analisis menunjukkan bahwa model regresi yang dihasilkan mampu memberikan gambaran matematis mengenai pola persediaan di masa mendatang berdasarkan data historis. Implementasi sistem ini diharapkan dapat membantu manajemen Toko Bangunan Jaqfar dalam mengambil keputusan strategis terkait pembelian dan penjualan secara lebih terukur serta efisien.
Kata kunci: bahan bangunan; data mining; persediaan; regresi linear berganda
Abstract:Abstract: Storage media is an inseparable tool in everyday life. With storage media, users can store important data, both personal and workplace. In addition, in many cases, Indonesian law uses storage media as evidence.…
The Electronic Information and Transactions Law (UU ITE) regulates how the provision of digital evidence can be strong evidence in court. This study examines the forensics of digital evidence on storage media with four test scenarios. Digital forensic processing uses forensic processes based on the National Institute of Standards and Technology (NIST) guidelines. This study produces an analysis in which evidence processed with scenarios 1 and 4 is valid digital evidence to be submitted to court, while evidence 2 and 3 is invalid evidence. The results of this digital evidence can be used for investigations under the ITE law.
Keywords: autopssy; digital forensics; storage media; FTK Imager.
Abstrak: Media Penyimpanan merupakan alat yang tak terpisahkan dari kehidupan sehari-hari. Dengan Media Penyimpanan, pengguna dapat menyimpan data penting, baik pribadi maupun tempat kerja. Selain itu, dalam banyak kasus, hukum Indonesia menggunakan Media Penyimpanan sebagai alat bukti. Undang-Undang Informasi dan Transaksi Elektronik (UU ITE) mengatur bagaimana penyediaan alat bukti digital menjadi alat bukti yang kuat di pengadilan. Penelitian ini mengkaji forensik terhadap alat bukti digital pada Media Penyimpanan dengan empat skenario pengujian. Pemrosesan forensik digital menggunakan proses forensik berdasarkan panduan National Institute of Standards and Technology (NIST). Penelitian ini menghasilkan analisis di mana alat bukti yang diproses dengan skenario 1 dan 4 merupakan alat bukti digital yang sah untuk diajukan ke pengadilan, sedangkan alat bukti 2 dan 3 merupakan alat bukti yang tidak sah. Hasil dari barang bukti digital ini, dapat digunakan untuk penyelidikan didalam undang-undang ITE.
Kata kunci: otopsi; forensik digital; media penyimpanan; FTK Imager
Abstract:Abstract: The rapid development of digital technology has brought significant changes in consumption patterns and customer behavior, particularly in the fashion retail sector. Increasing competition and rising cynsumer expectations…
xpectations for fast, accurate, and technology-based services require businesses to innovate and undergo digital transformation. One widely used approach is the implementation of automation-based Electronic Customer Relationship Management (E-CRM). This study aims to analyze the implementation of E-CRM automation and its impact on service efficiency at Toko Diah Fashion, a fashion retail business that still faces service challenges due to manual systems, such as customer data duplication, delayed responses, and difficulty in monitoring transaction history. The research method used is a descriptive qualitative method with data collection techniques through observation, interviews, and documentation. The research focus is limited to aspects of service efficiency, including service speed, accuracy in managing customer data, and ease in customer follow-up. The E-CRM automation system studied is designed using PHP programming language and a MySQL database. The research results indicate that the implementation of E-CRM automation can significantly improve service efficiency. This system facilitates integrated customer data management, speeds up the service process, and supports more personalized communication through notification features and transaction history recording.
Keyword: automation; e-crm; fashion retail; service efficiency.
Abstrak: Perkembangan teknologi digital yang semakin pesat telah membawa perubahan signifikan dalam pola konsumsi dan perilaku pelanggan, khususnya dalam sektor ritel fashion. Persaingan yang semakin ketat serta meningkatnya ekspektasi konsumen terhadap layanan yang cepat, akurat dan berbasis teknologi menuntut pelaku usaha untuk melakukan inovasi dan transformasi digital. Salah satu pendekatan yang banyak digunakan adalah penerapan Electronic Customer Relationship Management (E-CRM) berbasis automasi. Penelitian ini bertujuan untuk menganalisis penerapan automasi E-CRM serta pengaruhnya terhadap efisiensi pelayanan pada Toko Diah Fashion, sebuah usaha ritel fashion yang masih menghadapi kendala pelayanan akibat sistem manual, seperti duplikasi data pelanggan, keterlambatan respons, dan kesulitan dalam pemantauan histori transaksi. Metode penelitian yang digunakan adalah metode kualitatif deskriptif dengan teknik pengumpulan data melalui observasi, wawancara, dan dokumentasi. Fokus penelitian dibatasi pada aspek efisiensi pelayanan, meliputi kecepatan pelayanan, ketepatan pengelolaan data pelanggan, serta kemudahan dalam tindak lanjut pelanggan. Sistem automasi E-CRM yang dikaji dirancang menggunakan bahasa pemrograman PHP dan basis data MySQL. Hasil penelitian menunjukkan bahwa penerapan automasi E-CRM mampu meningkatkan efisiensi pelayanan secara signifikan. Sistem ini mempermudah pengelolaan data pelanggan secara terintegrasi, mempercepat proses pelayanan, serta mendukung komunikasi yang lebih personal melalui fitur notifikasi dan pencatatan histori transaksi.
Kata kunci: automasi; e-crm; efisiensi pelayanan; ritel fashion.
Abstract:Abstract: Dazry Harapan Household Industry (IRT) is an SME in Jambi City specializing in the production of laundry perfume and previously relied on manual record-keeping using notebooks. This conventional method created…
several issues, including frequent stock recording errors, difficulties in preparing financial reports, delays in identifying minimum stock levels, and the absence of structured historical data. This study aims to develop a web-based digital recording system to improve efficiency, accuracy, and transparency in inventory management. The system was developed using the Agile (Scrum) methodology through three sprints covering the creation of login modules, stock and transaction recording, reporting, minimum-stock notifications, and interface refinement. System design was formulated using use case diagrams, flowcharts, database modeling, and interface prototypes based on the Laravel framework. User Acceptance Testing (UAT) demonstrated high user satisfaction, with 90% of respondents stating that the system is easy to use, 85% reporting faster administrative processes, and 95% acknowledging improved reporting accuracy. The system also increased recording efficiency by 66%—from 3 minutes to 1 minute per transaction—and reduced stock recording errors from 15% to 2% per month. The results indicate that implementing a web-based digital recording system significantly enhances the operational performance of SMEs.
Keywords: SMEs, digital recording system, Agile, inventory management, Laravel.
Abstrak: Industri Rumah Tangga (IRT) Dazry Harapan merupakan UMKM di Kota Jambi yang bergerak pada produksi parfum laundry dan masih menggunakan sistem pencatatan manual berbasis buku tulis. Metode konvensional tersebut menimbulkan berbagai permasalahan, seperti tingginya kesalahan pencatatan stok, hambatan dalam penyusunan laporan keuangan, keterlambatan identifikasi stok minimum, serta ketiadaan rekap data historis yang terstruktur. Penelitian ini bertujuan mengembangkan sistem pencatatan digital berbasis web untuk meningkatkan efisiensi, akurasi, dan transparansi manajemen persediaan. Pengembangan dilakukan menggunakan metode Agile (Scrum) melalui tiga sprint yang mencakup pembangunan modul login, pencatatan stok, transaksi, laporan, notifikasi stok minimum, serta penyempurnaan antarmuka. Desain sistem dirumuskan menggunakan use case diagram, flowchart, perancangan database, dan prototipe antarmuka berbasis Laravel. Hasil pengujian melalui User Acceptance Test (UAT) menunjukkan tingkat penerimaan pengguna yang tinggi, yaitu 90% menilai sistem mudah digunakan, 85% merasakan percepatan proses pencatatan, dan 95% menilai laporan yang dihasilkan lebih akurat. Efisiensi waktu pencatatan meningkat sebesar 66%, dari 3 menit menjadi 1 menit per transaksi, sedangkan tingkat kesalahan pencatatan menurun dari 15% menjadi 2% per bulan. Penelitian ini membuktikan bahwa implementasi sistem pencatatan digital berbasis web mampu meningkatkan kualitas operasional UMKM secara signifikan.
Kata kunci: UMKM; sistem pencatatan digital; Agile; manajemen stok; Laravel;
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.