Generate CDM, PDM, and SQL using PowerDesigner

1. Personnel organization structure

Entity	Remarks
Organization (id, name)
Department (id, name)	An organization has multiple departments
person (id, name)	One ​​person belongs to one department, and there are multiple people under one department
Leader	Leaders are also people
Role (id, name)	One ​​role can correspond to multiple people, and one person has multiple roles
permissions (id, Name)	A role can have multiple permissions, and one permission corresponds to multiple roles

< p>

2, conceptual model

New conceptual model

< p>650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png “title=”002.PNG” alt=”wKioL1e7uB7Qkh55AADnaWvAC3g875.png” data-src=”http://s1.51cto.com/wyfs02/M00/86/4D/wKioL1e7uB7Qkh55AADnaWvAC3g875.png”>

2.1, institution

650) this.width=650;” src=”/wp-content /uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”005.PNG” alt=”wKiom1e76oLgT_DtAABiF_HOcYo095.png” data-src=”http://s2.51cto.com/wyfs02/M02 /86/51/wKiom1e76oLgT_DtAABiF_HOcYo095.png”>

2.2. Department

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”008.PNG “alt=”wKiom1e76tfC_vyfAABXq3vlhss631.png” data-src=”http://s1.51cto.com/wyfs02/M02/86/51/wKiom1e76tfC_vyfAABXq3vlhss631.png”>

2.3, personnel

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg /static/loading.png” title=”011.PNG” alt=”wKioL1e76yWi_iN0AABWmZ7mJLw566.png” data-src=”http://s4.51cto.com/wyfs02/M00/86/50/wKioL1e76yWi_iN0AABWmZ7mJ /p>

2.4, leadership

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voi dcn.com/vcimg/static/loading.png” title=”014.PNG” alt=”wKioL1e765XRtsg-AABUDmUyVrI706.png” data-src=”http://s5.51cto.com/wyfs02/M01/86/50 /wKioL1e765XRtsg-AABUDmUyVrI706.png”>

2.5, role

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/ static/loading.png” title=”017.PNG” alt=”wKiom1e76_Sgpa1_AABWprXRnVs099.png” data-src=”ht tp://s3.51cto.com/wyfs02/M02/86/51/wKiom1e76_Sgpa1_AABWprXRnVs099.png”>

2.6, permissions

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”020.PNG” style =”float:none;” alt=”wKioL1e77D2yyT7ZAABZE4l-4UA507.png” data-src=”http://s5.51cto.com/wyfs02/M02/86/51/wKioL1e77D2yyT7ZAABZE4 l-4UA507.png”>

2.7. Institution-department relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”023.PNG” style=”float:none;” alt=”wKioL1e77NriDKTJAABX2GGhlQ0742.png” data-src=”http://s2.51cto.com/wyfs02/M01/86/51/wKioL1e77NriDKTJAABX2GGh lQ0742.png”>

650) this.width =650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”025.PNG” style=”float:none;” alt=”wKioL1e77NmziyCPAACQ3ctvDvY799.png “data-src=”http://s4.51cto.com/wyfs02/M00/86/51/wKioL1e77NmziyCPAACQ3ctvDvY799.png”>

< span style="font-size:24px;">2.8. Department-personnel relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn. com/vcimg/static/loading.png” title=”027.PNG” style=”float:none;” alt=”wKiom1e77VrxjzUHAABWCvD5rco485.png” data-src=”http://s1.51cto.com/wyfs02/M01 /86/52/wKiom1e77VrxjzUHAABWCvD5rco485.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”029.PNG” style=”float:none;” alt =”wKiom1e77VmxsU0cAACUdFi11CA018.png” data-src=”http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77VmxsU0cAACUdFi11CA018.png”>

2.9. Personnel-Leadership Relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/ vcimg/static/loading.png” title=”031.PNG” style=”float:none;” alt=”wKiom1e77dayZr0kAAA14GTVlr0016.png” data-src=”http://s4.51cto.com/wyfs02/M01/86 /52/wKiom1e77dayZr0kAAA14GTVlr0016.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img. voidcn.com/vcimg/static/loading.png” title=”0 33.PNG” style=”float:none;” alt=”wKiom1e77dXB3LaCAACXFidiVVg238.png” data-src=”http://s1.51cto.com/wyfs02/M00/86/52/wKiom1e77dXB3LaCAACXFidiVVg238.png”>

2.10. Personnel-role relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”035.PNG” style=”float:none;” alt=”wKiom1e77mCBXpCLAAAvtw4vhqU996.png” data-src =”http://s4.51cto.com/wyfs02/M01/86/52/wKiom1e77mCBXpCLAAAvtw4vhqU996.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”037.PNG” style=” float:none;” alt=”wKiom1e77mDiW0PxAAC2GPiuBro633.png” data-src=”http://s4.51cto.com/wyfs02/M00/86/52/wKiom1e77mDiW0PxAAC2GPiuBro633.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”039.PNG” alt=”wKiom1e77unwk_CNAABGb_1hD3M040.png” data-src=”http://s3.51cto.com/wyfs02/M00/86/52/wKiom1e77unwk_CNAABGb_1hD3M040.png”>

2.11, role-authority relationship

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” style=” float:none;” title=”041.PNG” alt=”wKioL1e771uD3nOsAABSV3Bzo20300.png” data-src=”http://s5.51cto.com/wyfs02/M02/86/52/wKioL1e771uD3nOsAABSV3Bzo20300.png”>

650) this.width=650;” src=”/wp-content/uplo adshttp:/img.voidcn.com/vcimg/static/loading.png” title=”043.PNG” style=”float:none;” alt=”wKioL1e771rwpAlaAAC61XLH2ag927.png” data-src=”http://s1. 51cto.com/wyfs02/M01/86/52/wKioL1e771rwpAlaAAC61XLH2ag927.png”>

3. Physics Model

Generate physical model

650) this.width=650;” src=” /wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”045.PNG” style=”float:none;” alt=”wKiom1e78B_Rp_6FAABDq5v6jCM919.png” data-src=”http ://s1.51cto.com/wyfs02/M00/86/53/wKiom1e78B_Rp_6FAABDq5v6jCM919.png”>

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png” title=”047.PNG” style=”float:none;” alt=”wKiom1e78B6hHY_uAAC7PhI6Rmw248.png” data-src=”http://s4.51cto.com/wyfs02/M02/86/53/wKiom1e78B6hHY_uAAC7PhI6Rmw248.png”>

4. Generate SQL

650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/ static/loading.png” title=”050.PNG” style=”float:none;” alt=”wKioL1e78L2wfvnGAABFJEC1EwI130.png” data-src=”http://s1.51cto.com/wyfs02/M00/86/52 /wKioL1e78L2wfvnGAABFJEC1EwI130.png”>