Generate CDM, PDM, and SQL using PowerDesigner

1. Organizational structure of personnel

Entity remarks organization (id, name)

Department (id, name) an organization has multiple department personnel (id, name) A person belongs to a department, and there are multiple personnel leaders in a department who are also personnel roles (id, name) A role can correspond to multiple personnel, a person has multiple role permissions (id, name), a role can have multiple permissions, and a permission corresponds to multiple roles.

2. Conceptual model

New Conceptual Model

2.1. Organization

2.2, departments

2.3. Personnel

2.4. Leadership

2.5, role

2.6, permissions

2.7. Agency-department relationship

2.8. Department-personnel relations

2.9. Personnel-leadership relationship

2.10. Person-role relationship

2.11. Role-permission relationship

3. Physical model

Generate a physical model

Physical models generated by conceptual models:

4. Generate SQL