Some concepts of database design (designed from demand to database)
I have done some projects, summarized the information related to database design, is now uploaded as pictures, I hope to have some help for database design enthusiasts. If you are interested, you can contact me Bigmouthz@163.net.
I don't think much about it, I didn't expect Haha 9CBS, I didn't allow the number of less characters to upload. Therefore, I posted some text after this article, please forgive.
Figure:
-------------------------------------------------- ---------------
Functional division functionalization:
1 / Enterprise Organization Architecture 2 / Enterprise Department Function Composition Element Description 3 / Department Hierarchy 4 / Department Function 5 / Employee Position Function Division 6 / Property Function Element 7 / Position Function Differential Description Show)
Functional division process:
1 / Functional Demand Description (Business, System) 2 / Functional Demand Subtocking and Split Description of Forms 5 / Function between Combined 3 / Function 4 / Function Split Description and Realization 6 / Function Stripization or Compact and Lock Waiting for the Description 7 / Explain the specific embodiment of the function in the flowchart
Process division document:
1 / Realistic Business Directions Collection 2 / Document Split Description and implementation (data source / data flow direction / data processing) of the functional change 4 / document in different periods of the functional implementation process Action) 6 / Document user permission description and control 7 / concrete document selection (display in electronic form)
Document classification:
1 / Split and integration of content (do not involve field design, only the list of specific contents of the document) 2 / document, primary key and foreign key and constraints, 3 / document, 3-style and anti-fashion design Describe the estimation of the 4 / document data, the use frequency estimation of the document 5 / document uses the character's determination (with the generation of database user role definition documents) 6 / document view design description, the description of the query table, indexing requirements Description 7 / Documentation display (display in UML)
Table division atomization:
1 / Type field design (Data Type, Value Domain, Property Table) 2 / Table Key Foreign Key Constrained Design 3 / Table Index Design 4 / Form Allocation 5 / View Different Role Users Different Create, such as general query / modification / statistics (recommended for user role level view) 6 / trigger and stored procedure design Description 7 / Reference table in the way in ER diagram
