-
Notifications
You must be signed in to change notification settings - Fork 0
/
RH Database Diagram.drawio
326 lines (326 loc) · 31.4 KB
/
RH Database Diagram.drawio
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
<mxfile host="app.diagrams.net" modified="2022-06-12T20:28:28.454Z" agent="5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36" etag="yzDvPJhi5UfuODoGdUx9" version="19.0.2" type="github">
<diagram name="Page-1" id="a7904f86-f2b4-8e86-fa97-74104820619b">
<mxGraphModel dx="1108" dy="1350" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1600" pageHeight="900" background="#DAD2D8" math="0" shadow="0">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
<mxCell id="e3raqFH5HiRqm9mPKhRc-3" value="<font style="font-size: 40px">HR Department Database - ER Diagram</font>" style="text;html=1;resizable=0;autosize=1;align=center;verticalAlign=middle;points=[];fillColor=none;strokeColor=none;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="70" width="730" height="30" as="geometry" />
</mxCell>
<mxCell id="hZx71IKOhUPCRJcw6M9n-52" style="edgeStyle=orthogonalEdgeStyle;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry relative="1" as="geometry">
<mxPoint x="844" y="267.5" as="sourcePoint" />
<mxPoint x="844" y="267.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-1" value="<b><font style="font-size: 20px">Employee</font></b>" style="arcSize=10;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="200" y="250" width="140" height="77.5" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-8" value="<font style="font-size: 14px">Employee_name</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="140" y="150" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-9" value="<font style="font-size: 14px">Employee_gender</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="280" y="110" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-10" value="<font style="font-size: 14px">Employee_hire_date</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="420" y="320" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-11" value="<font style="font-size: 14px">Employee_date_of_birth</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="20" y="200" width="160" height="50" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-13" value="<font style="font-size: 14px">Role_title</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="230" y="637.5" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-20" value="<font style="font-size: 14px">Employee_name(FK)</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="1300" y="490" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-23" value="<font style="font-size: 14px">Promotions</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="700" y="620" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-25" value="<font style="font-size: 14px">Previous_role</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="625" y="710" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-26" value="<font style="font-size: 14px">Role_date_start</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="480" y="740" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-30" value="<font style="font-size: 14px">Manager_shift</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="1250" y="600" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-47" value="<font style="font-size: 14px">Department_name</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="965" y="280" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-6" value="" style="endArrow=none;html=1;exitX=0.686;exitY=-0.032;exitDx=0;exitDy=0;exitPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="300" y="206.88" as="sourcePoint" />
<mxPoint x="350" y="156.88" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-7" value="" style="endArrow=none;html=1;exitX=1.016;exitY=0.339;exitDx=0;exitDy=0;exitPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="343.64" y="310.64" as="sourcePoint" />
<mxPoint x="416.36" y="220" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-8" value="" style="endArrow=none;html=1;exitX=0.391;exitY=-0.016;exitDx=0;exitDy=0;exitPerimeter=0;entryX=0.739;entryY=0.969;entryDx=0;entryDy=0;entryPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-1" target="nj0aj4-7wqTGS0bk_ivH-8" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="160" y="225.63250000000005" as="sourcePoint" />
<mxPoint x="234.12000000000012" y="169.36" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-9" value="" style="endArrow=none;html=1;entryX=0;entryY=0.75;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="150" y="330" as="sourcePoint" />
<mxPoint x="160.0000000000001" y="303.73" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-10" value="" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-1" target="nj0aj4-7wqTGS0bk_ivH-10" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="372.24" y="306.27250000000004" as="sourcePoint" />
<mxPoint x="446.3600000000001" y="250" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-11" value="" style="endArrow=none;html=1;exitX=0;exitY=0;exitDx=0;exitDy=0;entryX=0.936;entryY=0.719;entryDx=0;entryDy=0;entryPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-1" target="nj0aj4-7wqTGS0bk_ivH-11" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="85.88" y="295.02250000000004" as="sourcePoint" />
<mxPoint x="160.0000000000001" y="238.75" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-12" value="" style="endArrow=none;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-47" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="885" y="276.25" as="sourcePoint" />
<mxPoint x="810" y="372.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-13" value="" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.25;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="364.99999999999704" y="580" as="sourcePoint" />
<mxPoint x="439.9999999999998" y="579.375" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-14" value="" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.75;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-13" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="350" y="547.5" as="sourcePoint" />
<mxPoint x="439.9999999999998" y="618.125" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-15" value="" style="endArrow=none;html=1;exitX=0.421;exitY=-0.031;exitDx=0;exitDy=0;entryX=0.333;entryY=1;entryDx=0;entryDy=0;entryPerimeter=0;exitPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-26" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="380" y="637.5" as="sourcePoint" />
<mxPoint x="489.9499999999998" y="637.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-16" value="" style="endArrow=none;html=1;entryX=0.197;entryY=0;entryDx=0;entryDy=0;entryPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-25" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="550" y="640" as="sourcePoint" />
<mxPoint x="614.9659933782157" y="715.9384377485934" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-17" value="" style="endArrow=none;html=1;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="590" y="610" as="sourcePoint" />
<mxPoint x="699.9959933782156" y="645.9384377485935" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-18" value="" style="endArrow=none;html=1;entryX=0.034;entryY=0.575;entryDx=0;entryDy=0;entryPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="590" y="583" as="sourcePoint" />
<mxPoint x="689.9299999999998" y="552.9999999999995" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-20" value="" style="endArrow=none;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="875" y="232.5" as="sourcePoint" />
<mxPoint x="935" y="192.49999999999977" as="targetPoint" />
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-21" value="" style="endArrow=none;html=1;exitX=0.942;exitY=1.034;exitDx=0;exitDy=0;exitPerimeter=0;entryX=0.399;entryY=0;entryDx=0;entryDy=0;entryPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-30" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="1217.8199999999997" y="540.2199999999998" as="sourcePoint" />
<mxPoint x="1209.9659933782157" y="604.9984377485936" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-24" value="" style="endArrow=none;html=1;entryX=1;entryY=0;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="1275" y="427.5" as="sourcePoint" />
<mxPoint x="1230" y="457.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-25" value="" style="endArrow=none;html=1;exitX=1.017;exitY=0.623;exitDx=0;exitDy=0;exitPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="1233.5700000000002" y="507.3399999999997" as="sourcePoint" />
<mxPoint x="1305" y="507.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-27" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;startArrow=none;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-155" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="340" y="288.04" as="sourcePoint" />
<mxPoint x="730" y="288.04" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-28" value="1:N" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=20;fontColor=#143642;rounded=1;labelBackgroundColor=#DAD2D8;" parent="1IycwErhCTAVCrpmvj0n-27" vertex="1" connectable="0">
<mxGeometry x="0.094" relative="1" as="geometry">
<mxPoint x="-32" y="-38" as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-34" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERmandOne;startArrow=none;entryX=0.429;entryY=1.032;entryDx=0;entryDy=0;entryPerimeter=0;exitX=0.25;exitY=0;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-141" target="nj0aj4-7wqTGS0bk_ivH-1" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="460" y="540" as="sourcePoint" />
<mxPoint x="380" y="387.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-141" value="<font style="font-size: 16px">holds</font>" style="rhombus;whiteSpace=wrap;html=1;arcSize=10;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="297.5" y="427.5" width="90" height="78.13" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-36" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=none;startArrow=ERmandOne;entryX=0.583;entryY=0.928;entryDx=0;entryDy=0;entryPerimeter=0;exitX=0.412;exitY=-0.006;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;exitPerimeter=0;labelBackgroundColor=#DAD2D8;" parent="1" source="1IycwErhCTAVCrpmvj0n-66" target="nj0aj4-7wqTGS0bk_ivH-141" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="477.4999999999998" y="560" as="sourcePoint" />
<mxPoint x="260.05999999999995" y="329.98" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-155" value="<font style="font-size: 16px">Belongs</font>" style="rhombus;whiteSpace=wrap;html=1;arcSize=10;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="580" y="248.75" width="90" height="80" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-37" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=none;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-155" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="340" y="288.03999999999996" as="sourcePoint" />
<mxPoint x="730" y="288.03999999999996" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-39" value="1:1" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="360" y="402.5" width="40" height="30" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-40" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;exitX=1;exitY=0;exitDx=0;exitDy=0;entryX=0.25;entryY=1;entryDx=0;entryDy=0;startArrow=none;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-52" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="840" y="440" as="sourcePoint" />
<mxPoint x="772.5" y="320" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-52" value="<font style="font-size: 16px">worked in</font>" style="rhombus;whiteSpace=wrap;html=1;arcSize=10;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="645" y="402.5" width="90" height="80" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-41" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=none;exitX=1;exitY=0;exitDx=0;exitDy=0;entryX=0.25;entryY=1;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-52" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="589.9999999999998" y="560" as="sourcePoint" />
<mxPoint x="772.5" y="320" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-42" value="M:N" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="720" y="452.5" width="50" height="30" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-43" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;exitX=0.5;exitY=0;exitDx=0;exitDy=0;startArrow=none;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-152" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="1080" y="450" as="sourcePoint" />
<mxPoint x="890" y="320" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="nj0aj4-7wqTGS0bk_ivH-152" value="<font style="font-size: 16px">Manage</font>" style="rhombus;whiteSpace=wrap;html=1;arcSize=10;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="900" y="352.5" width="90" height="80" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-44" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=none;strokeColor=#A8201A;fontColor=#143642;startArrow=none;labelBackgroundColor=#DAD2D8;" parent="1" target="nj0aj4-7wqTGS0bk_ivH-152" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="1100" y="460" as="sourcePoint" />
<mxPoint x="890" y="320" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-45" value="N:1" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="980" y="360" width="50" height="30" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-46" value="<font style="font-size: 14px">Employee_ID(FK)</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="271" y="720" width="145" height="40" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-47" value="" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="387.49999999999704" y="716.88" as="sourcePoint" />
<mxPoint x="452" y="640" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-48" value="<font style="font-size: 14px">Surname</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="180" y="60" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-49" value="<font style="font-size: 14px">First_name</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="30" y="90" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-50" value="" style="endArrow=none;html=1;entryX=0.739;entryY=0.969;entryDx=0;entryDy=0;entryPerimeter=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-8" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="220" y="140" as="sourcePoint" />
<mxPoint x="229.9999999999998" y="99.99999999999999" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-51" value="" style="endArrow=none;html=1;entryX=1;entryY=0.5;entryDx=0;entryDy=0;exitX=0.328;exitY=-0.001;exitDx=0;exitDy=0;exitPerimeter=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-8" target="1IycwErhCTAVCrpmvj0n-49" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="180" y="140" as="sourcePoint" />
<mxPoint x="179.99999999999977" y="109.99999999999977" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-59" value="<i><font style="font-size: 16px">Employee_ID (PK)</font></i>" style="ellipse;whiteSpace=wrap;html=1;align=center;fontStyle=4;fontSize=20;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="20" y="320" width="150" height="60" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-61" value="<i><font style="font-size: 16px">Department_ID (PK)</font></i>" style="ellipse;whiteSpace=wrap;html=1;align=center;fontStyle=4;fontSize=20;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="930" y="160" width="160" height="60" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-62" value="<i><font style="font-size: 16px">Department_manager_ID (PK)</font></i>" style="ellipse;whiteSpace=wrap;html=1;align=center;fontStyle=4;fontSize=20;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="1230" y="360" width="190" height="80" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-63" value="<i><font style="font-size: 16px">Role_ID(PK)</font></i>" style="ellipse;whiteSpace=wrap;html=1;align=center;fontStyle=4;fontSize=20;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="225" y="550" width="150" height="60" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-64" value="<font style="font-size: 14px">Employee_salary</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;dashed=1;fontSize=16;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="415" y="192.5" width="135" height="47.5" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-65" value="<font style="font-size: 14px">Salary_changes</font>" style="ellipse;whiteSpace=wrap;html=1;align=center;dashed=1;fontSize=16;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="690" y="530" width="135" height="47.5" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-66" value="<b style="font-size: 12px"><font style="font-size: 20px">Role</font></b>" style="shape=ext;margin=3;double=1;whiteSpace=wrap;html=1;align=center;rounded=1;fontSize=14;fontColor=#143642;strokeColor=#0F8B8D;fillColor=#FAE5C7;" parent="1" vertex="1">
<mxGeometry x="440" y="560" width="150" height="80" as="geometry" />
</mxCell>
<mxCell id="1IycwErhCTAVCrpmvj0n-67" value="<b style="font-size: 12px"><font style="font-size: 20px">Department_manager</font></b>" style="shape=ext;margin=3;double=1;whiteSpace=wrap;html=1;align=center;rounded=1;fontSize=14;fontColor=#143642;strokeColor=#0F8B8D;fillColor=#FAE5C7;" parent="1" vertex="1">
<mxGeometry x="1000" y="460" width="240" height="80" as="geometry" />
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-1" value="<i><font style="font-size: 16px">Employee_name(FK)</font></i>" style="ellipse;whiteSpace=wrap;html=1;align=center;fontStyle=4;fontSize=20;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="730" y="120" width="220" height="60" as="geometry" />
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-3" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;entryX=0.663;entryY=-0.039;entryDx=0;entryDy=0;entryPerimeter=0;fillColor=#f8cecc;strokeColor=#b85450;" parent="1" target="1IycwErhCTAVCrpmvj0n-67" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="1170" y="80" as="sourcePoint" />
<mxPoint x="1150" y="327.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-5" value="" style="endArrow=none;html=1;rounded=0;fillColor=#f8cecc;strokeColor=#b85450;startArrow=none;" parent="1" source="tICp6fdRJEwek12saLiU-8" edge="1">
<mxGeometry relative="1" as="geometry">
<mxPoint x="470" y="80" as="sourcePoint" />
<mxPoint x="1170" y="80" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-6" value="" style="endArrow=none;html=1;rounded=0;exitX=0.994;exitY=0.103;exitDx=0;exitDy=0;exitPerimeter=0;fillColor=#f8cecc;strokeColor=#b85450;" parent="1" source="nj0aj4-7wqTGS0bk_ivH-1" edge="1">
<mxGeometry relative="1" as="geometry">
<mxPoint x="550" y="169.5" as="sourcePoint" />
<mxPoint x="470" y="80" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-7" value="1:N" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=20;fontColor=#143642;rounded=1;labelBackgroundColor=#DAD2D8;" parent="1" vertex="1" connectable="0">
<mxGeometry x="772.5" y="59.99999999999997" as="geometry" />
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-8" value="<font style="font-size: 16px">Acts as</font>" style="rhombus;whiteSpace=wrap;html=1;arcSize=10;fillColor=#FAE5C7;strokeColor=#0F8B8D;fontColor=#143642;rounded=1;" parent="1" vertex="1">
<mxGeometry x="630" y="40" width="90" height="80" as="geometry" />
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-9" value="" style="endArrow=none;html=1;rounded=0;fillColor=#f8cecc;strokeColor=#b85450;" parent="1" target="tICp6fdRJEwek12saLiU-8" edge="1">
<mxGeometry relative="1" as="geometry">
<mxPoint x="470" y="80" as="sourcePoint" />
<mxPoint x="1170" y="80" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="tICp6fdRJEwek12saLiU-11" value="<span style="font-size: 20px"><b>Department</b></span>" style="shape=ext;margin=3;double=1;whiteSpace=wrap;html=1;align=center;rounded=1;fontSize=14;fontColor=#143642;strokeColor=#0F8B8D;fillColor=#FAE5C7;" parent="1" vertex="1">
<mxGeometry x="735" y="230" width="155" height="90" as="geometry" />
</mxCell>
<mxCell id="vu5et0KWDB8ZZCErD5Ox-1" value="" style="endArrow=none;html=1;entryX=0.411;entryY=1.059;entryDx=0;entryDy=0;strokeColor=#A8201A;fontColor=#143642;labelBackgroundColor=#DAD2D8;exitX=0.565;exitY=-0.034;exitDx=0;exitDy=0;exitPerimeter=0;entryPerimeter=0;" parent="1" source="tICp6fdRJEwek12saLiU-11" target="tICp6fdRJEwek12saLiU-1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="820" y="220" as="sourcePoint" />
<mxPoint x="880" y="179.99999999999977" as="targetPoint" />
<Array as="points" />
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>