Database Management and Programing Article

  Database design of some ideas (from the demand to the database design) 

  Done some projects, summed up the database design and relevant information is uploaded as a picture means that the database design enthusiasts some help. If you are interested in this can contact me bigmouthz@163.net. 

  This would not say, Oh did not expect less CSDN not allow the characters to upload the article. Therefore, in this post-paste some text Please forgive. 

  Figure: 

  ————————————————– ————— 

  Functions of functional: 

  1 / enterprise organizational structure 
  2 / enterprise sector functions of the elements described 
  3 / hierarchical structure 
  4 / functions of 
  5 / functions as well as the duties of 
  6 / job functions of the constituent elements 
  7 / functions of the job description of functional (departmental level map showing positions) 

  Functional processes of: 

  1 / functional requirements description (business system) 
  2 / functional requirements and the collation of portfolio 
  3 / functional relationship between the coupling 
  4 / functional elements of the composition 
  5 / function description and implementation of the Resolution 
  6 / string or function and the lock and wait for a description of 
  7 / flow chart to show the way the specific function of 

  Process of documentation of: 

  1 / reality business documents collection 
  2 / finishing and composition of the documentation 
  3 / documentation in the functional processes in different stages to achieve the status change 
  4 / documentation of elements 
  5 / documentation describing the resolution and implementation of (the data source / data flows / data-processing action) 
  6 / documentation describing the user's authority and control 
  7 / specific documentation table-like display (spreadsheet form impressions) 

  Of forms of documentation: 

  1 / documentation of the contents of Resolution and Integration (not related to the design field, should only take into account the specific contents of the documents listed class description) 
  2 / documentation primary key and foreign key constraint and the initial description of 
  3 / documentation of the three paradigm and anti-Paradigm Design Description 
  4 / documentation of the estimated volume of data, documents the frequency of use estimates 
  5 / role in the determination of the use of documents (to database users have a role in the definition of documentation) 
  6 / documentation describing the design of view, the table for a description of the needs described Index 
  7 / documentation form of the table and show the relationship between (UML show) 

  Forms of atoms of: 

  1 / form fields design (type, range, attribute table) 
  2 / table primary key foreign key constraint design 
  3 / index forms the design 
  4 / forms for different users of the role of the distribution of competences 
  5 / In view of the scope of application and create a different, such as the general query / modify / statistics with (the proposed role of user-level view of the creation of) 
  6 / Trigger and storage description of the design process 
  7 / ER plans to the table to show a concrete manifestation of 

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.