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
|
\ifx\TeXMaster\undefined
%
\documentclass{article}
\usepackage{pstricks,pst-node,pst-coil,color,pst-dbicons}
\addtolength{\topmargin}{-2.5cm}
\special{landscape}
\textheight17cm
\textwidth28cm
\evensidemargin-1.2cm
\oddsidemargin-1.2cm
\newcommand{\Mondial}{\textsc{Mondial}}
\begin{document}
\fi %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\newif\ifblackwhite
%\blackwhitefalse
\blackwhitetrue
\ifblackwhite
\newgray{verylightgray}{0.95}
\seticonparams{entity}{shadow=true,fillcolor=lightgray,fillstyle=solid}
\seticonparams{attribute}{fillcolor=lightgray,fillstyle=solid}
\seticonparams{relationship}{shadow=true,fillcolor=lightgray,fillstyle=solid}
\else
\newrgbcolor{lightblue}{0.68 0.85 0.95}
\newrgbcolor{verylightblue}{0.34 0.42 0.5}
\newrgbcolor{lightgreen}{0.00 0.98 0.60}
\newrgbcolor{verylightgreen}{0.00 0.5 0.30}
\newrgbcolor{lightred}{1.00 0.71 0.76}
\newrgbcolor{verylightred}{0.50 0.351 0.38}
\seticonparams{entity}{shadow=true,fillcolor=lightred,fillstyle=solid}
\seticonparams{attribute}{fillcolor=lightblue,fillstyle=solid}
\seticonparams{relationship}{shadow=true,fillcolor=lightgreen,fillstyle=solid}
\fi
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\ifx\TeXMaster\undefined
\begin{center}
{\huge\bf ER-Diagram of the \Mondial\ Database}
\bigskip
\end{center}
\fi
\thispagestyle{empty}
\psset{nodesep=0pt}
\hspace*{2cm}
\begin{tabular}{ccc}
% lang/rel/ethn
\begin{tabular}{c}
\entity{Language} \\[12em]
\entity{EthnicGrp}[Ethnic Grp] \\[12em]
\entity{Religion}
\end{tabular}
\hspace{10em}
% cities/countries/provinces
\begin{tabular}{c@{\hspace{10em}}c}
&\entity[weak]{City} \\[2em]
\entity{Organization}\\[12em]
\entity{Country} \\[12em]
\entity{Continent}\\[2em]
&\entity[weak]{Province}
\end{tabular}
\hspace{10em}
% geo
\begin{tabular}{c}
\entity{Lake} \\[5em]
\entity{River} \\[5em]
\entity{Sea}\\[9em]
\entity{Mountain}\\[7em]
\entity{Island}\\[7em]
\entity{Desert}
\end{tabular}
\end{tabular}
\nodeconnections{\small
\relationshipbetween{Country}{City}{capital}[is\_capital]
\relationshipbetween{Province}{City}{capital}[is\_capital](0.4)
\relationshipbetween[ident]{Province}{City}{in}/\ncarc[arcangle=-30]/
\relationshipbetween[weak]{Province}{Country}{of}
%
\relationshipbetween{Country}{Organization}{ismember}[is\_member](0.6)
\relationshipbetween{Organization}{City}{has\_hq\_in}
%
\relationshipbetween{Country}{Continent}{encompasses}(0.8)
%
\relationshipbetween{Country}(A)
/\ncline[nodesepB=-1cm,offsetA=0.1em,offsetB=0.4cm]/
{Country}(B)
/\ncline[nodesepB=-1cm,offsetA=-0.1em,offsetB=-0.4cm]/
{borders}(7em,0)
%
\relationshipbetween{Province}{Lake}{in}
\relationshipbetween{Province}{River}{in}
\relationshipbetween{Province}{Sea}{in}
\relationshipbetween{Province}{Mountain}{in}
\relationshipbetween{Province}{Island}{in}
\relationshipbetween{Province}{Desert}{in}
%
\relationshipbetween{City}{Lake}{at}
\relationshipbetween{City}{River}{at}
\relationshipbetween{City}{Sea}{at}
%
\inrelationship{River}(main)/\ncarc[arcangle=30]/{flows into}
[flows into](4em,0)
\inrelationship{River}(trib.)/\ncarc[arcangle=-30]/{flowsinto}
\inrelationship{Lake}{flowsinto}
\inrelationship{Sea}{flowsinto}
%
\relationshipbetween{Sea}(A){Sea}(B){merges}(4em,270)
%
\relationshipbetween{EthnicGrp}{Country}{belong}(0.3)
\relationshipbetween{Religion}{Country}{believe}(0.3)
\relationshipbetween{Language}{Country}{speak}(0.4)
%
\attributeof{City}{90}[key]{name}
\attributeof{City}{45}{pop.}
\attributeof{City}{0}{longitude}
\attributeof{City}{-45}{latitude}
%
\attributeof{Organization}{70}[key]{abbrev}
\attributeof{Organization}{130}{name}
\attributeof{Organization}[4em]{1800}{establ.}
%
\attributeof{ismember}{40}{type}
%
\attributeof{borders}{60}{length}
%
\attributeof{Country}[3em]{30}{name}
\attributeof{Country}{70}[key]{code}
\attributeof{Country}{130}{pop.}
\attributeof{Country}[3em]{190}{area}
\attributeof{Country}{230}{gov.}
\attributeof{Country}{280}{infl.}
\attributeof{Country}[3em]{330}{gdp}
\attributeof{Country}[4em]{100}{pop.grw}
\attributeof{Country}[5em]{160}{inf.mort}
\attributeof{Country}[6.5em]{-30}{gdp.agr}
\attributeof{Country}[5.5em]{-50}{gdp.serv}
\attributeof{Country}[5em]{-80}{gdp.ind}
\attributeof{Country}[5em]{-120}{governm.}
%
\attributeof{Continent}{-60}[key]{name}
\attributeof{Continent}{-120}{area}
%
\attributeof{Language}{90}[key]{name}
\attributeof{speak}{60}{percent}
%
\attributeof{EthnicGrp}{90}[key]{name}
\attributeof{belong}{-90}{percent}
%
\attributeof{Religion}{90}[key]{name}
\attributeof{believe}{-90}{percent}
%
\attributeof{encompasses}[4em]{-160}{percent}
%
\attributeof{Province}[4em]{180}[key]{name}
\attributeof{Province}{225}{pop.}
\attributeof{Province}{270}{area}
%
\attributeof{Lake}{0}[key]{name}
\attributeof{Lake}{180}{area}
%
\attributeof{River}{90}[key]{name}
\attributeof{River}{180}{length}
%
\attributeof{Sea}{0}[key]{name}
\attributeof{Sea}{180}{depth}
%
\attributeof{Mountain}{135}[key]{name}
\attributeof{Mountain}{45}{height}
\attributeof{Mountain}{-90}{mtcoord}[geo coord]
\attributeof{mtcoord}[3em]{20}{longitude}
\attributeof{mtcoord}[3em]{-20}{latitude}
%
\attributeof{Island}{90}[key]{name}
\attributeof{Island}{40}{islands}
\attributeof{Island}{-90}{islcoord}[geo coord]
\attributeof{islcoord}[3em]{20}{longitude}
\attributeof{islcoord}[3em]{-20}{latitude}
%
\attributeof{Desert}{90}[key]{name}
\attributeof{Desert}{0}{area}
}
\ifx\TeXMaster\undefined
\end{document}
\fi
% Local Variables:
% TeX-command-default: "LaTeX"
% TeX-master: t
% End:
|
