讲解MySQL数据库的命名及设计规范（Explain the naming and design specifications of MySQL database）.doc

讲解MySQL数据库的命名及设计规范（Explain the naming and design specifications of MySQL database） 1. design principles 1) standardization and standardization The standardization of data helps to eliminate data redundancy in the database. There are several forms of standardization, but Third Normal Form (3NF) is generally considered to be the best balance in performance, scalability, and data integrity. In simple terms, table design principles to comply with the 3NF standard database is: One Fact in One Place is a table only includes its basic properties, when the property is not their inherent need to decompose. Relationships between tables are connected by foreign keys. It has the following features: there is a set of tables that store the associated data connected by keys. Example: a 3NF database that stores customers and their orders may have two tables: Customer and Order. The Order table does not contain any information about the order associated with the customer, but a key value is stored in the table, which points to the line containing the customer information in the Customer table. In fact, the standardization of tables is sometimes necessary for efficiency reasons. 2) data driven Using data driven rather than hard coding methods, many policy changes and maintenance will be much easier, greatly enhancing the flexibility and scalability of the system. For example, if the user interface wants to access external data sources (files, XML documents, other databases, etc.), you can store the corresponding connections and path information in the user interface support list. Also, if the user interface performs tasks such as workflow (sending mail, printing stationery, modifying record status, etc.), the data that generates the workflow can also be stored in the database. Role rights management can also be done by data driven. In fact, if the process is data-driven, you can push considerable responsibility to the user and maintain the workflow process by the user. 3) consider va