Database System Development for Discovering the Poverty Solution Guidelines in Target Areas of Loei Province

Abstract

The objectives of this research article were 1) to develop a database system of 3 target villages in Loei Province: Na Krasen Village, Bu Hom Village, and Hat Bia Village; and 2) to apply data from the database to analyze and find solutions to poverty problems. The tools used were Microsoft Visual Studio.Net 2017, Microsoft SQL Server database, and questionnaires. The sample group was 1,642 people (791 households) living in Na Krasen Village, Bu Hom Village, and Hat Bia Village. Logistic regression analysis was used. The research results found that 1) in developing the database system of 3 target villages in Loei Province, the researcher developed a Web Application by specifying 3 levels of permissions: administrator, data recorder, and general public. The database consisted of 6 tables: rw_user table was used to store user information; Village table was used to store village data; Map table was used to store Google Maps; rpNumber table was used to store reports; Family table was used to store household information; and Person table was used to store personal data, 2) data were applied from the database to analyze and find solutions to poverty problems. Factors affecting poverty at a significance level of 0.05 on the positive side included household conflicts, pollution management, risky behaviors, disaster management that affected households, and receiving assistance. On the negative side, they included reading ability, health status, household electricity, maintenance of the outside of the house, and education. Therefore, poverty problems should be solved by setting guidelines based on the analysis results.