Designing a Relational Database Model for Harvest Management Applications Using the Life Cycle Database Method

Abstract

Agriculture is one of the dominant sectors in people's income in Indonesia because the majority of
Indonesians work as farmers. However, Indonesian people who depend on agriculture for their income are
relatively mediocre because the price of the food commodity produced is not in line with expectations. One of
the factors that cause this is the poor delivery system from the place of production (agricultural location) to the
market. Therefore, an application is needed that can be a bridge for farmers in increasing the progress of the
economy in Indonesia. This paper focuses more on designing a model from a database that is built with the
concept of a life cycle database design. Database design methodology using DBLC (database life cycle).
Relational database design includes Conceptual Database Design, Logical Database Design, and Physical
Database Design. The final result of this study resulted in 6 tables, namely farmers, product types, products,
customers, transactions, and transaction details.