Implementation of RDBMS in Establishing a Digital Repository for Schizophyllum Commune (Kurakding) Regional Knowledge

Abstract

Developing a relational database management system offers benefits such as organized data storage, efficient querying, data integrity, scalability, security, and enhanced collaboration. These advantages can collectively contribute to a comprehensive and reliable resource for Kurakding (<i>Schizophyllum Commune)</i> related information, catering to the needs of farmers, researchers, educators, enthusiasts, and other stakeholders. Kurakding, as known by the locals, is an edible and medicinally important mushroom, particularly popular in the Bicol Region of the Philippines, Southeast Asia. Rapid urbanization and growing populations threaten the mushroom’s natural habitat, leading to its scarcity and increased market value. Recognizing the potential benefits of Information Technology (IT) for agricultural development, a digital repository for Kurakding regional knowledge was implemented. The study employs a developmental and experimental research design, creating a DBMS from scratch and comparing its effectiveness against existing systems. The database development life cycle, which comprises five phases: requirements analysis, initial design, prototyping, data entry management, and full-pledged development, was strictly adopted during the design and development of the digital repository. Secondary data, research outputs, and interviews with stakeholders contributed to data gathering. Results include a conceptual framework and logical design for a KIS Repository, represented through Entity-Relationship Diagram (ERD). The ERD depicts entities such as User, Content, research, and statistics, facilitating user interaction, data management, and forum engagement. Database tables are designed to store user information, Kurakding statistics, research data, content, and forum interactions. Improving the database framework for integrating scientific data enhances its usefulness for diverse stakeholders in the Kurakding industry. This study emphasizes the importance of a digital repository in broadening knowledge about Kurakding and fostering stakeholder involvement. Ultimately, this study created a comprehensive and user-friendly resource for Kurakding-related information, facilitating its sustainable cultivation and utilization.