Many users express that they do not know how to create a physical data model when operating PowerDesigner. For this reason, in this article today, the editor will tell you how to use PowerDesigner to create a physical data model.

1. Open PowerDesigner, open the tool and click New

2. Select the data model, fill in the model name, and select the database to use

3. Select the toolbar on the right to create a data table.

4. Double-click the new data table to edit it.

5. Build index

6. Create a view

7. Double-click the view to edit it. You can edit the SQL statement of the view in the SQL options window, and you can see the complete statement of creating the view in the preview.

8. All the data just created can also be found in the left toolbar. If you need to edit a single item, just click the icon in front of an item.

13. Click the relationship button on the right toolbar to associate the data table with the view.

14. Double-click the association to view the information associated with editing.

Above, I have shared with you how to use PowerDesigner to create a physical data model. Friends in need should hurry up and read this article.