Database design concept
Author: verybigmouthz (original) recommended date: 2004-3-7
(Mode and Database Design)
I have always had an idea that I want to be able to hook the database design with the pattern. The content I have listed will not be modeled, but I have something like it, so I hope everyone can give some good suggestions. If you have any questions, please make a statement.
Plus the following text, I think that these things I have listed are different from the previous post, the second is in order to make a word number.
-------------------------------------------------- ------------------------------------------
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
(2) 2 2)
;) Please communicate with each other!
-------------------------------------------------- ------------------------------------------
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 universal query / modification / statistics (suggested user role level view) 6 / Trigger and stored procedure design Description 7 / Demand in the way in Er diagram (designed to database design)
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.
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
