Indexed by:
Abstract:
In contemporary community management, digital community management systems are of great importance. A database system for community management maintains the generated data and provides efficient and organized services to the residents. In this paper, a SQL-based community information management database system is developed, and the design and implementation of this community information management database are studied. The database stores and manages information about buildings, apartments, residents, parking lots, cars, equipment, resident feedback, etc. in the community. At the same time, this paper has also designed a relational model between entities, so that this paper can sort out the attribute relationships between entities, and then design SQL statements to query the data of the entered entities, to achieve an efficient data search. In addition, the paper also performs some manipulations of the developed database using SQL language which helps the residents and management people to maintain the community. To sum up, the database designed in this article can effectively store community data and play an important role in the normal operation of the community. © 2022 IEEE.
Keyword:
Reprint Author's Address:
Email:
Source :
Year: 2022
Page: 232-237
Language: English
Cited Count:
SCOPUS Cited Count:
ESI Highly Cited Papers on the List: 0 Unfold All
WanFang Cited Count:
Chinese Cited Count:
30 Days PV: 2
Affiliated Colleges: