Past thoughts: Database Design Ideas

Database Design Concept( Http://www.sawin.cn/doc/SD/Database/dbpatterns.htm)

Click the link above for the relevant illustration. :-)
========================================================== ====================================

The following is an excerpt from this section:

Function Assignment:

1. Enterprise Organizational Structure
2. Description of elements of Enterprise Department functions
3/department hierarchy
4/Division of Department functions
5. Division of employee duties
6. Elements of job functions
7. Function Description of job functions (displayed in the department job Hierarchy Diagram)

Function division process:

1/Function Requirement Description (business, System)
2. Sorting and combining functional requirements
3/coupling between functions
4/functional components
5. Description and implementation of splitting Functions
6/Description of function serialization, merging, and lock wait
7. display the function in a flowchart

Process Division:

1/collect real-world business documents
2. Document arrangement and combination
3. status changes of documents during different periods in the function implementation process
4/elements of documents
5. Description and implementation of document splitting (Data Source/data flow/Data Processing)
6. Permission description and control for document users
7. Specific document table (displayed in a workbook)

Tabulation of Document Division:

1. Splitting and integration of the document content (field design is not involved, and only the column-level description of the document content should be taken into account)
2. preliminary description of the primary key and foreign key and constraints of the document
3/Three-paradigm and inverse-paradigm Design Description of documents
4/estimation of document data volume and document Usage Frequency
5. determine the role used for the document (generate a document defined by the Database User Role)
6. Design Description of the document view, query table description, and index Requirement Description
7. Presentation of the relationship between single rooms and table items in the Document Table (presented in UML)

Table Partitioning:

1. Table field design (data type, value range, and attribute table)
2. Design of table primary key foreign key constraints
3. Table index design
4. grant permissions to users of different roles in the table
5. The view is created based on the application scope, for example, general query/modification/statistics. (It is recommended that you create a role-level view)
6. Trigger and stored procedure design description
7. display the table in the form of an erdiagram