Database System For Revenue Management of Digital Innovation and Transformation Center, College of Arts, Media and Technology, Chiang Mai University

Abstract

               The objectives of this research were to 1) design the income collection database system, 2) track unpaid income from various sources, and 3) study the satisfaction of using the income collection database system. The target group used in the research was 20 personnel involved in revenue collection and financial data utilization of the College of Arts, Media, and Technology, selected by a purposive method. The tools used for data collection were focus groups, interviews, and observations. The statistics used to analyze the data were mean and standard deviation.

              The results showed that (1) the database system's design reduces personnel's work time; executives allow to view an overview of the total income of the College and the Innovation Center; use the information to help decide on the current and next year's operational plans, (2) be able to follow up on the delayed revenues that are not following the projected estimates and (3) executives and personnel were satisfied with the overall use of the system at a high level ( = 4.08, S.D.= 0.66). The database design was as follows: 1) gathering and analyzing required detailed information,  2) defining the structure of the table, 3) assigning Key, 4) normalization, and 5) defining relationships database components including hardware, software, data, personnel, and operational procedures.