How to use PowerDesigner - specific steps to use PowerDesigner to create a physical data model

Time: 2024-03-19Source: Huajun Software TutorialAuthor: dim sum

Don’t know how to use PowerDesigner to create a physical data model? Presumably some novice friends say they still don’t understand it. For this reason, the specific steps for using PowerDesigner to create physical data models are shared below. Friends in need should not miss it.

1. Open PowerDesigner and click New

1.jpg

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

2.jpg

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

3.jpg
4.jpg

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

5.jpg
6.jpg

5. Build index

7.jpg

6. Create a view

8.jpg

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.

9.jpg
11.jpg
12.jpg

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.jpg

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

14.jpg

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

16.jpg
QQ screenshot 20200418084845.jpg

Above, I have shared with you the specific steps for using PowerDesigner to create a physical data model. Friends in need should hurry up and read this article.

Related articles更多>>

Popular recommendations