Database Design Instruction reference template

Database Design Instruction reference template

1. Introduction 1.1 Project Name 1.2 project background and Content Overview (Relationship between the project entrusting unit, Development Unit, competent department, other projects, and other institutions) 1.3 related materials, abbreviations and definitions (Relevant project plans, contracts, approvals from higher authorities, documents referenced, and standards adopted) (Acronyms and Glossary) 2. Conventions Naming Conventions for various elements in the database. For example, the table name and field name naming conventions. 3. database conceptual model design 3.1 Data entity-relationship diagram 3.2 data Entity description Chinese name of the data entity, database table name Data Entity description 3.3 object Link Description (Describe the relationship between each object) Entity 1: entity 2 (1:1, 1: n, m: N) Link Description: 4. database logical model design 4.1 entity-relationship diagram (not including multi-Multi-relationship) 4.2 link model description Database Table Name: synonym (alias ): Primary key: Foreign key: Index: Constraints: Chinese name data attribute name data type data length constraint range empty Annotation 4.3 Data View description (Statement description for creating a data view in standard SQL language) 4.4 Database Consistency Design (Statement description for creating a table in standard SQL language) 5. physical implementation 5.1 Database Arrangement . Shows whether a distributed database is used and how database tables are distributed. . Several databases are created on each database server, and their storage space is arranged. . Database Table allocation methods, such as how to create segments or tablespaces 5.2 security and confidentiality Design User Role division method, permissions of each role