In the modern legal landscape, resource management plays a crucial role in the sustained development of law firms and in delivering high-quality legal services to clients. However, there are still law firms that have deviated from database technology and continue to rely on traditional resource management models, which cannot meet the needs of modern enterprise management. This paper aims to explore the current status of resource management in law firms and introduces the design of a universal resource database tailored to the needs of law firms, lawyers, and clients. This paper provides a detailed introduction to the design of the comprehensive resource management database from the perspectives of requirement analysis, conceptual level design, logical level design and physical level design. The comprehensive database primarily store data related to staffs, orders, and clients, providing efficient resource management, and allowing for further expansion on this foundation. Effective resource management is paramount for law firms to maintain their competitiveness and provide excellent legal services, ultimately enhancing the overall client experience.