Design of integrated database of smart coffee enterprise support system for coffee small medium enterprise

Abstract

Coffee has great potential to improve the quality of life of farmers in Indonesia. In the business sector, demand for Indonesian coffee is suitable for the needs of both the local and the world market. However, the rising demand for world coffee and the high purchase prices have not been able to prosper farmers. Governance and trade procedure for the coffee industry, considering the simplification of the supply chain concept and information technology approach is necessary to be introduced. Coop Coffee stands for the Co-operative for the Indonesian Coffee is the business program from the Ministry of Co-operative & Small Medium Enterprises (SMEs) Of Republic of Indonesia, aims to improve the coffee farmers' wealth in co-operative bases as well as promote the Indonesian best coffee to the world. As a backbone, a Smart Coffee Enterprise Support System (SCESS) was developed to accompany the data transactions. The objective of this study was to design an integrated database of SCESS for coffee SME management. The database designed using relational database concept and visualized in the Entity Relationship Diagram with 14 entities and 15 relations, from the on-farm, off-farm, and market. The developed system was implemented to manage the coffee SME in Pelaga, Badung, Bali province. The SME has 24 Subak with 127 farmers, 168,924 hectares of area, and about 57.320 coffee tress. The integrated database system recorded the farmer name, address, their coffee farming facilities, and estimated yield, and finance loan from the government under the KUR (Kredit Usaha Rakyat).