-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathConceptual ER Diagram.drawio
74 lines (74 loc) · 7.04 KB
/
Conceptual 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
<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;" vertex="1" parent="1">
<mxGeometry x="60" y="90" width="160" height="120" 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;" vertex="1" parent="D5zzJ316PHObMPMX6Ffj-1">
<mxGeometry y="50" width="160" height="70" 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;" vertex="1" parent="1">
<mxGeometry x="440" y="80" 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;" vertex="1" parent="D5zzJ316PHObMPMX6Ffj-3">
<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;" vertex="1" parent="1">
<mxGeometry x="345" y="270" 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;" vertex="1" parent="D5zzJ316PHObMPMX6Ffj-5">
<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;" vertex="1" parent="1">
<mxGeometry x="60" y="290" width="160" 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;" vertex="1" parent="D5zzJ316PHObMPMX6Ffj-7">
<mxGeometry y="50" width="160" height="70" as="geometry" />
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-9" value="" style="edgeStyle=orthogonalEdgeStyle;fontSize=12;html=1;endArrow=ERmany;startArrow=ERmany;rounded=0;entryX=0.25;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="1" target="D5zzJ316PHObMPMX6Ffj-5">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="220" y="160" as="sourcePoint" />
<mxPoint x="320" y="60" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="D5zzJ316PHObMPMX6Ffj-11" value="Issued For" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=12;" vertex="1" connectable="0" parent="D5zzJ316PHObMPMX6Ffj-9">
<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;" edge="1" parent="1" target="D5zzJ316PHObMPMX6Ffj-4">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="520" y="270" as="sourcePoint" />
<mxPoint x="620" y="170" 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;" edge="1" parent="1" source="D5zzJ316PHObMPMX6Ffj-8">
<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;" vertex="1" connectable="0" parent="D5zzJ316PHObMPMX6Ffj-12">
<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;" edge="1" parent="1" source="D5zzJ316PHObMPMX6Ffj-7" target="D5zzJ316PHObMPMX6Ffj-2">
<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;" vertex="1" connectable="0" parent="D5zzJ316PHObMPMX6Ffj-14">
<mxGeometry x="0.025" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>