-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathConceptual and Logical ER Diagram.drawio
133 lines (133 loc) · 13.2 KB
/
Conceptual and Logical ER 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
<mxfile host="app.diagrams.net" agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36" version="24.7.7">
<diagram id="R2lEEEUBdFMjLlhIrx00" name="Page-1">
<mxGraphModel dx="811" dy="808" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="850" pageHeight="1100" math="0" shadow="0" extFonts="Permanent Marker^https://fonts.googleapis.com/css?family=Permanent+Marker">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
<mxCell id="D5zzJ316PHObMPMX6Ffj-1" value="Ticket" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="100" y="100" width="250" height="130" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-2" value="TicketNumber<div>Price</div><div>FlightClass</div><div>ReservedDateTime</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="D5zzJ316PHObMPMX6Ffj-1" vertex="1">
<mxGeometry y="50" width="250" height="80" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-3" value="Airport" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="520" y="90" width="160" height="140" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-4" value="IATACode<div>Name</div><div>City</div><div>State</div><div>Country</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="D5zzJ316PHObMPMX6Ffj-3" vertex="1">
<mxGeometry y="50" width="160" height="90" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-5" value="Flight" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="460" y="280" width="315" height="160" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-6" value="Number<div>DepartureDateTime</div><div>ArrivalDateTime</div><div>Duration</div><div>Distance</div><div>Airline</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="D5zzJ316PHObMPMX6Ffj-5" vertex="1">
<mxGeometry y="50" width="315" height="110" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-7" value="Passenger" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="110" y="300" width="240" height="120" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-8" value="FirstName<div>LastName</div><div>Passenger ID</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="D5zzJ316PHObMPMX6Ffj-7" vertex="1">
<mxGeometry y="50" width="240" height="70" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-9" value="" style="edgeStyle=orthogonalEdgeStyle;fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;" parent="1" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="350" y="170" as="sourcePoint" />
<mxPoint x="490" y="280" as="targetPoint" />
<Array as="points">
<mxPoint x="350" y="171" />
<mxPoint x="490" y="171" />
<mxPoint x="490" y="280" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-11" value="Issued For" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" parent="D5zzJ316PHObMPMX6Ffj-9" vertex="1" connectable="0">
<mxGeometry x="-0.368" y="-1" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-10" value="Depart/Arrives At" style="fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" target="D5zzJ316PHObMPMX6Ffj-4" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="600" y="280" as="sourcePoint" />
<mxPoint x="700" y="180" as="targetPoint" />
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-12" value="" style="fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;exitX=1;exitY=0.25;exitDx=0;exitDy=0;entryX=-0.003;entryY=0.345;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="D5zzJ316PHObMPMX6Ffj-8" target="D5zzJ316PHObMPMX6Ffj-6" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="240" y="460" as="sourcePoint" />
<mxPoint x="340" y="358" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-13" value="Reserved" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" parent="D5zzJ316PHObMPMX6Ffj-12" vertex="1" connectable="0">
<mxGeometry x="-0.0169" y="4" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-14" value="" style="fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;" parent="1" source="D5zzJ316PHObMPMX6Ffj-7" target="D5zzJ316PHObMPMX6Ffj-2" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="130" y="290" as="sourcePoint" />
<mxPoint x="230" y="190" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-15" value="Purchases" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" parent="D5zzJ316PHObMPMX6Ffj-14" vertex="1" connectable="0">
<mxGeometry x="0.025" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-1" value="<b>Conceptual Model</b>" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fillColor=#f8cecc;strokeColor=#b85450;" parent="1" vertex="1">
<mxGeometry x="290" y="20" width="250" height="30" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-2" value="Ticket" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="100" y="580" width="250" height="130" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-3" value="TicketNumber<div>Price</div><div>FlightClass</div><div>ReservedDateTime</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="Eo4R0gdq7I3NfMAVnbih-2" vertex="1">
<mxGeometry y="50" width="250" height="80" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-4" value="Airport" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="520" y="570" width="160" height="140" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-5" value="IATACode<div>Name</div><div>City</div><div>State</div><div>Country</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="Eo4R0gdq7I3NfMAVnbih-4" vertex="1">
<mxGeometry y="50" width="160" height="90" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-6" value="Flight" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="460" y="760" width="315" height="160" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-7" value="Number<div>DepartureDateTime</div><div>ArrivalDateTime</div><div>Duration</div><div>Distance</div><div>Airline</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="Eo4R0gdq7I3NfMAVnbih-6" vertex="1">
<mxGeometry y="50" width="315" height="110" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-8" value="Passenger" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
<mxGeometry x="110" y="780" width="240" height="120" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-9" value="FirstName<div>LastName</div><div>Passenger ID</div>" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="Eo4R0gdq7I3NfMAVnbih-8" vertex="1">
<mxGeometry y="50" width="240" height="70" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-10" value="Issued For" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" parent="1" vertex="1" connectable="0">
<mxGeometry x="428" y="652" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-11" value="Depart/Arrives At" style="fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" target="Eo4R0gdq7I3NfMAVnbih-5" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="600" y="760" as="sourcePoint" />
<mxPoint x="700" y="660" as="targetPoint" />
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-12" value="Reserved" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" parent="1" vertex="1" connectable="0">
<mxGeometry x="404.01604557391624" y="843.7228555022846" as="geometry" />
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-13" value="" style="fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;exitX=0.5;exitY=0;exitDx=0;exitDy=0;" parent="1" source="Eo4R0gdq7I3NfMAVnbih-8" target="Eo4R0gdq7I3NfMAVnbih-3" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="130" y="770" as="sourcePoint" />
<mxPoint x="230" y="670" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-14" value="Purchases" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" parent="Eo4R0gdq7I3NfMAVnbih-13" vertex="1" connectable="0">
<mxGeometry x="0.025" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="Eo4R0gdq7I3NfMAVnbih-15" value="<b>Logical Model</b>" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fillColor=#e1d5e7;strokeColor=#9673a6;" parent="1" vertex="1">
<mxGeometry x="290" y="500" width="250" height="30" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>