Past thoughts: Database Design Ideas

Source: Internet
Author: User
Database Design Concept( Http://

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.