Building a database model using PowerDesigner

1. Open PowerDesigner, click File->new

2. Select the conceptual Data model and modify the model name.

3. Click the Entity tool in the Palette toolbar and create two entity in the workspace.

4. Double-click an entity. Enter Name,code in the pop-up entity properties. Where name is the name that is used when it is displayed, and code is the name that is used in the code.

5. Click attributes to create the corresponding attribute: Name: Display name, code: Name of the tag, data type: datatype, Length: Data length, Precision: Data precision, M: Required, P: Primary key, D: Display.

6. Select the primary key column and click the Create Identifier button in the tool column.

7. Enter name and code because it is the primary key column, so check primary identifier.

8. Use the 3-7 method to establish student entity.

9. Click on the Relationship tool in the toolbar to click on the class entity and drag it to the student entity.

10. Double-click the relationship connection you just established. Modify the name and code.

11. Select the appropriate cardinality in the cardinalities.

12. Relationship has been established

13. Generating a physical data model

14. Select the database type.

15. Complete the physical data model

16. Generate Database Scripts.

17. Select the script store path, file name and type.

18. Generate script completion.

19. Click Edit to open this script in Notepad.

20. Finally, you can run this script!

Building a database model using PowerDesigner