Database Design on Mechanical Equipment Operation Management System

摘要

Carrying out mechanical equipment operation management can improve the economic efficiency for enterprises, prevent accidents, ensure production safety, and promote the reform of machinery and equipment maintenance system. Using computer system to manage is the necessary requirements for the information age. For the difficulties of system development, this paper conducted the database design. Following the database design process conducted the conceptual design, logical design and physical design. Conceptual design using the E-R diagram approach, suggested a link between entities and entity; logic design is based on SQL Server, designed the logical structure for all the tables; physical design about storage structures and access methods, including the disk hardware selection, data place on the disk, use the index to improve system performance, configuration parameters and other aspects design.