数据库设计规范(国外英语资料).docVIP

数据库设计规范 Database design methods, specifications and techniques (recommended) Database design process Database technology is the most effective means of information resource management. Database design refers to the construction of the best database model for a given application environment, the establishment of a database and its application system, and effective storage of data to meet user information requirements and processing requirements. Application of needs analysis in the database design stage of each user (the needs of the real world), formed the independent conceptual model in machine characteristics, independent of all DBMS products in the conceptual design stage (information world model), using the E-R chart to describe. In the logic design phase, the E-R diagram is transformed into a specific data model supported by a database product, such as a relational model, and a logical model of the database is formed. Then, according to the users processing requirements, security considerations, the basic table based on the establishment of the necessary view (VIEW) to form an external model of data. In the physical design phase, according to the characteristics of DBMS and the needs of processing, the physical storage arrangement, the design index, and the database model are formed. 1. requirements analysis phase Requirements collection and analysis results in the data requirements described by the data dictionary (and the processing requirements described by the data flow diagram). The focus of requirement analysis is to investigate, collect and analyze the information requirements, processing requirements, security and integrity requirements of users in data management. Requirement analysis: investigate the organization, investigate the business activities of each department, help the users to make clear the new system requirements and determine the boundaries of the new system. The survey methods are commonly used: attendant operations, open investigation,