Database Design for Distribution Simulation Game

Abstract

Abstract The purpose of this study is to obtain a database design for a distribution simulation game that will be used as a learning medium in a industrial engineering. Distribution simulation games have been used since the 1960s, since the invention of the Beer Game by Jay Wright Forrester. The method used in this research is the System Development Life Cycle including the steps of enterprise modeling, conceptual data modeling, logical database design, physical database design, and database implementation. The results of this study are in the form of a relational database design consisting of five entities namely GameTitle, Retailer, Wholesaler, Distributor, and Maufacturer. GameTitle is a strong entity that owns the other four entities. The design can be implemented well in a Database Management System such as Microsoft Access, MySQL, or others. This database is used as data storage during the game and then used as a data source to analyze the effectiveness of understanding the concept of learning in industrial techniques such as forecasting, inventory planning, and supply chain management. The main conclusion that can be drawn in this study is that the database design for the distribution simulation game can be implemented using Microsoft Access with the condition that transaction data between echelon is stored in a separate table to avoid conflicts when accessing simultaneously. With this database design, it is expected that everyone can develop a distribution simulation game application for improving the learning process in their respective fields of study.