Definire uno schema Entità-Relazione che descriva i dati di un’applicazione relativa all’archivio di un amministratore di condomini, secondo le seguenti specifiche (semplificate rispetto a molte realtà)
Entità | Descrizione | Attributi | Identificatore |
---|---|---|---|
Condominio | insieme di scale/appartamenti | Nome, Indirizzo, Spesa Condominio | Nome |
Scala | insieme di appartamenti | Codice Scala, (Condominio), Spesa Scala, Quota scala | Codice Scala, Condominio |
Appartamento | abitazione | Interno, (Scala), (Condominio), Quota Appartamento, Spesa Appartamento, Saldo Prec, Saldo Corr | Interno, Scala |
Proprietario | persona a cui appartiene un appartamento | Nome, Cognome, CF, Indirizzo Corrispondenza | CF |
Spesa | spesa totale sostenuta dal condominio | Codice Spesa, Totale | Codice Spesa |
Pagamento | pagamento effettuato da un proprietario per un appartamento | Codice Pagamento, Importo | Codice Pagamento |
Relazioni | Descrizione | Componenti |
---|---|---|
Composizione | scale che compongono un appartamento | Condominio, Scala |
Collocazione | collocazione di un appartamento in una scala | Scala, Appartamento |
Possesso | un proprietario possiede un appartamento | Appartamento, Proprietario |
Versamento | un proprietario versa un pagamento | Proprietario, Pagamento |
Saldo | un pagamento salda le spese | Pagamento, Spesa |
Addebito | i costi vengono addebitati alla spesa | Appartamento, Spesa |
https://viewer.diagrams.net/?border=0&tags={}&highlight=0000ff&edit=_blank&layers=1&nav=1&title=condominio.drawio&open=R7V1bb6NIFv41kWYfElFAcXlM0pue1m5aWXVrZudpRQyx0WCXg3Hn8uu3sCliTpXjCqEuDolaahtM2ZxzvnPn1Il3OX%2F8WibL2TVJs%2BLEddLHE%2B%2FLiesix3VP6n9O%2BrQ9gr14e2Ba5mnzoZcDP%2FLnjF3ZHF3nabbqfLAipKjyZffghCwW2aTqHEvKkjx0P3ZHiu63LpNpxh34MUkK%2FuifeVrNmqMoiF9O%2FJ7l01nz1ZEbbk%2FME%2Fbh5k5WsyQlDzuHvH%2BeeJclIdX21fzxMitq4jG6bK%2B72nO2%2FWFltqhkLkjjv28XiR8U04c%2FyXU4W2V3X0%2BbVX4lxbq54RM3KOh6F3eELkt%2FdfXUkCK4XxN24nS1YdQ5%2FQDyl5TZFy%2Fn6atp8%2F9moVt2oKZqwo7S33kLP0mPbb%2BVHXY7P8AtyXqRZvXtOPT0wyyvsh%2FLZFKffaDSR4%2FNqnlB36H26l3ysHvNyip73DnUkOtrRuZZVT7RjzRnI%2F8MNeLbSG%2FU8PJhRxQYf2c7UhA0x5JG%2Bqbt2i8Moi8aHr2BX65Gfl2SRUrm%2BSInx8W0Dsd84yzzNLLsfElpVyVzSr6jYhp2u1wzzjSfY9olmS8J5UlOFhlPrxmZ365Xh2lVU70xcsgfhnZhl3RC2vkC2kWqaIcFtCsKMknso50bOx3ihaZpFwiUBaBXtkjPa8eGvlvU9OzQqAtcSLHsMa%2F%2BW587w827v5pP1q%2B%2FPO6%2BeWJvFvS%2Bdi6q3%2F7VfNvmzctlm3fsur3cWZF1OckO27gqKadZdRijWdrx4Hhel1mRVPmvrkMn4lxz6Q3JN3q5kZFThM%2BiMN75w13AMY%2BWLbm9wWaVXYcMLBxy7gVd6swHP3BLBm61jXS1N9lf4EJO4BAncWVG9V5yu3nrdOUtKfLpgr4ut9i4qKGXUz%2FvvDl%2BS6qKzKXA%2BxoeGu%2B%2B%2BQ0nrU8tj%2FTmrt4tC6jLMKAHyN3dKlPCp8iAYkCvKob%2BAGdxnCUAh84HQoCrsoAO9pliTViOORn5bhOWI0uxrB68TKAUoxftGvUWyYfM%2Bq5R37Hxg5t1WdRjPaiHYG39vLei3kNdH1Iz6BGfwrHKgjPq6If9uxxx5pmpNrh9IIt0QdazC7K%2B10Uacnp63j4GC4WaMcvnhKyy1Ez4bTHV0CFTaKn55MUNWa2y1YrwDDKZ9PEsS1wgPkA5T9PsNq%2FsIhxGIHo3ni5DvNs%2BqKXp6ej1cSrVWxqkydQgBwSFbl%2F3MPbAQpscj%2FPyF2k1PS4fithlemJLTI96W%2BPynrsS4L%2FRXezjmvYHvmsb8mPoZOKewEcIgVIkcjrI15voZcJla5wIGjlG5HO6OivENyVZlnlGhe24yvpxIM6ymOvE4EvEPLGT6Wu1%2BPeQVIFrDElsvnXC5cuhf2TlitHUorAiBhkF82GFy1f2lHgXbywL9ylBv8O7CCS9C6aDlXsXTtcn8GDmSTqs8DnnQq87oStq7YqX00u8VBUy5cVLUykz9N2uVPR1XgM%2Fen0hxeLl8bHRj6RI7VL6MAnnG8%2FCebyTrwaVNueSXCyJSiZkypNJUdyRExzwbT7S1Ub%2F8FqqscnHK9c8Lg9HkkV2pyKQZBh4fyB5OkwkGQTdK9RFkr5io9zDuPY15P3hL51QivSgH4M0EKf9j6W9CCvOVx6FdDGpOezyacpXDiZeIQhN%2FFhzRMGXXvlHiJbZas8jRJYlU2BToflkCpZJCBRFvlxlhymWrJbbp%2B3u8seayhwJ7%2FKiuCQFKTcLe9uM9zCkdaGg%2BjxpRZSFzbrDUVZXc26oJWciqeCYPB1UcDtswQK2sGPvdbLDPYB7c90GLgQrv4r1YKDWzK7oz6%2FAxf2FJXDtEgIUDyMEEYjsNac%2FGFmN6Oqrzd9AKRLLVHUgqrUNB669FDuoTT%2BBpAZIvFP5nS7K8ZyKcyXOUkwoK7NSkKeY52laX34BUx3L%2BmY2t4cvTvCXeq11RVaNmGxUcEn%2BzhjiGhnbBSE7NLxbiuDj0YgHZCAQK08ZIPkS37dFWubPz3yudyxMAik%2BEY9CrTwyGTkMaY1g5IAD0%2BbISOSgrBwma%2Bvsihxc3G0JDiCQZG2di4LuQo5mY8enfzsJk9tSNNpjpEoWBUAXiIp3zitSN7gyYD%2Fg6NWsDwDlsyjAlJoNNWWuO%2BVN13h9kwmUJXrWd7qxAO4bU3gsRcIW0hxUhHx0%2FpNU9ciwsSpT3wOI93nEaw0rQpk4%2FxiS3VCXYs%2Bwy8p0uVZdGprXpbINgnp0aQj6TTEsG0lX%2FcBEEwwhqVqXiqZFpTllmus0zutYdSqYK9BauV0HFWlVqjLTqY7BQYXd2q35MqZUFTdrt3kAV0sF0ZdVqoFVSjWKgK2F8bt00tvvJgJ8zfMFQpm00jF4P8gJbUOqrhY7PbV%2BaaTKNsvpQWoMQ8m%2BKbswAkjV3FPHvk7k%2Fuw8PTZSFwg5LoC%2Fw8Nf2GGvzAeK%2BFTSt%2FmSlCPmUuzig0zSWq%2BK%2BPyMPvM3bL3KBZQ1a%2Fwitd0Twxq%2FgzaNiYklNg2FXWb3718TC40uiyaTHzoG3xPUh5DpWnEk6o9WHiMqngFrC%2FZQOAj2QLSie65cxCdo%2FrMmVUIPNZtvjNRFgcVeQUeNsNarzkWRCCMn6%2FLXBq7bZ%2BpbZE%2BKZLXKJ28B914SWoI%2FMHmi9wRmFPcDICVt8rTzsUaW9%2F7ePfMjXyRiu%2BCg4I5litjHYFgR1JKmLWvMxwsvNYhx681uJyISPcSktQTRaumjj%2B343R9MR3fIkdEwJprjW65bYq4QivftDPb2%2Fni4kuZmFsRyDHzX4MiVn8ch1LjbiBxNQeBu%2BsW6seTSVQtdAz58sCWQ1%2FsRf3xgIeXKgI8g9YyHlbe0rwPDmvGR4AqVm4vwzQM8z8aitDHGZwBDmC9HeFqVttSstKOI3JwwPIvAZDDTXqsnExHYUpQYcB4ykypbfGLHDzv75A2TUd0uKxY5bbt1mMy8KO17M45dPvZQg10PhR2X1qFRz6tOLX1zk5U5vc%2FaNmoDtbTHqqnPJvbPdne%2BHAbTMe423eiOeAUD7Eb9UDg38l7wKJzWpzeQxxeRL69Gyx8alXE2UJCK0NoH1XZdfTijiATxgl6r6Mv4G0bysIzplpgn1G6iwXjXd5eeiA9sXM1PbyM2u%2FnoESXUV%2BZRZaR5TdmsBWmXkomVJZiN3Ndcyt7bbMFGbm7%2FFuXoFbgsZLoYs19JY%2FfDjmWk12vh6yf5Is2beUPOJSnLfLUkFOeL5%2FFWviLoEgnqXpr5xtclEMcePbtXNd87QKHBAU94elGdmHAcb1cxKqClTL3gCGl5RtVN%2FXdgHvJwhMQmHbZBhwyAKX0CNa3XV8OafLVOTlDZwBb5LQ7tctXgDOsQrCA9ryXs%2BmbIBTsiqPbNsMlnEgadrASAikxPA2nDuo8xDkQeqbIbOmlCKthkGAV9ocqFUbqh%2BlFmTQahbTZVz6xJZJtNtWvYZAAG8OKeQMUesKmObqCabGpRCVTzNpXV2rQi1QKbaldDSwg21kF93V8cAJuq2%2F39MLsJYLCdgGAilmak6qop6Gg9kwaqZXsVBHCqd0%2Bc%2BtiwSQ34MLXZ9NS5KbMJJ1ljSUcHHuzo5WAfC8RLXTZasKsEY1RdQfhkVFv05RW0Zk7x4WTzRDwciX6%2BpLdejXzgEmZNxYce8FQ2BB0JtkT4VpN4MV6u%2BD4csMQxSet8JSSYVL9no4FPVJ3w07HbKrQ5lAlGmHPsUdFiZonLiMH8QARDBOnYDgyog2OYVbuMH2bOOYbTjk2HdoI557%2FRW7j8%2Fo%2FR6jEE2nlET9aJQKvQEPGO%2BIZJ6JNJbbZJgCTNTOJ7d8aOpL0Dj8wxiQ%2BUxo4kOIDfAibxsdHYmRQ62DYm8YWxsas7rp%2FUOJMEc7d%2Fc8bNJOSgLpTMew6CQc5j13ccl8w74YKp0GPHUhzCSMk0jwTR7Mh5hEEnjgXq7jOa5Zlknbb7jGa5sh%2BYuovNu3eCaHbk6g764DqZ9K%2Fpzf%2Bu0M3ktrz7fXF%2FHxbr6vpUlLnelo%2Fqu%2B8wKbhfE3bidEvOc%2FoB5C8fN8Rh51nVCbGV6A%2FbLrY9fhzMH0JtYujK65uBdpXd%2F9uf%2B2scf3%2Be%2FixnP88fIzbuH%2BLxWCzbEEoStugL2kwHwh99W5IaEO25r2WynF2TNKs%2F8X8%3D