https://drawio-notion-embed.netlify.app/?u=https%3A%2F%2Fviewer.diagrams.net%2F%3Fborder%3D0%26tags%3D%257B%257D%26highlight%3D0000ff%26edit%3D_blank%26layers%3D1%26nav%3D1%26title%3Desercizio%2520lez%25203.drawio%26open%3DR7Vzfc5s4EP5r%252FNgMIMDmMXaSu840M7nzdK59lI1s605GFOTY6V9%252FwggwEgTs8stO8xJYibW83367qxXJCMy2hz8C6G%252BeqYvIyNDcwwg8jAxDNzSD%252F4okb7HEBmYsWAfYFZMywRz%252FREKoCekOuyjMTWSUEob9vHBJPQ8tWU4Gg4Du89NWlOQ%252F1YdrpAjmS0hU6T%252FYZRsh1W0nG%252FgT4fVGfPTEGMcDW5hMFt8k3ECX7k9E4HEEZgGlLL7aHmaIRMZL7BI%252F91Qymi4sQB6r88BiQY2f%252F87gdvdlugDmj7%252FoV%252B2T0PIKyU584ZFhE65vuqJcLV81exOmsH%252FsaDLwKTwCdc8n6KbPwZ5m4%252FxqLX4fFS0SwQsKQurBRM5XupDncln8uYnYyC3BCOjOc1H0hTQ%252BvN9ghuY%252BXEaje%252B5%252FXLZhW8Lv9PTpVxQwdCi1mZ4iwV0Y0S1iwRufIh4ACXjCeyfidp%252B5gpVM2Zx4gS1kUHjfOtWcAcQvBEZn4GUU4CXZCHnufeT4%252FM6jHsrbJG%252FAkMGASZNjfchVaCHZjH8m3QVL9M5iQbFtT41XYLtEFiACGX7NL6PIoOITXig%252BeqyALtUjoHMkSOLVi4dOaSPpkV1A1sNNuEZM0XNEN%252F3SlwMOagBOCI%252BGqJoQMPTjELnCh8gHpitMyIwSGhwVAe340wxzuLYq5hQRx2iLOGajxKlPktg9fpOkVZJY7WWx2VPd3MS5wvI%252BE7KA%252FocSggmfOuWcEEGC1x6%252FXXLnQVw%252BjZiHeQ1yLwa22HVJGcGLPPPXqKvlwRxbCnVBgUuCtqg7uaac5%252FRKZzOPnC5jcimfFUUtE9ppM%252Bu1kN10o%252Bf0lmyXhpfffhOiCULoRYV%252FUymOrj2%252BwA%252BX53RbwlRXE924y0Sn1yn2mydxX%252BScyOTUrMvI6cjklBW1Tc46m4umNmlPxx%252BFdQ1v3xxdKuhVanSb31os8R%252FZaAZG99qHC4COVMU4ahFjdhr%252F7FKQ007hV7qlxR1ECaWzWoXlXIo8QXSlOc3L2dgAHPK%252BK%252B0inuChd9pt1MfVgDxQr6yne%252FWImMNDpNnNsGzLoZcMcj0PZEPXLRkURXLmartkaHWHOwjyyHtkUECeTmuIRPGJzZ8xwRxpNNAcX0zPX0NFKuxAQWPeLkLFbguV8iPINJV83voYrSG71cxvm0PLM0k4eg%252BVOdu5kZPfKCjy9nQAoDTbH5BtiQ6YfRNj0fX36PrOEncPh5Ohh7fRuY3Cys55v5WFbZWgfW5lYZfVjB1VFkarzYhBMNOamHkTW31XFmp3Ys6wz7mI6ccpLSxbgqXgUKSotGitn2AUbV8bjJceX%252BS3LEhGt9%252BTIBndZCHzeHd%252BzKw8XIm%252FUF8xc1wV6mo3cGVFNXdjHDn4djLNjyaEZyxYfmWu5royp4xX0GwAr7HFDzfQjy5XBB2E%252B05PPHlJYBji5XnO7CbvN1rGnWPq%252Btg2x5o1mRhiOJkN7kAyAizDMY0o3ohHwfguN6af4e69HUNUOV9dL5YV6Wa3mT%252BJo1ca7nrrKdkNRTGzSlFDUUxZcEUUU9bVRRQDRdv6K45i75ezw%252FVuUAL%252B%252BW9AyKflXUe3oo5Ec9Ft6Diak7z5Tdn8lx6WK4oailLKgrWKWktel9ZFlKrRUbniKCW9ETBc75YL8%252FTg7VzvlhV1fa6T%252FHVTS1HqWrOQgu%252Bl0avSUdrGt%252Fw9lOxEHAeIMRrcamNcPq1IweytMQ5qvDgyR2sOCwzwrR4imWWJvT9Yarw%252B8hJQzleGQ3arL5FM7MHhUuPlg2uqeoae%252FeTS1ppcmP0URR1nv8Rz3yP03yj0qRfCBSa3mgBlRlsF71B0y2izRrflhjfHutbYSYTcLun4LxnNOl2O6z69VcHq%252B%252FjWVLsAz5AFeEkJVKx%252Fs8e3jtSwafH4lt9m%252F%252Fcipk7230PA4%252F8%253D
https://drawio-notion-embed.netlify.app/?u=https%3A%2F%2Fviewer.diagrams.net%2F%3Fborder%3D0%26tags%3D%257B%257D%26highlight%3D0000ff%26edit%3D_blank%26layers%3D1%26nav%3D1%26title%3Desercizio%2520lez%25203.drawio%26open%3DR7V1dc9o4FP01zOw%252BlLEtfz4GaLqd2e1mm%252B5H%252BuZgBTRrEGtMA%252Fn1K2MZbEkOKrUkqMtLsCzL5p6ro3uPJGcAxovtuyxezX%252FDCUwHjpVsB2AycBzbsRzypyjZlSU%252BcMuCWYYSWulYcI9eIC20aOkGJXDdqJhjnOZo1Syc4uUSTvNGWZxl%252BLlZ7Qmnzbuu4hnkCu6nccqX%252Fo2SfE5LbT86nvgFotmc3jp0gvLEIq4q01%252BynscJfq4VgbcDMM4wzstvi%252B0YpoXxKruU1922nD08WAaXucwFDx%252FvHoJf79%252Ftbre%252Fv3%252F5NNou%252FwRvaCtf4nRDf%252FDA8VPS3ugJk2bJU%252Bc7agr%252Fvw2uTrxZ74G6IRVsd0XAHh3Pk28z%252Bnff0GNVMEEZfEF4Casz5Fkf2dqkrLxzVew0HsLJ5njxuCGgjp7nKIf3q3hanHkm3kfK5vkiJUf24covMMvhttVi9gEH4sAQL2Ce7UgVeoFXOS%252F1XUCRfK45gk%252FdeV73AVovpr43O7R8hId8oQh9BVpOK1oHO75frBCcxTkWG5m1Jt4sE1jc0jpt0QIX2kFttxsLO67VsLBtCUxcdaC6iX1VJganTTxB5AfmaEF%252B43VYObQuzcquwMqM0eAyuSn4mxwtC85oGKlpUdZkxCzZ7h96cn%252FwUBwMvepwsq2fnOzoUfkMMOFGBMbQZAiKsxnMT%252FEqD0jN4J7A3lVZBtM4R1%252BajyECgd7hDqM9WVO8gdOCd9XEGm%252ByKaRX1YcMtqGg2ZDHtFOagWuH4BbvatVWRYW1%252FPMGjYGMfCkbPLrbwaLne6CnxwPtfnpg2MbrX%252BuBfiB0ja49kH1eHR7ocx74E7nr2P6Zc0TC%252FHnT%252B%252BIUzZbk%252B5S4BcxIQTE%252BIBK13tATC5QkxeWjDJJQLX7cN1V4GLUEadcbDbxJ0dYmx2vqu%252BRwnWf4XzjGKc6Ojv%252BE0pQt6n6cchmwBfGWyGeBqlEq4BGy%252B42Q714WQqFSFpdlY1Mse0g0vpVl2TBckmW7YsJIAsU0JRk%252FPB0%252Bx%252BtVKQM8oW0BrJKshYlXfL4XiKJpR1UvqLSSmgHHeLYkrfeWqOzoJFGFOonK1im03Dw9QWKol%252FhahRZb0KP0Ki22SGoxn6HCLcr3lw19P6DHD%252FSOxffjZcVB%252Fao7mCFimqKHd55p0IrlaPNKReeiBsvozMGSTYpt1gkVZcWOpSEpsUX6l%252Fm8%252BOj3wAE1v7eGURhdhe8Dk77PprfcOHduOu6wEaeifFyP7%252FOq5I%252BMnOE6wcCsNeGzed1uj9GH%252FmLE5uTmMeKVLTWx03HYOMRAmrRVo2m%252FF7pNcmQDEGk2ZyMMSX2%252FM8LlBTbeUS4p8feCFssby%252Fx5AWwS53FvudDzogZAQDDTqZcLeW2r7zEFR1%252FAM4tR1Tt7qiKHXanIEWg2pFlFdkQS2yWPJqy9TMvIlb1qBvwEU0h%252BOe4tWUXM0hnTOrLD6zP7Ocke5z%252Bhf7Ib6R1OREtLVEn9dzGx3BSt4qtaWOlUcesrcbTmlZWinFUVaGO8WBWd55ogC4KLg0wme%252FwGmeEgOXt1wfl1sVm5NHF6joWyz0kNwxHDrUnC4Fb6XKmE4ahdgXKtTuhLOqHRWZHvxwlbRIYeB4XA8hhIDIsMVcOKicKWpokOuzswuwqOSaPPntjnVgiw2x8Ud2OgVcCo98NBwX3FR014f0DElLIBeGVjjBM07fP6OIYfbR6iQCs%252Fql14Ist2pkiM1QK5hRWyJMapubpJTGZjzUWpsOxmKeNkxacUH%252Fq8lJeVYEVU5WulKpn16t8vVYUe02ECd%252BgyrUhPGbFrVwRtKSYs93uJujhb%252BnzKo4rI7j3b%252FjBCnz%252B%252F%252FcNHtx%252Fj0XqFBO8W6Pv2qdBgViqEiI%252BLu2SyNme%252FgBVcpUxqikIBM6S5V6A8Cf1H4m0JdxkmT6DjTQmMu93uPx1ltG4LYDreoCC0vGCtcs%252FngVnJD3g8RlrJVe0yWFPkaizs9DviTLYhoC5DFrqFaNqS4cx7mLRMDF8JX7JvnDHPl3xS3Xe%252BDG2mH5jmS7VptQRfAlAnTGsYRSf3pRVH3Wwva4%252BvjE2ssEHPuRMrpqNUwf54zZ7luz9cq5EAsYP51bqWTAatSj3qNMMBLYgYU49kJoSuQZcD3qVZls8dR5ukYIu%252BhkIOkzp6GmdDxRDxs2i9ngMCDDuJAFI1ByQGyHhyrzukMDYz7nD0OQTnBQthEAxt3zp87GbDvjW06h9fbyShdTOsynkouxUwYyMen%252F2PUZ4PxmBwY%252FWWVMOIG%252FUEQGmVAATbZTXTqmYNwJiaygp05yZgIYiGNUplOdWLhkGdUz2tnCrY2ft%252BmaAMvbzwWxqlyVVjVha0STB1HdUWuYk7DBT1Ual9tgr66GErhBU0VjkPiVUG6l4BVV%252F9%252FIqTmerI7CYGlx1EZTtywDKC5GvNOuurMkqKSuofKJgsk9DhzLoPi7rHTsCcK8QBdbv%252FxWY0KRd1Sfk%252B8%252BbSwyu4TAXPjsw%252Fa7hGy3qCCS%252B9luVFhL9Qf1%252Fe4zNL112Xx8cV4KNudRyfko9v7vqLT8Dkiw6PT0fZIjk8%252FmOscog4%252Fnsx8PZ%252F
Entità | Descrizione | Attributi | Identificatore |
---|---|---|---|
Impiegato | dipendente dell’azienda | Codice, Cognome, Stipendio | Codice |
Progetto | progetti aziendali | Nome, Budget | Nome |
Dipartimento | struttura aziendale | Nome, Telefono | Nome, Sede |
Sede | sede dell’azienda | Città, Indirizzo | Città |
Relazioni | Descrizione | Componenti | Attributi |
---|---|---|---|
Direzione | direzione di un dipartimento | Impiegato, Dipartimento | |
Afferenza | afferenza a un dipartimento | Impiegato, Dipartimento | Data |
Partecipazione | partecipazione a un progetto | Impiegato, Progetto | |
Composizione | composizione dell’azienda | Dipartimento, Sede |
Vincoli di integrità sui dati |
---|
(1) Il direttore di un dipartimento deve afferire a tale dipartimento |
(2) Un impiegato non deve avere uno stipendio maggiore del direttore del dipartimento al quale afferisce |
(3) Un dipartimento con sede a Roma deve essere diretto da un impiegato con più di dieci anni di anzianità |
(4) Un impiegato che non afferisce a nessun dipartimento non deve partecipare a nessun progetto |