Database Design Manual Reference Template 1. Introduction 1.1 Project Name 1.2 Project Background and Content Summary (Project's Entrusted Units, Development Units, Relationship with Other Projects, Relationship with Other Agency, etc.) 1.3 Related Information, Thumbnors, Definitions (Related Project Planning, Contracts and The superior authority approves, referenced by the document, the standard, etc.) (abbreviation words and noun definitions) 2. Naming conventions for various elements in the agreed database. For example, a nam name, a naming agreement for a field name. 3. Database Concept Model Design 3.1 Data Entity - Relationship Figure 3.2 Data entity Description Data entity Chinese name, database table name data entity description 3.3 Entity relationship Description (Relationship between each entity) entity 1: Entity 2 (1: 1, 1: n, m: n) Relationship Description: 4. Database logic model design 4.1 Entity - Relationship diagram (excluding multi - multi-relational) 4.2 Relationship model Description Database table name: Synonym (alias): Primary key: Out: Index: Constraint: Chinese Name Data Attribute Name Data Type Data Length Constraint Whether Empty Note 4.3 Data View Description (Create a Standard Skature Data Description in Standard SQL Language) 4.4 Database Consistency Design (Create a list of statements in the standard SQL language) 5. Physical implementation 5.1 database arrangement. Note Whether to use a distributed database, how the database table is distributed. Several databases are built on each database server, and its storage space. The allocation method of the database table, for example: how to create a segment, or table space 5.2 Security Design User role division method, permissions for each role
