Title, I think the database design and relationships are very good entry points for an old system or for wiping the buttocks of other people's systems.
The premise of using this method is that in the database design, there is already a clear primary foreign key relationship (here only for small and medium-sized design, business logic strong, for the specific optimization design can be ignored);
Workaround:
1. Open the PowerDesigner tool, create a PDM file, and select the database type that matches it "IBM DB2 UDB 8.x Common Server". Create a new workspace by right-clicking on the workspace---->new------>physical data Nodel in the left-hand panel, selecting the type you want in the DBMS, selecting OK and clicking OK.
2, select Reverse Engineer Database under the Database menu, pop up the Database Reverse Engineering dialog box, choose the Using an ODBC data source to select an ODBC DataSource, as shown in:
3. Click OK to display all the tables, views, and users in this database (the user who selected the database). Select it as needed to convert to PDM. The diagram is as follows
4, select OK, click OK, then generate the model.
Finished, the text is fried, the picture is I cut. Thank!
PowerDesigner reverse engineering to generate PDM from an existing database