Study on an Integrated System using an ER Diagram for Chungcheong Rural Communities

While urban regeneration projects are currently under active execution in several old cities in Korea, there are few projects to improve the quality of life of rural communities. Considering the decline of the SOC system, deterioration of housing, and degeneration of economic feasibility, the purpose of this study is to provide solutions to realize an improved economic and social environment of rural communities through an integrated management system for traffic safety and water management systems. Therefore, this research used an Entity-Relationship Diagram to construct an integrated system for traffic safety and water management systems for Chungcheong rural communities. The ERD is prepared by depicting 7 relationships for 13 entities, including traffic accidents and agricultural products, and 26 attributes, including soil moisture and underflow storage. Consequently, it will be possible to set up a decision-making support system that can analyze and evaluate the regeneration index, technology, and management of the systems for Chungcheong rural communities, based on supplier and user perspectives