ERD UMLStandard Trigger W. Kowarschick HS Augsburg 2012 1 ER Händler UMLStandard designModel m97DrrAqA0mW2JONUnkZvgAA 1 ER Trigger True dzh2cIlf5EGQjpgfR8fSKwAA MdX104MGo02ztZQhXfwAbwAA 12 $00E6E6E6 Courier New 9 lsRectilinear 517,449;516,449;516,516 PU+j2ACkhE6SsfcsyDlN7AAA Ins3Sh6TqEKrMsHadPPlTwAA qZEl6jsfB0ywudIwdCMHigAA $00E9E9E9 Courier New 9 196 392 262 111 False eYc5XUUVPUa4ct7rJri+NwAA 1 rechner False False eYc5XUUVPUa4ct7rJri+NwAA False eYc5XUUVPUa4ct7rJri+NwAA False eYc5XUUVPUa4ct7rJri+NwAA $00E9E9E9 Courier New 9 577 392 213 111 False 16kWZew8m02USx65T46XxwAA 1 komponente False False 16kWZew8m02USx65T46XxwAA False 16kWZew8m02USx65T46XxwAA False 16kWZew8m02USx65T46XxwAA $00E9E9E9 Courier New 9 411 516 213 111 False X3PL6Le65k6pbw+x/ajRBgAA 1 bestandteil False False X3PL6Le65k6pbw+x/ajRBgAA False X3PL6Le65k6pbw+x/ajRBgAA False X3PL6Le65k6pbw+x/ajRBgAA $00E6E6E6 Courier New 9 lsRectilinear 457,449;577,449 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,635026986736898 23,6008474424119 epHead 0..* OkJ9OuvMD0aTXHZUYkxjkgAA Courier New 9 0,688924099555169 22,0227155455452 epTail 0..* 2olWlbBHL0u8pw3H9loORQAA False -0,785398163397448 40 epHead OkJ9OuvMD0aTXHZUYkxjkgAA False 0,785398163397448 40 epTail 2olWlbBHL0u8pw3H9loORQAA False -988 -728 50 8 OkJ9OuvMD0aTXHZUYkxjkgAA False -988 -728 50 8 2olWlbBHL0u8pw3H9loORQAA $00E9E9E9 Courier New 9 609 816 180 66 False VXQXeQ2QqUeGXcF2ODHNYQAA 1 basispreis False False VXQXeQ2QqUeGXcF2ODHNYQAA False VXQXeQ2QqUeGXcF2ODHNYQAA False VXQXeQ2QqUeGXcF2ODHNYQAA $00E9E9E9 Courier New 9 196 664 241 126 False 5ELxBucwn0KlWuE9XaGPlAAA 1 bestellung False False 5ELxBucwn0KlWuE9XaGPlAAA False 5ELxBucwn0KlWuE9XaGPlAAA False 5ELxBucwn0KlWuE9XaGPlAAA $00E9E9E9 Courier New 9 lsRectilinear 324,664;324,502 False L5HNCNInn0SctFw20qVcTQAA aRQvZB68IkW7keriNwAgEQAA Vdf5mgOK2kide3Lx+bDcXQAA False 1,5707963267949 15 L5HNCNInn0SctFw20qVcTQAA False 1,5707963267949 30 L5HNCNInn0SctFw20qVcTQAA False -1,5707963267949 15 L5HNCNInn0SctFw20qVcTQAA False -0,523598775598299 30 epHead +qCKqQVynkeo+X6+uaP56AAA False 0,523598775598299 30 epTail RRXlGOtyrkaZ+Kc6fX36rQAA -5,61721562529308 17,8044938147649 epHead 1 +qCKqQVynkeo+X6+uaP56AAA -0,9827928512508 18,0277563773199 epTail 0..* RRXlGOtyrkaZ+Kc6fX36rQAA False -0,785398163397448 40 epHead +qCKqQVynkeo+X6+uaP56AAA False 0,785398163397448 40 epTail RRXlGOtyrkaZ+Kc6fX36rQAA False -1000 -808 50 8 +qCKqQVynkeo+X6+uaP56AAA False -1000 -808 50 8 RRXlGOtyrkaZ+Kc6fX36rQAA $00E9E9E9 Courier New 9 629 664 160 111 False rpiVPMQXZk+6x7/zu5lEAgAA 1 versandkosten False False rpiVPMQXZk+6x7/zu5lEAgAA False rpiVPMQXZk+6x7/zu5lEAgAA False rpiVPMQXZk+6x7/zu5lEAgAA $00E9E9E9 Courier New 9 lsRectilinear 436,724;629,724 False BR2hDYgMNESkTU+s2VAiiQAA 5gOXG7pbbkevtXLGCCXxDwAA Vdf5mgOK2kide3Lx+bDcXQAA False 1,5707963267949 15 BR2hDYgMNESkTU+s2VAiiQAA False 1,5707963267949 30 BR2hDYgMNESkTU+s2VAiiQAA False -1,5707963267949 15 BR2hDYgMNESkTU+s2VAiiQAA False -0,523598775598299 30 epHead KVwliIBwdU67Gwz6NR+3twAA False 0,523598775598299 30 epTail X/YGZj1UYkO4DmgQqcnSwAAA -0,950547313785208 17,2046505340853 epHead 1 KVwliIBwdU67Gwz6NR+3twAA 0,750928729856491 20,5182845286832 epTail 0..* X/YGZj1UYkO4DmgQqcnSwAAA False -0,785398163397448 40 epHead KVwliIBwdU67Gwz6NR+3twAA False 0,785398163397448 40 epTail X/YGZj1UYkO4DmgQqcnSwAAA False -992 -388 50 8 KVwliIBwdU67Gwz6NR+3twAA False -992 -388 50 8 X/YGZj1UYkO4DmgQqcnSwAAA $00D5D5D5 Courier New 9 196 816 279 195 Der Preis einer Bestellung wird zum Zeitpunkt des Erwerbs automatisch (per Trigger) ermittelt, indem der Preis des Rechners und die Versand- kosten addiert werden. Später wird dieser Preis nicht mehr verändert. Anmerkung: Nur fertig konfigurierte Rechner sollten bestellt werden können. Dies wird hier aber nicht modelliert. $00E9E9E9 Courier New 9 lsRectilinear 316,789;316,816 YkLnDka4UES7GaZH0I5+uQAA Vdf5mgOK2kide3Lx+bDcXQAA 10 rechner dzh2cIlf5EGQjpgfR8fSKwAA 4 aRQvZB68IkW7keriNwAgEQAA rR39/uod5UWDn9BQe2G1qAAA cpHOSE7VNUGQ62sfvWmbNwAA OWeY0peSW0OfTJimSpgzagAA 2 2olWlbBHL0u8pw3H9loORQAA +qCKqQVynkeo+X6+uaP56AAA 5 rnr INTEGER {PK} eYc5XUUVPUa4ct7rJri+NwAA name VARCHAR(30) eYc5XUUVPUa4ct7rJri+NwAA gesamtpreis NUMERIC(8,2) {NULLABLE} eYc5XUUVPUa4ct7rJri+NwAA eYc5XUUVPUa4ct7rJri+NwAA {UNIQUE (name)} eYc5XUUVPUa4ct7rJri+NwAA komponente dzh2cIlf5EGQjpgfR8fSKwAA 4 SnDrEjNZUEOYAWf9IZogQgAA nkZZ3PriAEWmGiEeSgzgewAA 0hw//qac60CP6uamD/Tx0wAA +TiTYbc9gkyViJHlzKFbiAAA 1 OkJ9OuvMD0aTXHZUYkxjkgAA 5 knr INTEGER {PK} 16kWZew8m02USx65T46XxwAA bezeichnung VARCHAR(50) 16kWZew8m02USx65T46XxwAA preis NUMERIC(8,2) 16kWZew8m02USx65T46XxwAA 16kWZew8m02USx65T46XxwAA {UNIQUE (bezeichnung)} 16kWZew8m02USx65T46XxwAA bestandteil dzh2cIlf5EGQjpgfR8fSKwAA PU+j2ACkhE6SsfcsyDlN7AAA 4 Ins3Sh6TqEKrMsHadPPlTwAA ppNMGKYam0WPfria11hQ0QAA MrOI8gk62UG54Xx2tnwoPwAA cwiMgXhyXEGRYAOmVAic9QAA 5 rnr INTEGER {FK} X3PL6Le65k6pbw+x/ajRBgAA knr INTEGER {FK} X3PL6Le65k6pbw+x/ajRBgAA anzahl INTERGER {anzahl > 0} X3PL6Le65k6pbw+x/ajRBgAA X3PL6Le65k6pbw+x/ajRBgAA {PK (rnr, knr)} 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 basispreis dzh2cIlf5EGQjpgfR8fSKwAA 4 E29CQd76yEGOZPqELApDrgAA omjrM9/nY0aJwTXJ+x1QVAAA 2mixpWT4h0WyLnSqV0BG3QAA gpTNRnwnRE26MCCCs+HfCQAA 2 grundpreis NUMERIC(8,2) VXQXeQ2QqUeGXcF2ODHNYQAA gewinn FLOAT VXQXeQ2QqUeGXcF2ODHNYQAA bestellung dzh2cIlf5EGQjpgfR8fSKwAA 4 Vdf5mgOK2kide3Lx+bDcXQAA 6vzOssTg8EqWcmLFmOoYmwAA BadDRdI9MESdv5o6whXp+AAA TKvy+agvckeCjlx2FEzoegAA 2 RRXlGOtyrkaZ+Kc6fX36rQAA X/YGZj1UYkO4DmgQqcnSwAAA 6 bnr INTEGER {PK} 5ELxBucwn0KlWuE9XaGPlAAA kunde VARCHAR(50) 5ELxBucwn0KlWuE9XaGPlAAA rnr INTEGER {FK} 5ELxBucwn0KlWuE9XaGPlAAA vnr INTEGER {FK} 5ELxBucwn0KlWuE9XaGPlAAA endsumme NUMERIC(8,2) 5ELxBucwn0KlWuE9XaGPlAAA bestelldatum DATE CURRENT_DATE 5ELxBucwn0KlWuE9XaGPlAAA dzh2cIlf5EGQjpgfR8fSKwAA 4 j7zp1/GUi0e0rzpGPhsV/QAA XssVldbrrEKy3RrriBGdogAA c0kh9OaffkOvPLyPsl9BrgAA 7HJKhD60NEKZZG7vf5TxbAAA 2 0..* L5HNCNInn0SctFw20qVcTQAA 5ELxBucwn0KlWuE9XaGPlAAA 4 SpJH19sNFEq3EN//GfHg1QAA Ze6d2D02aUW1BZyV9ab17gAA EnYjbbhoIkuHokq+LdWLOgAA eC3J+8z0lkqmUUNsf1qnhAAA 1 L5HNCNInn0SctFw20qVcTQAA eYc5XUUVPUa4ct7rJri+NwAA 4 /KJ0yLiGKU+46GbZN2e3hgAA 03MxQo5UmU2H9qp5LbSlKAAA 5N7XiC6UlEuFrR8Ot/w9wgAA zm4MA0aXwUGVtPL0pM2L/gAA versandkosten dzh2cIlf5EGQjpgfR8fSKwAA 4 5gOXG7pbbkevtXLGCCXxDwAA 6wtrDQOeXkGerA3E6i0oowAA wQh+Wz1dzEGbQizaZFHQMgAA BcA1Sxod0EaCWlvR+L0HJgAA 1 KVwliIBwdU67Gwz6NR+3twAA 5 vnr INTEGER {PK} rpiVPMQXZk+6x7/zu5lEAgAA art VARCHAR(30) rpiVPMQXZk+6x7/zu5lEAgAA preis NUMERIC(8,2) rpiVPMQXZk+6x7/zu5lEAgAA rpiVPMQXZk+6x7/zu5lEAgAA {UNIQUE (art)} rpiVPMQXZk+6x7/zu5lEAgAA dzh2cIlf5EGQjpgfR8fSKwAA 4 UIWpNnLdwEqgJ9vlmttu8QAA ZfUPeGq3wkWK/JpA7hc3owAA fn2LKgizG0e5KDaEFReGOgAA d2eYgLAvz0ug4ap2IvslowAA 2 0..* BR2hDYgMNESkTU+s2VAiiQAA 5ELxBucwn0KlWuE9XaGPlAAA 4 kHRBUpSVpU259NXkAJat9gAA MUqk4sdT4kelY9TKWZt5TAAA 4ONRVO6DnEC1tkELu2XrbAAA yuYMoVJhKkOjQSIV4iuKZQAA 1 BR2hDYgMNESkTU+s2VAiiQAA rpiVPMQXZk+6x7/zu5lEAgAA 4 zJcLG3iglE2c+Ma7EHnzdAAA +vLnsLj+b0yvodr6/b0PLAAA yjeRZrFS8kqascy85QAuswAA UNxaKBU7CE+rLxpTbcVNDQAA