Generate CDM, PDM, and SQL using PowerDesigner

1, Personnel organization structure

Entity	Note
Organization (ID, name)
Department (ID, name)	A body has multiple departments
Person (ID, name)	A person belongs to a department, and there are multiple people under one department.
Leadership	Leadership is also a person
Role (ID, name)	A role can correspond to multiple people, one person has multiple roles
Permissions (ID, name)	A role can have multiple permissions, and one permission corresponds to multiple roles

2. Conceptual model

New conceptual model

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/4E/wKiom1e7t8LTL8RRAAA9Kjc_geI673.png "title=" 001. PNG "alt=" Wkiom1e7t8ltl8rraaa9kjc_gei673.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/4D/wKioL1e7uB7Qkh55AADnaWvAC3g875.png "title=" 002. PNG "alt=" Wkiol1e7ub7qkh55aadnawvac3g875.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/4D/wKioL1e7uHfz0UJbAACbMJ1Kr8M793.png "title=" 003. PNG "alt=" Wkiol1e7uhfz0ujbaacbmj1kr8m793.png "/>

2.1. Institutions

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/86/4E/wKiom1e7uXuQeF0uAAA3Iyq-grg461.png "title=" 004. PNG "alt=" Wkiom1e7uxuqef0uaaa3iyq-grg461.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/86/51/wKiom1e76oLgT_DtAABiF_HOcYo095.png "title=" 005. PNG "alt=" Wkiom1e76olgt_dtaabif_hocyo095.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/50/wKioL1e76pPy0UjIAABfmpZdOvk116.png "title=" 006. PNG "alt=" Wkiol1e76ppy0ujiaabfmpzdovk116.png "/>

2.2. Department

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/51/wKiom1e76sPQhdGAAAA3UENuGLQ686.png "title=" 007. PNG "alt=" Wkiom1e76spqhdgaaaa3uenuglq686.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/86/51/wKiom1e76tfC_vyfAABXq3vlhss631.png "title=" 008. PNG "alt=" Wkiom1e76tfc_vyfaabxq3vlhss631.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/86/50/wKioL1e76ujhcyeBAABnS5aIcgo428.png "title=" 009. PNG "alt=" Wkiol1e76ujhcyebaabns5aicgo428.png "/>

2.3. Personnel

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/86/51/wKiom1e76xfTHPYFAAAvgPO5eXs828.png "title=" 010. PNG "alt=" Wkiom1e76xfthpyfaaavgpo5exs828.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/86/50/wKioL1e76yWi_iN0AABWmZ7mJLw566.png "title=" 011. PNG "alt=" Wkiol1e76ywi_in0aabwmz7mjlw566.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/86/51/wKiom1e76zSCyWn4AACAOAKh-GE110.png "title=" 012. PNG "alt=" Wkiom1e76zscywn4aacaoakh-ge110.png "/>

2.4. Leadership

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/51/wKiom1e764Xz28Z4AAAvvcQllXw934.png "title=" 013. PNG "alt=" Wkiom1e764xz28z4aaavvcqllxw934.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/86/50/wKioL1e765XRtsg-AABUDmUyVrI706.png "title=" 014. PNG "alt=" Wkiol1e765xrtsg-aabudmuyvri706.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/50/wKioL1e766byo5ERAAB67ZQDrDo688.png "title=" 015. PNG "alt=" Wkiol1e766byo5eraab67zqdrdo688.png "/>

2.5. Role

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/50/wKioL1e76-bzbNnXAAAujTaotZc168.png "title=" 016. PNG "alt=" Wkiol1e76-bzbnnxaaaujtaotzc168.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/86/51/wKiom1e76_Sgpa1_AABWprXRnVs099.png "title=" 017. PNG "alt=" Wkiom1e76_sgpa1_aabwprxrnvs099.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/50/wKioL1e77AOSd7PlAACTsC4zyRM239.png "title=" 018. PNG "alt=" Wkiol1e77aosd7plaactsc4zyrm239.png "/>

2.6. Permissions

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/51/wKiom1e77D6R-D41AAAyMhTIxI4737.png "style=" float: none; "title=" 019.PNG "alt=" Wkiom1e77d6r-d41aaaymhtixi4737.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/51/wKioL1e77D2yyT7ZAABZE4l-4UA507.png "Title=" 020. PNG "style=" Float:none; "alt=" Wkiol1e77d2yyt7zaabze4l-4ua507.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/51/wKiom1e77D3THEEZAACTz_viMRM222.png "title=" 021. PNG "style=" Float:none; "alt=" Wkiom1e77d3theezaactz_vimrm222.png "/>

2.7. Institutional-Departmental relations

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/51/wKiom1e77NrxY9UpAACaiuLHNP0157.png "style=" float: none; "title=" 022.PNG "alt=" Wkiom1e77nrxy9upaacaiulhnp0157.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/51/wKioL1e77NriDKTJAABX2GGhlQ0742.png "title=" 023. PNG "style=" Float:none; "alt=" Wkiol1e77nridktjaabx2gghlq0742.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/51/wKiom1e77NnAPl7RAABR7L0GzX0483.png "title=" 024. PNG "style=" Float:none; "alt=" Wkiom1e77nnapl7raabr7l0gzx0483.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/86/51/wKioL1e77NmziyCPAACQ3ctvDvY799.png "title=" 025. PNG "style=" Float:none; "alt=" Wkiol1e77nmziycpaacq3ctvdvy799.png "/>

2.8. Department-Personnel Relations

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/51/wKioL1e77VqS-qN_AACS852xPac568.png "style=" float: none; "title=" 026.PNG "alt=" Wkiol1e77vqs-qn_aacs852xpac568.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/52/wKiom1e77VrxjzUHAABWCvD5rco485.png "title=" 027. PNG "style=" Float:none; "alt=" Wkiom1e77vrxjzuhaabwcvd5rco485.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/51/wKioL1e77Vmj8lg4AABPum3n66U156.png "title=" 028. PNG "style=" Float:none; "alt=" Wkiol1e77vmj8lg4aabpum3n66u156.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77VmxsU0cAACUdFi11CA018.png "title=" 029. PNG "style=" Float:none; "alt=" Wkiom1e77vmxsu0caacudfi11ca018.png "/>

2.9. Personnel-Leadership relationship

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/86/51/wKioL1e77dbyCLrbAACWp7VYGKk819.png "style=" float: none; "title=" 030.PNG "alt=" Wkiol1e77dbyclrbaacwp7vygkk819.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77dayZr0kAAA14GTVlr0016.png "title=" 031. PNG "style=" Float:none; "alt=" Wkiom1e77dayzr0kaaa14gtvlr0016.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/51/wKioL1e77dXwRlgYAABL6a4gjos496.png "title=" 032. PNG "style=" Float:none; "alt=" Wkiol1e77dxwrlgyaabl6a4gjos496.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/52/wKiom1e77dXB3LaCAACXFidiVVg238.png "title=" 033. PNG "style=" Float:none; "alt=" Wkiom1e77dxb3lacaacxfidivvg238.png "/>

2.10. Personnel-Role relationship

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/51/wKioL1e77mGQD107AACzVgS7-mM617.png "style=" float: none; "title=" 034.PNG "alt=" Wkiol1e77mgqd107aaczvgs7-mm617.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77mCBXpCLAAAvtw4vhqU996.png "title=" 035. PNG "style=" Float:none; "alt=" Wkiom1e77mcbxpclaaavtw4vhqu996.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/51/wKioL1e77mCjoLe7AABSP2u6R88854.png "title=" 036. PNG "style=" Float:none; "alt=" Wkiol1e77mcjole7aabsp2u6r88854.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/86/52/wKiom1e77mDiW0PxAAC2GPiuBro633.png "title=" 037. PNG "style=" Float:none; "alt=" Wkiom1e77mdiw0pxaac2gpiubro633.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77tvCCm4IAABEcGmRg4c166.png "title=" 038. PNG "alt=" Wkiom1e77tvccm4iaabecgmrg4c166.png "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77unwk_CNAABGb_1hD3M040.png "title=" 039. PNG "alt=" Wkiom1e77unwk_cnaabgb_1hd3m040.png "/>

2.11. Role-Permission relationship

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/86/52/wKioL1e77vaB_FhbAAC6L3yqM1E410.png "title=" 040. PNG "alt=" Wkiol1e77vab_fhbaac6l3yqm1e410.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/52/wKioL1e771uD3nOsAABSV3Bzo20300.png "style=" float: none; "title=" 041.PNG "alt=" Wkiol1e771ud3nosaabsv3bzo20300.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/53/wKiom1e771uQkmKVAABLYT-0hnc007.png "title=" 042. PNG "style=" Float:none; "alt=" Wkiom1e771uqkmkvaablyt-0hnc007.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/52/wKioL1e771rwpAlaAAC61XLH2ag927.png "title=" 043. PNG "style=" Float:none; "alt=" Wkiol1e771rwpalaaac61xlh2ag927.png "/>

3. Physical model

Generate a physical model

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/53/wKiom1e78B_whKRdAABXwHpxrD0282.png "style=" float: none; "title=" 044.PNG "alt=" Wkiom1e78b_whkrdaabxwhpxrd0282.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/53/wKiom1e78B_Rp_6FAABDq5v6jCM919.png "title=" 045. PNG "style=" Float:none; "alt=" Wkiom1e78b_rp_6faabdq5v6jcm919.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/86/52/wKioL1e78B7Ty8-1AAAhZ0OD4ls928.png "title=" 046. PNG "style=" Float:none; "alt=" Wkiol1e78b7ty8-1aaahz0od4ls928.png "/>

The physical model generated by the conceptual model :

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/86/53/wKiom1e78B6hHY_uAAC7PhI6Rmw248.png "title=" 047. PNG "style=" Float:none; "alt=" Wkiom1e78b6hhy_uaac7phi6rmw248.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/86/53/wKiom1e78JXx52DsAAB2CqOvdkY983.png "title=" 048. PNG "alt=" Wkiom1e78jxx52dsaab2cqovdky983.png "/>

4. Generate SQL

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/86/53/wKiom1e78L7wcXXwAAA8-Ihq3rU511.png "style=" float: none; "title=" 049.PNG "alt=" Wkiom1e78l7wcxxwaaa8-ihq3ru511.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/86/52/wKioL1e78L2wfvnGAABFJEC1EwI130.png "title=" 050. PNG "style=" Float:none; "alt=" Wkiol1e78l2wfvngaabfjec1ewi130.png "/>

Generate CDM, PDM, and SQL using PowerDesigner