A76-27 Banca.erdplus

{"version":2,"www":"erdplus.com","shapes":[{"type":"Entity","details":{"name":"Filiale","type":"regular","x":791,"y":207.8333282470703,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":1}},{"type":"Attribute","details":{"name":"codice","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":688,"y":135.8333282470703,"id":2}},{"type":"Attribute","details":{"name":"nome","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":784,"y":109.83332824707031,"id":4}},{"type":"Attribute","details":{"name":"citta","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":878,"y":132.8333282470703,"id":6}},{"type":"Attribute","details":{"name":"patrimonio","isDerived":true,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":913,"y":182.8333282470703,"id":8}},{"type":"Entity","details":{"name":"Conto","type":"regular","x":401,"y":204.8333282470703,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":10}},{"type":"Attribute","details":{"name":"numero","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":366,"y":147.8333282470703,"id":11}},{"type":"Attribute","details":{"name":"saldo","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":473,"y":149.8333282470703,"id":13}},{"type":"Relationship","details":{"name":"gestione","isIdentifying":false,"x":586,"y":206.8333282470703,"slots":[{"slotIndex":0,"minimum":"0","maximum":"N","participation":"optional","cardinality":"many","role":"","entityId":1},{"slotIndex":1,"minimum":"1","maximum":"1","participation":"mandatory","cardinality":"one","role":"","entityId":10}],"id":15}},{"type":"Entity","details":{"name":"Cliente","type":"regular","x":432,"y":463.8333282470703,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":22}},{"type":"Attribute","details":{"name":"codiceFiscale","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":308,"y":403.8333282470703,"id":23}},{"type":"Attribute","details":{"name":"nominativo","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":true,"isUnique":false,"x":537,"y":528.8333282470703,"id":25}},{"type":"Attribute","details":{"name":"indirizzo","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":429,"y":528.8333282470703,"id":27}},{"type":"Attribute","details":{"name":"citta","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":336,"y":511.8333282470703,"id":29}},{"type":"Attribute","details":{"name":"telefono","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":301,"y":461.8333282470703,"id":31}},{"type":"Relationship","details":{"name":"intestazione","isIdentifying":false,"x":403,"y":300.8333282470703,"slots":[{"slotIndex":0,"minimum":"1","maximum":"N","participation":"mandatory","cardinality":"many","role":"","entityId":10},{"slotIndex":1,"minimum":"0","maximum":"N","participation":"optional","cardinality":"many","role":"","entityId":22}],"id":33}},{"type":"Entity","details":{"name":"Prestito","type":"regular","x":823,"y":468.8333282470703,"isDisjointed":true,"isTotalSpecialization":true,"isSubtype":false,"supertypeEntityId":null,"id":36}},{"type":"Attribute","details":{"name":"codice","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":702,"y":391.8333282470703,"id":37}},{"type":"Attribute","details":{"name":"importo","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":895,"y":420.8333282470703,"id":39}},{"type":"Attribute","details":{"name":"ufficio","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":923,"y":468.8333282470703,"id":41}},{"type":"Attribute","details":{"name":"impiegato","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":896,"y":516.8333282470703,"id":43}},{"type":"Attribute","details":{"name":"apertura","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":823,"y":552.8333282470703,"id":45}},{"type":"Attribute","details":{"name":"estinzione","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":749,"y":518.8333282470703,"id":47}},{"type":"Relationship","details":{"name":"concessione","isIdentifying":false,"x":822,"y":316.8333282470703,"slots":[{"slotIndex":0,"minimum":"0","maximum":"N","participation":"optional","cardinality":"many","role":"","entityId":1},{"slotIndex":1,"minimum":"1","maximum":"1","participation":"mandatory","cardinality":"one","role":"","entityId":36}],"id":49}},{"type":"Relationship","details":{"name":"sottoscrizione","isIdentifying":false,"x":628,"y":465.8333282470703,"slots":[{"slotIndex":0,"minimum":"0","maximum":"N","participation":"optional","cardinality":"many","role":"","entityId":22},{"slotIndex":1,"minimum":"1","maximum":"N","participation":"mandatory","cardinality":"many","role":"","entityId":36}],"id":52}},{"type":"Label","details":{"text":"Legenda: Si noti che  la notazione delle cardinalità è diversa da Atzeni.","x":27,"y":58.83332824707031,"width":535,"height":50,"id":55}},{"type":"Label","details":{"text":"BR 1: Filiale.patrimonio = somma di Conto.saldo per tutti i Conti gestiti dalla filiale - somma di Prestito.importo per tutti i Prestiti concessi dalla filiale e non ancora estinti","x":939,"y":44.83332824707031,"width":379,"height":50,"id":75}},{"type":"Relationship","details":{"name":"riferimento","isIdentifying":false,"x":597.5666656494141,"y":328.96665954589844,"slots":[{"slotIndex":0,"minimum":"1","maximum":"1","participation":"mandatory","cardinality":"one","role":"","entityId":22},{"slotIndex":1,"minimum":"0","maximum":"N","participation":"optional","cardinality":"many","role":"","entityId":1}],"id":94}},{"type":"Attribute","details":{"name":"nome","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":466,"y":577.8333282470703,"id":112}},{"type":"Attribute","details":{"name":"cognome","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":519,"y":621.8333282470703,"id":114}},{"type":"Attribute","details":{"name":"dataNascita","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":579,"y":579.8333282470703,"id":116}},{"type":"Attribute","details":{"name":"luogoNascita","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":625,"y":623.8333282470703,"id":118}},{"type":"Label","details":{"text":"BR 2: riferimento è l'associazione che rappresenta un eventuale legame diretto tra cliente e filiale (nel testo non è presente), ad esempio la filiale che inserisce il cliente in anagrafica...","x":998,"y":102.66667175292969,"width":338,"height":63,"id":140}},{"type":"Label","details":{"text":"Esercizio 27 pag A76","x":121,"y":2.6666717529296875,"width":504,"height":50,"id":162}}],"connectors":[{"type":"Connector","details":{"id":141},"source":2,"destination":1},{"type":"Connector","details":{"id":142},"source":4,"destination":1},{"type":"Connector","details":{"id":143},"source":6,"destination":1},{"type":"Connector","details":{"id":144},"source":8,"destination":1},{"type":"Connector","details":{"id":145},"source":11,"destination":10},{"type":"Connector","details":{"id":146},"source":13,"destination":10},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":20},"source":1,"destination":15},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":21},"source":10,"destination":15},{"type":"Connector","details":{"id":147},"source":23,"destination":22},{"type":"Connector","details":{"id":148},"source":25,"destination":22},{"type":"Connector","details":{"id":149},"source":27,"destination":22},{"type":"Connector","details":{"id":150},"source":29,"destination":22},{"type":"Connector","details":{"id":151},"source":31,"destination":22},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":34},"source":10,"destination":33},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":35},"source":22,"destination":33},{"type":"Connector","details":{"id":152},"source":37,"destination":36},{"type":"Connector","details":{"id":153},"source":39,"destination":36},{"type":"Connector","details":{"id":154},"source":41,"destination":36},{"type":"Connector","details":{"id":155},"source":43,"destination":36},{"type":"Connector","details":{"id":156},"source":45,"destination":36},{"type":"Connector","details":{"id":157},"source":47,"destination":36},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":50},"source":1,"destination":49},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":51},"source":36,"destination":49},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":53},"source":22,"destination":52},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":54},"source":36,"destination":52},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":95},"source":22,"destination":94},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":96},"source":1,"destination":94},{"type":"Connector","details":{"id":158},"source":112,"destination":25},{"type":"Connector","details":{"id":159},"source":114,"destination":25},{"type":"Connector","details":{"id":160},"source":116,"destination":25},{"type":"Connector","details":{"id":161},"source":118,"destination":25}],"width":2000,"height":1000}