{"id":5501,"date":"2023-02-24T10:43:38","date_gmt":"2023-02-24T09:43:38","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=5501"},"modified":"2026-04-13T11:51:03","modified_gmt":"2026-04-13T09:51:03","slug":"basi-di-dati-ing-informatica","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2023\/basi-di-dati-ing-informatica\/","title":{"rendered":"Basi di dati (Ing. Informatica)"},"content":{"rendered":"\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"informazioni-generali\">Informazioni generali<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-fee07c\">\n<li class=\" eplus-wrapper\">CODICI INSEGNAMENTO: 14AFQMQ, 14AFQOA <\/li>\n\n\n\n<li class=\" eplus-wrapper\">SSD: ING-INF\/05<\/li>\n\n\n\n<li class=\" eplus-wrapper\">CFU: 8<\/li>\n<\/ul>\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>CORSO<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>GRUPPO<\/strong><\/td><td><strong>DOCENTE<\/strong><\/td><td><strong>ESERCITATORE<\/strong> <\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">1<\/td><td class=\"has-text-align-center\" data-align=\"center\">AA-DZ<\/td><td><a href=\"https:\/\/www.polito.it\/en\/staff?p=silvia.chiusano\">Prof. Silvia Chiusano<\/a> <\/td><td>Dr. Massimiliano Frass\u00e0, Dr. Marco De Luca<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">2<\/td><td class=\"has-text-align-center\" data-align=\"center\">EA-MZ<\/td><td><a href=\"https:\/\/smartdata.polito.it\/members\/danilo-giordano\/\" data-type=\"link\" data-id=\"https:\/\/smartdata.polito.it\/members\/danilo-giordano\/\">Prof. Danilo Giordano<\/a><\/td><td>Dr. Matteo Boffa<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">3<\/td><td class=\"has-text-align-center\" data-align=\"center\">NA-ZZ<\/td><td><a href=\"https:\/\/flowygo.com\" target=\"_blank\" rel=\"noreferrer noopener\">Prof. Alessandro Fiori<\/a><\/td><td>Dr. Massimiliano Frass\u00e0&#8217;,  Dr. Marco De Luca<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\" wp-block-heading eplus-wrapper\" id=\"tinyTOC\">Contenuto della pagina<\/h3>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-7b7f4c\">\n<li class=\" eplus-wrapper\"><a href=\"#Argomenti-del-corso-1\">Argomenti del corso<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"#Esercizi-aula\" data-type=\"URL\">Esercitazioni in aula<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"#Calendario\">Calendario esercitazioni in Laboratorio<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"#Laboratori\">Laboratorio<\/a><\/li>\n<\/ul>\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"avvisi\">Avvisi <\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f59765\">\n<li class=\" eplus-wrapper\"><strong>Per avvisi fare riferimento al portale della didattica<\/strong><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Per le regole d&#8217;esame d&#8217;esame fare riferimento alla <a href=\"https:\/\/didattica.polito.it\/pls\/portal30\/gap.pkg_guide.viewGap?p_cod_ins=14AFQOA&amp;p_a_acc=2025&amp;p_header=S&amp;p_lang=IT&amp;multi=N\">scheda del corso<\/a>.<\/strong><\/li>\n<\/ul>\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\">Argomenti del corso<\/h2>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__2908fee2-9728-4858-bb90-8ab6c19434da\" class=\"ep_label_main\"><span class=\"ep_label\">Introduzione corso<\/span><\/a><a href=\"#ep_tab_wrapper__2f076bb0-9ccd-40f9-9f6e-026b178f53ec\" class=\"ep_label_main\"><span class=\"ep_label\">Introduzione basi dati<\/span><\/a><a href=\"#ep_tab_wrapper__72290809-98cc-4e98-b4f2-f02244907920\" class=\"ep_label_main\"><span class=\"ep_label\">Modello relazionale<\/span><\/a><a href=\"#ep_tab_wrapper__9c1eeced-21e2-4b54-b1d3-90f4dbbdcc7f\" class=\"ep_label_main\"><span class=\"ep_label\">Progettazione di basi di dati<\/span><\/a><a href=\"#ep_tab_wrapper__f4c9909d-ec49-4d40-9f70-1585e736b1ad\" class=\"ep_label_main\"><span class=\"ep_label\">Algebra relazionale<\/span><\/a><a href=\"#ep_tab_wrapper__b556843f-b57e-4334-b858-fa6cc7bc6d4e\" class=\"ep_label_main\"><span class=\"ep_label\">Linguaggio SQL<\/span><\/a><a href=\"#ep_tab_wrapper__53986017-3fbd-4104-b9e8-5054a43664c6\" class=\"ep_label_main\"><span class=\"ep_label\">Trigger<\/span><\/a><a href=\"#ep_tab_wrapper__0d7d11c8-ae5d-4c1a-820f-2436852baff1\" class=\"ep_label_main\"><span class=\"ep_label\">Applicazioni web<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__2908fee2-9728-4858-bb90-8ab6c19434da\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2908fee2-9728-4858-bb90-8ab6c19434da undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-191348\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/BD-Intro.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Introduzione al corso<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__2f076bb0-9ccd-40f9-9f6e-026b178f53ec\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2f076bb0-9ccd-40f9-9f6e-026b178f53ec undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-e0795f\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/Introduzione_alle_basi_dati.pdf\" data-type=\"URL\">Introduzione alle basi di dati<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__72290809-98cc-4e98-b4f2-f02244907920\" class=\"ep_tab_item_wrapper ep_tab_wrapper__72290809-98cc-4e98-b4f2-f02244907920 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-383445\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/Modello-relazionale-1.pdf\">Modello relazionale<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__9c1eeced-21e2-4b54-b1d3-90f4dbbdcc7f\" class=\"ep_tab_item_wrapper ep_tab_wrapper__9c1eeced-21e2-4b54-b1d3-90f4dbbdcc7f undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-58f80a\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/Progettazione_ER-1.pdf\">Modello Entit\u00e0-Relazione<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Progettazione_ER_gestione_tempo.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Gestione del tempo<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Progettazione_ER_ristrutturazione.pdf\">Ristrutturazione<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Progettazione_modello_logico.pdf\">Progettazione Logica<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Esempio_progettazione-concettuale.pdf\">Esempio progettazione concettuale<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Esempio_progettazione_logica.pdf\">Esempio progettazione logica<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Normalizzazione-1.pdf\">Normalizzazione<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__f4c9909d-ec49-4d40-9f70-1585e736b1ad\" class=\"ep_tab_item_wrapper ep_tab_wrapper__f4c9909d-ec49-4d40-9f70-1585e736b1ad undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-b23b50\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Algebra_Relazionale.pdf\">Algebra relazionale<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__b556843f-b57e-4334-b858-fa6cc7bc6d4e\" class=\"ep_tab_item_wrapper ep_tab_wrapper__b556843f-b57e-4334-b858-fa6cc7bc6d4e undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-676646\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/1-SQL_fondamenti.pdf\">SQL: fondamenti<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/2-SQL_query_nidificate-2.pdf\">SQL: interrogazioni nidificate<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/3-SQL_operatori_insiemistici.pdf\">SQL: operatori insiemistici<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/4-SQL_query_avanzate.pdf\">SQL: query avanzate<\/a> <\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/5-SQL_manipolazione_dati.pdf\">SQL: manipolazione dei dati<\/a> (Insert, Delete, Update) <\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/6-SQL_gestione_tabelle.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">SQL: gestione delle tabelle<\/a> <\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/SQL_costrutti_avanzati.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">SQL: costrutti avanzati<\/a> (Viste, Transazioni, Controllo dell&#8217;accesso, Indici, Progettazione fisica)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__53986017-3fbd-4104-b9e8-5054a43664c6\" class=\"ep_tab_item_wrapper ep_tab_wrapper__53986017-3fbd-4104-b9e8-5054a43664c6 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-44e261\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/Trigger-ita.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Trigger<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__0d7d11c8-ae5d-4c1a-820f-2436852baff1\" class=\"ep_tab_item_wrapper ep_tab_wrapper__0d7d11c8-ae5d-4c1a-820f-2436852baff1 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-b288e7\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/applicazioni_web.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Applicazioni web<\/a> <\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/streamlit.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Streamlit<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/live_coding.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Live coding<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/github.com\/AndreaAvignone\/streamlitTutorial\/\" target=\"_blank\" rel=\"noreferrer noopener\">Repository live coding<\/a><\/li>\n<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__a14f1744-451e-4211-8b7b-67f7a8997c6d .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n<div class=\"wp-block-columns eplus-wrapper is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex eplus-styles-uid-5c0ff4\">\n<div class=\"wp-block-column eplus-wrapper is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n<\/div>\n<\/div>\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\">Esercizi proposti<\/h2>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__63bf9b52-c9bf-4329-9975-1cc2d15a7b89\" class=\"ep_label_main\"><span class=\"ep_label\">Modello relazionale<\/span><\/a><a href=\"#ep_tab_wrapper__80887203-04e1-41cc-b35b-10c425f8332d\" class=\"ep_label_main\"><span class=\"ep_label\">Progettazione di basi di dati<\/span><\/a><a href=\"#ep_tab_wrapper__fe9ed622-382a-4e29-9315-643955155c8b\" class=\"ep_label_main\"><span class=\"ep_label\">Algebra relazionale<\/span><\/a><a href=\"#ep_tab_wrapper__4442a36d-89e3-4c4f-828e-66c94abd3d6d\" class=\"ep_label_main\"><span class=\"ep_label\">Linguaggio SQL<\/span><\/a><a href=\"#ep_tab_wrapper__18881607-bdbc-4417-ba08-78dea616d2b4\" class=\"ep_label_main\"><span class=\"ep_label\">Trigger<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__63bf9b52-c9bf-4329-9975-1cc2d15a7b89\" class=\"ep_tab_item_wrapper ep_tab_wrapper__63bf9b52-c9bf-4329-9975-1cc2d15a7b89 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-bbfc15\">\n<li class=\" eplus-wrapper\">Esercizi di modello relazionale <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/02\/esercizi_schema_logico_modello_relazionale.pdf\">(testo<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/esercizi_schema_logico_modello_relazionale-_soluzione.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">soluzione<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__80887203-04e1-41cc-b35b-10c425f8332d\" class=\"ep_tab_item_wrapper ep_tab_wrapper__80887203-04e1-41cc-b35b-10c425f8332d undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f48761\">\n<li class=\" eplus-wrapper\">Esercizi progettazione concettuale (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_modello_concettuale.pdf\" data-type=\"URL\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_modello_concettuale.pdf\">testo<\/a> , <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_modello_concettuale_sol.pdf\">soluzione<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Raccolta esercizi progettazione concettuale e logica (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/raccolta_esercizi_progettazione_BD.pdf\">testo<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/raccolta_esercizi_progettazione_BD_sol.pdf\">soluzione<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__fe9ed622-382a-4e29-9315-643955155c8b\" class=\"ep_tab_item_wrapper ep_tab_wrapper__fe9ed622-382a-4e29-9315-643955155c8b undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-8c5e23\">\n<li class=\" eplus-wrapper\">Esercizio Forniture di prodotti (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Esercizi_forniture_testo.pdf\">testo<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Esercizi_forniture_testo_sol.pdf\">soluzione<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Esercizi Riviste (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Esercizi_Riviste_testo.pdf\">testo<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/Esercizi_Riviste_testo_sol-1.pdf\">soluzione<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Esercizi Velisti (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Esercizi_Velisti_testo.pdf\">testo<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/Esercizi_Velisti_testo_sol.pdf\">soluzione<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Esercizi Aerei (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/EserciziAlgebra_extra.pdf\">testo<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__4442a36d-89e3-4c4f-828e-66c94abd3d6d\" class=\"ep_tab_item_wrapper ep_tab_wrapper__4442a36d-89e3-4c4f-828e-66c94abd3d6d undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-13be1b\">\n<li class=\" eplus-wrapper\">Esercizi parte 1 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/EserciziSQL-parte1-1.pdf\">testo<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Esercizi parte 2 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/EserciziSQL-parte2.pdf\">testo<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Esercizi parte 3 (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/EserciziSQL-parte3.pdf\">testo<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__18881607-bdbc-4417-ba08-78dea616d2b4\" class=\"ep_tab_item_wrapper ep_tab_wrapper__18881607-bdbc-4417-ba08-78dea616d2b4 undefined\"><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_label {\n                \n                color: #1e1e1e;\nfont-size: 17px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_sub_label {\n                \n                color: #1e1e1e;\nfont-size: 15px ;\n            }\n            \n\n        \n\n         \n\n        \n        \n      .eplus_styles  .ep_label_main:hover .ep_sub_label {\n        color: #ffffff;\n      }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_label_main {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }\n            \n\n        \n\n         \n\n        \n            .eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__b6569d84-4399-4d9b-910c-7950a771d6fa .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\">Laboratori<\/h2>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>LABORATORIO<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\" colspan=\"2\"><strong>CORSO 1 (Chiusano)<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\" colspan=\"2\"><strong>CORSO 2 (Giordano)<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\" colspan=\"2\"><strong>CORSO 3 (Fiori) <\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>SQUADRA<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>A<br>(AA-CAM) <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong> B <br> (CAN-DZ) <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong> A<br> (EA-INT)<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong> B<br> (KAM-MZ)<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong> A<br> (NA-SAB) <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>B <br>(SAL-ZZ) <\/strong><\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 1 <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">23\/03<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">25\/03<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">19\/03 <br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">19\/03<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">23\/03<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">25\/03<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 2 <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">13\/04<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">15\/04<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">16\/04<br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">16\/04<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">13\/04<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">15\/04<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 3 <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">27\/04<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">29\/04<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">30\/04<br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">30\/04<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">27\/04<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">29\/04<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 4 <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">11\/05<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">13\/05<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">14\/05<br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">14\/05<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">11\/05<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">13\/05<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 5\n<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">18\/05<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">20\/05<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">21\/05<br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">21\/05<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">18\/05<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">20\/05<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 6 <\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">25\/05<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">27\/05<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">28\/05<br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">28\/05<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">25\/05<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">27\/05<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Laboratorio 7\n<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\">01\/06<br>10:00 &#8211; 11:30<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">03\/06<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">04\/06<br>16:00 &#8211; 17:30<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">04\/06<br>17:30 &#8211; 19:00<br>LAIB2B<\/td><td class=\"has-text-align-center\" data-align=\"center\">01\/06<br>08:30 &#8211; 10:00<br>LABINF<\/td><td class=\"has-text-align-center\" data-align=\"center\">03\/06<br>10:00 &#8211; 11:30<br>LABINF<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>LABORATORIO<\/strong><\/td><td><strong>TESTO ESERCITAZIONE<\/strong><\/td><td><strong>SOFTWARE UTILIZZATO<\/strong><\/td><\/tr><tr><td><strong>Progettazione di basi di dati relazionali<\/strong><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/03\/2026-03-23-Introduzione-ai-laboratori-1.pdf\" data-type=\"link\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/03\/2026-03-23-Introduzione-ai-laboratori.pdf\"><strong>Introduzione ai laboratori<\/strong><\/a><br><br><a style=\"font-weight: bold;\" href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Lab1_progettazioneBDTesto.pdf\">Testo<\/a> e <strong><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Lab1_progettazioneBDTesto_sol.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">soluzione<\/a><\/strong><\/td><td><strong>designER.<\/strong> All&#8217;indirizzo <a href=\"https:\/\/designerdb.io\/\">https:\/\/designerdb.io\/<\/a> \u00e8 disponibile:<br>(a)<strong> link a designER (versione completa).<\/strong> designER supporta: (1) progettazione concettuale (rappresentazione grafica diagramma E-R e supporto nell&#8217;utilizzo formalmente corretto dei costrutti del diagramma E-R); (2) ristrutturazione del diagramma E-R; (3) traduzione del diagramma E-R ristrutturato nello schema logico relazionale corrispondente<br>(b) <strong>video tutorial sulle funzionalit\u00e0 di designER<\/strong><br>(c) <strong>link a designER basic<\/strong>. designer ER basic supporta solo la rappresentazione grafica del diagramma E-R<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<hr class=\" wp-block-separator has-alpha-channel-opacity eplus-wrapper\"\/>\n\n\n\n\n\n\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\">Esercitazioni da consegnare (Quaderni)<\/h2>\n\n\n\n<p class=\" eplus-wrapper\">Vedi piattaforma Moodle<\/p>\n\n\n\n\n\n\n\n\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"temi-d-esame\"><span id=\"Temi-esame\"><\/span><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>Informazioni generali CORSO GRUPPO DOCENTE ESERCITATORE 1 AA-DZ Prof. Silvia Chiusano Dr. Massimiliano Frass\u00e0, Dr. Marco De Luca 2 EA-MZ Prof. Danilo Giordano Dr. Matteo Boffa 3 NA-ZZ Prof. Alessandro Fiori Dr. Massimiliano Frass\u00e0&#8217;, Dr. Marco De Luca Contenuto della pagina Avvisi Argomenti del corso Esercizi proposti Laboratori LABORATORIO CORSO &hellip;<\/p>\n","protected":false},"author":14,"featured_media":3171,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"editor_plus_copied_stylings":"{}","footnotes":""},"categories":[37],"tags":[],"class_list":["post-5501","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-courses"],"_links":{"self":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/5501","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/comments?post=5501"}],"version-history":[{"count":415,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/5501\/revisions"}],"predecessor-version":[{"id":14081,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/5501\/revisions\/14081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media\/3171"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media?parent=5501"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=5501"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=5501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}