UMLStandard Olympia W. Kowarschick HS Augsburg 2011 5 Use Case Model UMLStandard useCaseModel m97DrrAqA0mW2JONUnkZvgAA 1 Main x/ZsjAuPWkSMNYu/gm4ZQwAA L8V9o3ht40eR0ByaQFBgVgAA Analysis Model UMLStandard analysisModel m97DrrAqA0mW2JONUnkZvgAA 1 Main True RobustnessDiagram IyFQ/TNUkUiQmczu/A40uQAA kTe4TD8KckKICmwMMqOpNgAA ER Olympia UMLStandard designModel m97DrrAqA0mW2JONUnkZvgAA 1 ER Olympia True dzh2cIlf5EGQjpgfR8fSKwAA MdX104MGo02ztZQhXfwAbwAA 15 $00E6E6E6 Courier New 9 lsRectilinear 517,321;516,321;516,468 PU+j2ACkhE6SsfcsyDlN7AAA Ins3Sh6TqEKrMsHadPPlTwAA qZEl6jsfB0ywudIwdCMHigAA $00E9E9E9 Courier New 9 145 279 304 156 True False False eYc5XUUVPUa4ct7rJri+NwAA 1 e_sportler False False eYc5XUUVPUa4ct7rJri+NwAA False eYc5XUUVPUa4ct7rJri+NwAA False eYc5XUUVPUa4ct7rJri+NwAA $00E9E9E9 Courier New 9 587 279 241 156 True False False 16kWZew8m02USx65T46XxwAA 1 e_wettkampf False False 16kWZew8m02USx65T46XxwAA False 16kWZew8m02USx65T46XxwAA False 16kWZew8m02USx65T46XxwAA $00E9E9E9 Courier New 9 232 468 325 441 True False False X3PL6Le65k6pbw+x/ajRBgAA 1 r_teilnahme False False X3PL6Le65k6pbw+x/ajRBgAA False X3PL6Le65k6pbw+x/ajRBgAA False X3PL6Le65k6pbw+x/ajRBgAA $00E6E6E6 Courier New 9 lsRectilinear 448,321;587,321 True False False TNLznS5UME2JF06js6dXFAAA SnDrEjNZUEOYAWf9IZogQgAA aRQvZB68IkW7keriNwAgEQAA False 1,5707963267949 15 TNLznS5UME2JF06js6dXFAAA False 1,5707963267949 30 TNLznS5UME2JF06js6dXFAAA False -1,5707963267949 15 TNLznS5UME2JF06js6dXFAAA False -0,523598775598299 30 epHead OkJ9OuvMD0aTXHZUYkxjkgAA False 0,523598775598299 30 epTail 2olWlbBHL0u8pw3H9loORQAA Courier New 9 0,523598775598299 25 epHead 0..* OkJ9OuvMD0aTXHZUYkxjkgAA Courier New 9 -0,523598775598299 25 epTail 0..* 2olWlbBHL0u8pw3H9loORQAA False -0,785398163397448 40 epHead OkJ9OuvMD0aTXHZUYkxjkgAA False 0,785398163397448 40 epTail 2olWlbBHL0u8pw3H9loORQAA False -1020 -856 50 8 OkJ9OuvMD0aTXHZUYkxjkgAA False -1020 -856 50 8 2olWlbBHL0u8pw3H9loORQAA $00E6E6E6 Courier New 9 232 644 325 263 {platz <= (SELECT COUNT(*) FROM r_teilnahme t WHERE t.w_id = NEW.w_id AND t.platz IS NOT NULL ) } {(SELECT geschlecht FROM e_sportler s WHERE s.s_id = NEW.s_id) = (SELECT geschlecht FROM e_wettkampf w WHERE w.w_id = NEW.w_id) } $00E6E6E6 Courier New 9 587 64 241 66 True False False 8DFGhvxyYE2VsbUuj1IXIAAA 1 enum_sportart False False 8DFGhvxyYE2VsbUuj1IXIAAA False 8DFGhvxyYE2VsbUuj1IXIAAA False 8DFGhvxyYE2VsbUuj1IXIAAA $00E6E6E6 lsRectilinear 708,163;708,129 True False False 6gB6SihSpkWtRO4zITGAogAA qAd6kMW7yUih3EEhtTpWaQAA 9cFkwntDGEaHcPSWzcn+RAAA False 1,5707963267949 15 6gB6SihSpkWtRO4zITGAogAA False 1,5707963267949 30 6gB6SihSpkWtRO4zITGAogAA False -1,5707963267949 15 6gB6SihSpkWtRO4zITGAogAA False -0,523598775598299 30 epHead ihnvgruQ7UmMb7rHVYdsGgAA False 0,523598775598299 30 epTail h8fvf1i0HECSmJaeGLGfxwAA 0,837981428128037 13,4536240470737 epHead 1 ihnvgruQ7UmMb7rHVYdsGgAA -1,03907226019513 19,723082923316 epTail 0..* h8fvf1i0HECSmJaeGLGfxwAA False -0,785398163397448 40 epHead ihnvgruQ7UmMb7rHVYdsGgAA False 0,785398163397448 40 epTail h8fvf1i0HECSmJaeGLGfxwAA False -1012 -868 50 8 ihnvgruQ7UmMb7rHVYdsGgAA False -1012 -868 50 8 h8fvf1i0HECSmJaeGLGfxwAA $00E6E6E6 Courier New 9 460 200 118 81 True False False False MfZQmS537kiHAgZUB6K+6AAA 1 ENUM_GESCHLECHT <<enumeration>> False MfZQmS537kiHAgZUB6K+6AAA False MfZQmS537kiHAgZUB6K+6AAA $00E6E6E6 Courier New 9 587 468 241 66 False K8gPfp8UnUCJnLyCaKrcRQAA 1 enum_sportstaette False False K8gPfp8UnUCJnLyCaKrcRQAA False K8gPfp8UnUCJnLyCaKrcRQAA False K8gPfp8UnUCJnLyCaKrcRQAA $00E6E6E6 Courier New 9 587 163 241 81 False d5UVIAQNbkSu6+Cgr4AmbQAA 1 enum_wettkampfart False False d5UVIAQNbkSu6+Cgr4AmbQAA False d5UVIAQNbkSu6+Cgr4AmbQAA False d5UVIAQNbkSu6+Cgr4AmbQAA $00E6E6E6 lsRectilinear 708,279;708,243 KbWGoytMWEqVVlP3exgwbgAA 9cFkwntDGEaHcPSWzcn+RAAA SnDrEjNZUEOYAWf9IZogQgAA False 1,5707963267949 15 KbWGoytMWEqVVlP3exgwbgAA False 1,5707963267949 30 KbWGoytMWEqVVlP3exgwbgAA False -1,5707963267949 15 KbWGoytMWEqVVlP3exgwbgAA False -0,523598775598299 30 epHead Et3nXOJdUEmUJRm8Z4t9XQAA False 0,523598775598299 30 epTail 4DH9VeUx0ECfNGW90s/aUAAA 0,685729761342852 14,2126704035519 epHead 1 Et3nXOJdUEmUJRm8Z4t9XQAA -1,0390724265153 19,723082923316 epTail 0..* 4DH9VeUx0ECfNGW90s/aUAAA False -0,785398163397448 40 epHead Et3nXOJdUEmUJRm8Z4t9XQAA False 0,785398163397448 40 epTail 4DH9VeUx0ECfNGW90s/aUAAA False -996 -916 50 8 Et3nXOJdUEmUJRm8Z4t9XQAA False -996 -916 50 8 4DH9VeUx0ECfNGW90s/aUAAA $00E6E6E6 lsRectilinear 708,434;708,468 dT4GqJa7MEClJQqOD2CrOgAA khghikr8Dk+qzWjVJB4hrgAA SnDrEjNZUEOYAWf9IZogQgAA False 1,5707963267949 15 dT4GqJa7MEClJQqOD2CrOgAA False 1,5707963267949 30 dT4GqJa7MEClJQqOD2CrOgAA False -1,5707963267949 15 dT4GqJa7MEClJQqOD2CrOgAA False -0,523598775598299 30 epHead 2gouEXpFrkm3elxqa01e4wAA False 0,523598775598299 30 epTail lMMsm+YAzkaYZURcyAenqAAA -0,643501348008757 15 epHead 1 2gouEXpFrkm3elxqa01e4wAA 1,03907223882761 19,723082923316 epTail 0..* lMMsm+YAzkaYZURcyAenqAAA False -0,785398163397448 40 epHead 2gouEXpFrkm3elxqa01e4wAA False 0,785398163397448 40 epTail lMMsm+YAzkaYZURcyAenqAAA False -996 -916 50 8 2gouEXpFrkm3elxqa01e4wAA False -996 -916 50 8 lMMsm+YAzkaYZURcyAenqAAA $00E6E6E6 Courier New 9 236 136 213 111 False g4PQBf9uCEeixnp8Ka8CBAAA 1 enum_land False False g4PQBf9uCEeixnp8Ka8CBAAA False g4PQBf9uCEeixnp8Ka8CBAAA False g4PQBf9uCEeixnp8Ka8CBAAA $00E6E6E6 Courier New 9 lsRectilinear 340,279;340,246 False yLPVR9D/cE6StW3KjF49/QAA FfTJrj5DvUeR1wRi0clhtAAA aRQvZB68IkW7keriNwAgEQAA False 1,5707963267949 15 yLPVR9D/cE6StW3KjF49/QAA False 1,5707963267949 30 yLPVR9D/cE6StW3KjF49/QAA False -1,5707963267949 15 yLPVR9D/cE6StW3KjF49/QAA False -0,523598775598299 30 epHead PoIPKimgA0OZNtLvo5/zWQAA False 0,523598775598299 30 epTail BxmyfPqoDEaCyMI5tBILUwAA 0,98279395828967 10,816653826392 epHead 1 PoIPKimgA0OZNtLvo5/zWQAA -1,01219696976944 18,8679622641132 epTail 0..* BxmyfPqoDEaCyMI5tBILUwAA False -0,785398163397448 40 epHead PoIPKimgA0OZNtLvo5/zWQAA False 0,785398163397448 40 epTail BxmyfPqoDEaCyMI5tBILUwAA False -1012 -1000 50 8 PoIPKimgA0OZNtLvo5/zWQAA False -1012 -1000 50 8 BxmyfPqoDEaCyMI5tBILUwAA 14 e_sportler dzh2cIlf5EGQjpgfR8fSKwAA 4 aRQvZB68IkW7keriNwAgEQAA rR39/uod5UWDn9BQe2G1qAAA cpHOSE7VNUGQ62sfvWmbNwAA OWeY0peSW0OfTJimSpgzagAA 2 2olWlbBHL0u8pw3H9loORQAA BxmyfPqoDEaCyMI5tBILUwAA 8 s_id INTEGER {PK} eYc5XUUVPUa4ct7rJri+NwAA name VARCHAR(50) eYc5XUUVPUa4ct7rJri+NwAA vorname VARCHAR(50) {NULLABLE} eYc5XUUVPUa4ct7rJri+NwAA geburtstag DATE eYc5XUUVPUa4ct7rJri+NwAA geschlecht ENUM_GESCHLECHT eYc5XUUVPUa4ct7rJri+NwAA l_id INTEGER {FK} eYc5XUUVPUa4ct7rJri+NwAA eYc5XUUVPUa4ct7rJri+NwAA {UNIQUE (name, vorname, geb, l_id)} eYc5XUUVPUa4ct7rJri+NwAA e_wettkampf dzh2cIlf5EGQjpgfR8fSKwAA 4 SnDrEjNZUEOYAWf9IZogQgAA nkZZ3PriAEWmGiEeSgzgewAA 0hw//qac60CP6uamD/Tx0wAA +TiTYbc9gkyViJHlzKFbiAAA 3 OkJ9OuvMD0aTXHZUYkxjkgAA 4DH9VeUx0ECfNGW90s/aUAAA lMMsm+YAzkaYZURcyAenqAAA 8 w_id INTEGER {PK} 16kWZew8m02USx65T46XxwAA wa_id INTEGER {FK} 16kWZew8m02USx65T46XxwAA geschlecht ENUM_GESCHLECHT 16kWZew8m02USx65T46XxwAA spst_id INTEGER {FK} 16kWZew8m02USx65T46XxwAA beginn TIMESTAMP 16kWZew8m02USx65T46XxwAA 16kWZew8m02USx65T46XxwAA 16kWZew8m02USx65T46XxwAA {UNIQUE (wa_id, geschlecht)} 16kWZew8m02USx65T46XxwAA r_teilnahme dzh2cIlf5EGQjpgfR8fSKwAA PU+j2ACkhE6SsfcsyDlN7AAA 4 Ins3Sh6TqEKrMsHadPPlTwAA ppNMGKYam0WPfria11hQ0QAA MrOI8gk62UG54Xx2tnwoPwAA cwiMgXhyXEGRYAOmVAic9QAA 21 s_id INTEGER {FK} X3PL6Le65k6pbw+x/ajRBgAA w_id INTEGER {FK} X3PL6Le65k6pbw+x/ajRBgAA platz INTEGER {NULLABLE} X3PL6Le65k6pbw+x/ajRBgAA doping BOOLEAN {NULLABLE} X3PL6Le65k6pbw+x/ajRBgAA disqualifiziert BOOLEAN FALSE X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA {PK (s_id, w_id)} X3PL6Le65k6pbw+x/ajRBgAA {NOT (doping AND NOT disqualifiziert)} X3PL6Le65k6pbw+x/ajRBgAA {NOT (disqualifiziert AND platz IS NOT NULL)} X3PL6Le65k6pbw+x/ajRBgAA {platz > 0} X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA dzh2cIlf5EGQjpgfR8fSKwAA PU+j2ACkhE6SsfcsyDlN7AAA 4 qZEl6jsfB0ywudIwdCMHigAA 9HcEWZKkaEKbUe+4VvexUwAA Cebznc2JmE2SqC8OvQIp7AAA Qk2btOJHgEqb55HW+eU5ggAA 2 0..* TNLznS5UME2JF06js6dXFAAA eYc5XUUVPUa4ct7rJri+NwAA 4 bt1R3pw20EyrkYNBN9GQ1QAA VW3E5jBKT0O0veu8b2nRvwAA FnlH/hu7lEa1fyBO1YSWYAAA 9XI4ducjr0KikUPkUnUz7wAA 0..* TNLznS5UME2JF06js6dXFAAA 16kWZew8m02USx65T46XxwAA 4 LAo2mTXDNkaLA0nDoZ2MBgAA 7axJRUnOH0CB+XInC3IcIAAA V5K9F8chUUqlNphst+9quQAA 78LTIPZGyE2Q4zNhLhmg9QAA dzh2cIlf5EGQjpgfR8fSKwAA X3PL6Le65k6pbw+x/ajRBgAA TNLznS5UME2JF06js6dXFAAA 1 VGQpsb+XnkGt9phkk4WeWgAA enum_sportart dzh2cIlf5EGQjpgfR8fSKwAA 4 qAd6kMW7yUih3EEhtTpWaQAA WZjMohhNREuSXXcwGxi/8gAA ZvxEdiXmPEOSKedDIyv3FQAA ktqQz1iQwUOrgrOGDx2tIQAA 1 ihnvgruQ7UmMb7rHVYdsGgAA 2 sa_id INTEGER {PK} 8DFGhvxyYE2VsbUuj1IXIAAA bezeichnung VARCHAR(50) {UNIQUE} 8DFGhvxyYE2VsbUuj1IXIAAA dzh2cIlf5EGQjpgfR8fSKwAA 4 5RON7k3080KVyIjbfwoKQQAA /dq1N4PUkEWOVu+AkLFQYgAA 6rVmaN0E+kWkbmvJZNd0BwAA yX3ebZddNUWIzqIKrMGBlAAA 2 0..* 6gB6SihSpkWtRO4zITGAogAA d5UVIAQNbkSu6+Cgr4AmbQAA 4 IThfKCLiTUyJwak6HhD+yQAA C1+++1ZHx0e64bF7O6VqyQAA oPs7uB7oL0OjR8U888uqoAAA Q5FkK2boOUKasUBfwKXoTAAA 1 6gB6SihSpkWtRO4zITGAogAA 8DFGhvxyYE2VsbUuj1IXIAAA 4 HKysMh6jWEeqJlF5kkiuCQAA hvX9r6sSfU+6cHFpzwZkPAAA vBpJCVUKj0S2zbztfwzazQAA GNRIprhmOEmbzrG7c/fxpgAA ENUM_GESCHLECHT dzh2cIlf5EGQjpgfR8fSKwAA 3 BVaVgwcBZUa01f3lnnZjmgAA WX5tsUhR1ECJ769LQNQwKgAA /OafrTVItkeqE9VKhbc2nQAA 2 w MfZQmS537kiHAgZUB6K+6AAA m MfZQmS537kiHAgZUB6K+6AAA enum_sportstaette dzh2cIlf5EGQjpgfR8fSKwAA 4 khghikr8Dk+qzWjVJB4hrgAA qM5OuMTh90esOkBqBbuylQAA 4lym3n0ZQ0+gY9lTY0FesQAA lJy2V7R4wUGhPxe+IiSouQAA 1 2gouEXpFrkm3elxqa01e4wAA 2 spst_id INTEGER {PK} K8gPfp8UnUCJnLyCaKrcRQAA bezeichnung VARCHAR(50) {UNIQUE} K8gPfp8UnUCJnLyCaKrcRQAA enum_wettkampfart dzh2cIlf5EGQjpgfR8fSKwAA 4 9cFkwntDGEaHcPSWzcn+RAAA B/4lNlkIFk2bJp3Z9Pj+qQAA IAnpDZbgfk6dbYGibXKlzgAA ScmMSCM/cECaYmeI3WhqfQAA 2 Et3nXOJdUEmUJRm8Z4t9XQAA h8fvf1i0HECSmJaeGLGfxwAA 3 wa_id INTEGER {PK} d5UVIAQNbkSu6+Cgr4AmbQAA sa_id INTEGER {FK} d5UVIAQNbkSu6+Cgr4AmbQAA bezeichnung VARCHAR(50) {UNIQUE} d5UVIAQNbkSu6+Cgr4AmbQAA dzh2cIlf5EGQjpgfR8fSKwAA 4 xT2JmVEk8Eesj8fDWl9anAAA mwBAWLb0E0WJLV+awW58SAAA Jw6GTS9fPku60e7kkWBzfQAA UrtJuf9qtEKm34O7nbZ8OAAA 2 0..* KbWGoytMWEqVVlP3exgwbgAA 16kWZew8m02USx65T46XxwAA 4 wgpTdebaS0CCA0GyVrh83gAA DBOiqlfOtESGxcKysaxvWwAA EyqTwguPtUC80l5ocZVnsgAA F4M0SX+OGkabZn+3ioLmAQAA 1 KbWGoytMWEqVVlP3exgwbgAA d5UVIAQNbkSu6+Cgr4AmbQAA 4 v242EUE0CUuzMhV0TDDR0gAA 4isPwGZvekawspLzYpDxfAAA oupO1lyC6kKxuo6vonk7KgAA OlWxSnzEAkWLOPOSgckVeQAA dzh2cIlf5EGQjpgfR8fSKwAA 4 8NNd2S05ZEOWXp3Y/u4l2AAA 7IIG+C7hCEGwtiRgK+GmAwAA 6X2AdfF3kE+0C4VrtTri/wAA 6JffnW+XTUOAGJjU92CEXwAA 2 0..* dT4GqJa7MEClJQqOD2CrOgAA 16kWZew8m02USx65T46XxwAA 4 eqf4vp8fV0aYZ6QVMR7j5QAA FAd7/wOcykya2C0WZr2A2wAA d+zZGwGjwE+6668SjlEjTQAA jhYP5R2D6kak2K75jI4irAAA 1 dT4GqJa7MEClJQqOD2CrOgAA K8gPfp8UnUCJnLyCaKrcRQAA 4 W9yX3h0sIESCkh8BHBtj1wAA lEALOG1n7E+jwGZkxcklCwAA fnTVKQw3i0qFSgHlDmq2wAAA E2k4raJSZUWfpE5GLZVruQAA enum_land dzh2cIlf5EGQjpgfR8fSKwAA 4 FfTJrj5DvUeR1wRi0clhtAAA 80xvjDAm70qwKiSq4XpJKgAA NsQKRu6emk6DzY8Rz4TfWAAA tenia3H2CkW3Ox4PCF3BmQAA 1 PoIPKimgA0OZNtLvo5/zWQAA 5 l_id INTEGER {PK} g4PQBf9uCEeixnp8Ka8CBAAA kuerzel CHAR(3) {UNIQUE} g4PQBf9uCEeixnp8Ka8CBAAA name_de VARCHAR(50) {UNIQUE} g4PQBf9uCEeixnp8Ka8CBAAA name_en VARCHAR(50) {UNIQUE} g4PQBf9uCEeixnp8Ka8CBAAA name_fr VARCHAR(50) {UNIQUE} g4PQBf9uCEeixnp8Ka8CBAAA dzh2cIlf5EGQjpgfR8fSKwAA 4 87gzIyLjyEqxaioHYG9lPgAA 7PRL0CoXh0aRBToBLxquPAAA 3v2PO8RuYkydmekUGdPPXAAA Pz1GbWm7XUWPNbG0GXbmFAAA 2 0..* yLPVR9D/cE6StW3KjF49/QAA eYc5XUUVPUa4ct7rJri+NwAA 4 cCg1wXm5nk6YkwWpYsDJ/wAA VEy5VMj1JUWvmIQPBs+PAgAA +VY9CZpYw0u/CQlzPawLOgAA 6lnFet0ZVkqynZhlMK8URgAA 1 yLPVR9D/cE6StW3KjF49/QAA g4PQBf9uCEeixnp8Ka8CBAAA 4 jR94HSfZBkeu6t6CSslkrAAA bjP+9RUx/0OK9B9A/zUmygAA w68nzfNYBUukhTekbcB9XAAA qMfyeNmSwkOKvaiB9BjpowAA Implementation Model UMLStandard implementationModel m97DrrAqA0mW2JONUnkZvgAA 1 Main 93XX3CBQAka4ydfmItxQWAAA zPaDoQjt10iNxWtQkmttbwAA Deployment Model UMLStandard deploymentModel m97DrrAqA0mW2JONUnkZvgAA 1 Main jYm/gyyPTUmHMKwGoDaoGAAA kg95vyU3CUKPtcPpLM8ZLwAA