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: Land registration in Indonesia often encounters challenges in transparency, data integrity, and centralized bureaucracy. Manual and semi-digital systems remain vulnerable to manipulation and delays. The National…
l Land Agency has initiated digitalization, but several challenges remain, particularly in ensuring transparency, efficiency, and security of land ownership data. Blockchain technology offers a potential solution through its decentralized and immutable characteristics. This study adopted a design and development method consisting of system analysis, requirements identification, architecture design, implementation, and black-box testing. The developed decentralized application (DApp) integrates smart contracts, NFTs, and IPFS to manage land certificates. Core functions such as minting, transfer, splitting, and self-custody were implemented and successfully tested, with all scenarios producing expected results. The findings demonstrate that blockchain integration can enhance security, reduce duplication, and streamline land administration. The study contributes a functional prototype with practical implications for modernizing land registration in Indonesia while identifying scalability and regulatory adaptation as areas for further research.
Keywords: blockchain; decentralized application; land registration; NFT; smart contract.
Abstract:Abstract: The city of Surakarta is one of the cities that is busy with local and foreign tourists because there are various kinds of interesting cultural tourism. The large number of hotels with many services and facilities…
ies makes tourists confused in choosing a hotel, so prospective hotel guests need a long time to choose the best hotel according to their desired criteria. The aim of this research is to create a tool for prospective hotel guests in making decisions on hotel selection recommendations using the TOPSIS and SAW methods. This research uses 8 hotel data points in Laweyan District, Surakarta, and hotel data obtained from the Tourism Office. The results of the McCall Test with 5 indicators, namely accuracy, reliability, efficiency, integrity, and usability, average 86%, so this system is categorized as very good.
Keywords: hotel selection; TOPSIS; SAW; decision supporter system
Abstrak: Kota Surakarta menjadi salah satu kota yang ramai dikunjungi wisatawan lokal maupun mancanegara karena terdapat berbagai macam wisata budaya yang menarik. Banyaknya hotel dengan pelayanan dan fasilitas yang banyak membuat wisatawan kebingungan dalam memilih hotel, sehingga calon tamu hotel memerlukan waktu yang lama untuk memilih hotel terbaik sesuai kriteria yang diinginkan. Tujuan dari penelitian ini adalah membuat suatu alat bantu bagi calon tamu hotel dalam pengambilan keputusan rekomendasi pemilihan hotel menggunakan metode TOPSIS dan SAW. Penelitian ini menggunakan 10 titik data hotel yang ada di Kecamatan Laweyan Surakarta dan data hotel yang diperoleh dari Dinas Pariwisata. Hasil Uji McCall dengan 5 indikator yaitu akurasi, reliabilitas, efisiensi, integritas, dan kegunaan rata-rata 86%, maka sistem ini dikategorikan sangat baik.
Kata kunci: pemilihan hotel; TOPSIS; SAW; sistem penunjang keputusan
Abstract:Abstract: Sulaman Mayang's Industry has implemented a desktop-based system in data processing, a one-way system involving only one actor/user of the system. So that in use there are some new problems that have arisen that…
t affect the performance of services to customers. This study aims to analyze and test the quality of the Mayan embroidery information system using the McCall method. Analysis is carried out on several aspects of the product operation including the quality factors of correctness (truth), reliability (reliability), efficiency (efficiency), integrity (integrity) and usability (usability). Data was collected through questionnaires from 38 respondents involving workers/employees and customers. The results showed that overall the quality of the Sulaman Mayang information system was at the level of 76% (the quality of the information system was good according to the scale interpretation of the percentage of quality factors). Thus the quality of Mayang embroidery information systems needs to be improved in accordance with recommendations which are improvements to the quality of Mayan embroidery information systems.
Keywords: McCall Method; Sulaman Mayang; the quality of information system.
Abstrak: Industri Sulaman mayang sejauh ini menerapkan sistem berbasiskan dekstop dalam pengolahan data, sistem yang digunakan satu arah hanya melibatkan satu aktor/pengguna sistem saja. Sehingga dalam penggunaan ada beberapa persoalan baru yang bermunculan yang mempengaruhi kinerja layanan terhadap pelanggan. Penelitian ini bertujuan untuk menganalisa dan menguji kualitas sitem informasi sulaman mayang dengan meggunakan metode McCall. Analisa dilakukan terhadap beberapa aspek dalam product operation diantaranya faktor kualitas correctness (kebenaran), reliability (keandalan), effisiensy (efisien), integrity (integritas) dan usability (kegunaan). Data dikumpulkan melalui kuosioner dari 38 responden yang melibatkan pekerja/karyawan dan pelanggan. Hasil penelitian menunjukkan bahwa secara keseluruhan kualitas sistem informasi sulaman mayang berada pada level 76% (kualitas sistem informasi tersebut baik menurut skala penafsiran persentase faktor kualitas). Dengan demikian kualitas sistem informasi sulaman mayang perlu ditingkatkan sesuai dengan rekomendasi yang merupakan perbaikan kualitas sistem informasi sulaman mayang.
Kata kunci: kualitas sistem informasi; metode McCall; Sulaman Mayang
Abstract:The Indonesian capital market plays a pivotal role in mobilising long-term financing for corporations and providing investment opportunities to the public. However, persistent stock fraud cases undermine market integrity…
and investor confidence. This study aims to evaluate the effectiveness of the existing legal framework for investor protection against stock fraud, analyse its practical implementation, and recommend measures to strengthen both preventive and repressive mechanisms. Employing a normative legal research design with a qualitative approach, the study integrates statute, conceptual, and case approaches, focusing on Law No. 8 of 1995 on Capital Markets, OJK regulations, the Criminal Code, and notable cases such as PT Hanson International Tbk. The findings reveal that while the legal framework normatively aligns with the Legal Protection Theory, Justice Theory, and Legal Effectiveness Theory, substantial gaps remain between regulation and enforcement. Weak supervisory coordination, delayed intervention, lengthy judicial processes, and low investor legal literacy reduce effectiveness. Recommended reforms include adopting regtech and suptech, enhancing cross-agency data integration, implementing AI-based surveillance, establishing a specialised capital market court, and strengthening investor education. The study concludes that combining regulatory improvements, adaptive enforcement, and public legal empowerment is essential to safeguard investors, maintain market integrity, and promote sustainable economic growth.
Abstract:This study examines the role of public relations (PR) ethics in enhancing PT Kereta Api Indonesia's (PT KAI) competitive advantage in the railway industry. Ethical practices in PR are vital for fostering stakeholder trust,…
t, improving customer satisfaction, and enhancing employee engagement, all of which contribute to sustainable growth and market leadership. Adopting a qualitative research design and a case study approach, the research investigates how ethical principles such as transparency, integrity, equity, respect, and responsiveness are applied within PT KAI’s operational and strategic frameworks. Data collection involved document and thematic analyses, emphasizing ethical practices’ impact on stakeholder relationships and competitive outcomes. The findings highlight that PT KAI’s ethical initiatives strengthen its reputation, promote customer loyalty, and support a positive workplace environment. Despite these successes, challenges remain, including the absence of formalized ethical guidelines and the need for ethical leadership. The study concludes that integrating PR ethics into organizational culture enhances competitive advantage and ensures long-term sustainability in a dynamic market.
Abstract:This study explores the intricate relationship between corporate governance mechanisms—specifically Board Directors, Independent Commissioners, and the Audit Committee—and Accounting Conservatism, focusing on the moderating…
erating effects of Firm Size. The findings reveal that Board Directors have a statistically significant impact on Accounting Conservatism, primarily through their ability to provide oversight and challenge aggressive financial practices. However, the influence of Board Directors is moderated by Firm Size, as larger organizations often exhibit complexities that dilute their effectiveness. Similarly, the study underscores the pivotal role of Independent Commissioners in promoting conservative accounting practices. However, their impact is not amplified by Firm Size. The pressures faced by larger firms can lead to more aggressive financial reporting, thereby limiting the effectiveness of Independent Commissioners. Additionally, the Audit Committee is identified as a crucial governance mechanism in fostering Accounting Conservatism, but its effectiveness is also diminished in larger firms due to complex organizational structures. Overall, the research underscores the critical need for governance frameworks to be adaptive and tailored to the unique challenges posed by Firm Size. By recognizing and addressing these complexities, organizations can enhance the integrity and transparency of their financial reporting, thereby fostering trust among stakeholders and contributing to corporate accountability.
Abstract:This research aims to investigate the influence of earnings management practices on the value relevance of accounting information in the Indonesian business environment. The research method used is qualitative with a library…
rary study approach and document content analysis. Data was obtained through in-depth interviews with related parties such as auditors and financial managers, as well as analysis of the contents of documents in the form of financial reports and company meeting notes. The research results show that earnings management practices can reduce the value relevance of accounting information by affecting the quality of information conveyed in financial reports. Practices such as increasing revenue estimates or delaying expense recognition can cloud the picture of a company's true performance, which in turn affects economic decision making. These findings emphasize the importance of transparency and integrity in accounting practices to maintain the value relevance of accounting information for stakeholders. The implication of this research for accounting theory is the need to pay attention to earnings management practices within a broader theoretical framework regarding the integrity of accounting information. From a practical perspective, companies need to increase awareness of the importance of honest accounting practices and comply with applicable standards to minimize unethical earnings management practices. This implication is also relevant for regulators in strengthening regulations related to financial reporting in order to maintain the integrity of the capital market in Indonesia.
Abstract:Advances in information and communication technology have spurred substantial changes in legal transaction procedures in Indonesia, primarily through the utilization of electronic agreements. Agreements that were previously…
sly made in traditional paper formats are now frequently conducted digitally, raising legal concerns regarding their legality, validity, evidence, and legal protection for the involved parties, particularly consumers. Although electronic agreements are normatively recognized in the Civil Code (KUHP) and the Law on Electronic Information and Transactions, practical implementation issues persist, leading to legal uncertainty. This research employs a normative legal methodology utilizing statutory, conceptual, and comparative approaches. Data was obtained through a literature review of primary, secondary, and tertiary legal sources related to electronic agreements and civil legal protection. Qualitative descriptive analysis was conducted to investigate the legal status of electronic agreements and the legal protection available for the parties within the Indonesian legal framework. The discussion results indicate that electronic agreements possess legal validity and binding force equivalent to traditional agreements, provided they meet the criteria for a valid agreement as outlined in Article 1320 of the Civil Code and the provisions of the Information Technology Law. Legal protection in electronic agreements encompasses legal certainty, the recognition of electronic document and signature evidence, and consumer protection against detrimental standard clauses. Nevertheless, challenges remain in establishing party identification, ensuring the integrity of digital contracts, and addressing power imbalances between commercial entities and consumers. This study concludes that while electronic agreements are legally recognized under Indonesian civil law, enhancing legal protection requires strengthened regulations, consistent law enforcement, and improved legal and digital literacy among the public to ensure secure, fair, and equitable electronic transactions.
Abstract:The advancement of digital technology has brought significant changes to the legal system, particularly in the use of electronic evidence as a means of proof in court. However, the validity of digital forensic evidence is…
s often questioned due to various technical, procedural, and legal challenges. This study aims to analyze the factors contributing to the failure of digital forensic evidence in legal proceedings and to formulate recommendations for improving its validity. The method used is a Systematic Literature Review (SLR) by examining various academic sources that discuss issues of digital evidence validity, forensic standards, and emerging legal challenges. The results of the study indicate that the failure of digital evidence generally stems from non-compliance in the processes of data collection and preservation with chain of custody standards, insufficient competence of law enforcement officers in digital technical aspects, and conflicts between legal requirements and data privacy regulations, such as the GDPR and CCPA. The case study of online gambling 2020, at the South Jakarta District Court confirms that the absence of forensic verification and chain of custody documentation caused the digital evidence to lose its probative value. Therefore, it is necessary to establish standardized forensic procedures, provide training and certification for law enforcement officials and forensic experts, and develop national guidelines for managing digital evidence aligned with international standards. This research is expected to contribute to strengthening the integrity and validity of digital evidence, thereby enhancing the enforcement of justice in the digital era.