Specifica

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

Documentazione associata agli schemi concettuali

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

Dizionario dei dati (entità)

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à

Dizionario dei dati (associazioni)

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 non esprimibili

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