Frog frog recommendation: Summary of database modeling experience using PD

1. Select sqlserver2000 when creating PDM
2. After creating a PDM, create a DBO user. After creating a new table, set the user to DBO.
3. When creating a table, the name and code can be separated, and the name can be written into Chinese for reading. The code can be written into English and used as the table name. Finally, write the comment, which generates comments. Note writing can be longer, but do not press enter to wrap the line. If you want to generate an sqlserver database, you can click the table design view. It is difficult to view the column comments in several lines. The same is true when adding columns to a table, namely name, code, and comment.
4. Open the database-edit current DBMS and write the value of script/objects/table/create as follows:

/* Tablename: % tname % */
Create   Table   [ % Qualifier % ] % Table % (
% Tabldefn %
)
[ % Options % ]

Script / Objects / Table / Tablecomment is as follows:
Execute Sp_addextendedproperty n ' Ms_description ' , N ' % Comment % ' , N ' User ' , N ' % Owner % ' , N ' Table ' , N ' % Table % ' , Null , Null

Script / Objects / Column / Add as follows:
% 20 : Column %   [ % Compute %? As (% compute %): % 20: datatype % [% identity %? % Identity %: [% null % ] [ % Notnull % ] ] [ Default % default % ]
[ [Constraint % constname % ]   Check ( % Constraint % )] /* % Colnname % */

Script / Objects / Column / Columncomment is as follows:
/* % Column %: % comment % */
Execute Sp_addextendedproperty n ' Ms_description ' , N ' % Comment % ' , N ' User ' , N ' % Owner % ' , N ' Table ' , N ' % Table % ' , N ' Column ' , N ' % Column % '

5. generate the followingCode. Click the database-genrate database menu to hook the comment check boxes in the table and column combo boxes on the table & view tab. Click OK to generate the database script.
6. When designing a database, it is best to put the relevant tables together and enclose them with a rectangle. The rectangle is filled with different background colors for easy viewing. You can select all the elements in a rectangle box, click the group symbol in the symbol menu to combine the table and the rectangle box, and click the Ungroup symbol menu to remove the combination.
7. If you want to generate a Database Report, right-click the physical model, select the new-Report menu, and select the language and template. Because the template provided by PD is too cumbersome, you generally select an empty template, design the report elements to be displayed, such as table list and column list, and some table and column descriptions.
8. To view the code generated for each table, you can view it on the preview tab of the table properties.
9. If you right-click a graph and select protect symbol, the graph will be protected and cannot be dragged or modified. What should I do? Click the symbol menu and click the unprotect symbol menu.

In addition, I have a section of C algorithm code to be converted to C # code. I won't turn it around, who can check it out? For details, refer to the following link. Thank you
http://www.cnblogs.com/onlytiancai/archive/2007/04/10/706543.html