A database design method for city management comprises the following steps: firstly, designing database functions according to business functions and application requirements, so that the database functions can perform data management, data storage, data retrieval and data uploading / exporting, have a huge data processing function, and process structured data stored in a database; secondly, performing logic design and physical design on the processed structured data, finally designing a database table structure according to urban management business processes and application requirements, and presenting business table and dimension table structure contents, thereby realizing management of all data information. The database designed by the invention is beneficial to enhancing the data management capability of an existing platform, ensures the performance requirements of background mass data storage, retrieval and uploading, provides a data basis for stable operation of a system, analysisand mining of future city management data and construction of a smart city database, and effectively improves the utilization rate of data resources.