{"id":3243,"date":"2022-02-25T11:43:32","date_gmt":"2022-02-25T10:43:32","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=3243"},"modified":"2026-05-26T13:22:30","modified_gmt":"2026-05-26T11:22:30","slug":"database-systems","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2022\/database-systems\/","title":{"rendered":"Database systems"},"content":{"rendered":"\n<h2 class=\"eplus-IC96QM wp-block-heading eplus-wrapper\">General Information<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-df8bae\">\n<li class=\" eplus-wrapper\"><strong>Professor<\/strong>: <a href=\"https:\/\/www.polito.it\/en\/staff?p=silvia.chiusano\">Silvia Chiusano<\/a><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Teaching Assistant<\/strong>: <a href=\"https:\/\/flowygo.com\" target=\"_blank\" rel=\"noreferrer noopener\">Alessandro Fiori<\/a>  , Massimiliano Frass\u00e0<\/li>\n<\/ul>\n\n\n<hr class=\"eplus-1jADdM wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h3 class=\"eplus-9VDjoi wp-block-heading eplus-wrapper\">Teaching Material<\/h3>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>SUBJECT<\/strong><\/td><td><strong>MATERIAL<\/strong><\/td><\/tr><tr><td><strong>Course introduction<\/strong><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/02\/databases_course_structure-1.pdf\">Course introduction<\/a><\/td><\/tr><tr><td><strong>Introduction to databases<\/strong><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/Introduction_to_databases.pdf\">Introduction to databases<\/a><\/td><\/tr><tr><td><strong>Relational model<\/strong><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/Relational-model.pdf\">Relational model<\/a><\/td><\/tr><tr><td><strong>Relational database design<\/strong><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/ER-diagram_v2.pdf\">Conceptual design: E-R model<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/03\/Relational-logical-design.pdf\">Logical design: Traslation of ER schema into Relational model<\/a> (updated 2026-03-13)<br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/Restructuring-ER-schema.pdf\">Restructuring ER schema<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/03\/04.-ER-model-time-representation.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Time management<\/a><\/td><\/tr><tr><td><strong>SQL Language<\/strong><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/04\/SQL-Introduction_new.pdf\">SQL Language: select, join, aggregated operators, group by<\/a> <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(updated 2026-04-01<\/strong>)<\/mark><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/SQL-Nested-queries.pdf\">SQL Language: in, not in<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/SQL-update-commands.pdf\">SQL Language: update commands<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/table_management_short.pdf\">SQL Language: table management<\/a><\/td><\/tr><tr><td><strong>Business intelligence<\/strong><\/td><td>Data warehouse introduction (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/1-DWIntroduction.pdf\">slides<\/a>)<br>Data warehouse design (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/DW-design.pdf\">slides<\/a>)<br>ETL (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/ETL.pdf\">slides<\/a>)<br>OLAP (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/OLAP.pdf\">slides<\/a>)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n\n\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h3 class=\" eplus-sV2p9E wp-block-heading eplus-wrapper\">Exercises<\/h3>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__d6bd6aeb-7d3b-452d-baff-17ce25e0d109\" class=\"ep_label_main\"><span class=\"ep_label\">Relational model<\/span><\/a><a href=\"#ep_tab_wrapper__28b4c2d8-412b-46f5-a5a9-c322bb5bd5a8\" class=\"ep_label_main\"><span class=\"ep_label\">Design of relational database<strong>s<\/strong><\/span><\/a><a href=\"#ep_tab_wrapper__2a33d8aa-6afe-494f-9339-c78039a5b55d\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language<\/span><\/a><a href=\"#ep_tab_wrapper__7945b9a2-f23e-43c8-b2a6-64c8bbc841b6\" class=\"ep_label_main\"><span class=\"ep_label\">Data warehouse design<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__d6bd6aeb-7d3b-452d-baff-17ce25e0d109\" class=\"ep_tab_item_wrapper ep_tab_wrapper__d6bd6aeb-7d3b-452d-baff-17ce25e0d109 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-c9c452\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/relationalmodel_exercises-1.pdf\">Exercises on relational model<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__28b4c2d8-412b-46f5-a5a9-c322bb5bd5a8\" class=\"ep_tab_item_wrapper ep_tab_wrapper__28b4c2d8-412b-46f5-a5a9-c322bb5bd5a8 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-acbbac\">\n<li class=\" eplus-wrapper\">Exercises con conceptual database design using ER model (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_conceptual_model-text.pdf\">exercise text<\/a> , <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_conceptual_model-text.pdf\"> <\/a><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_translation_to_logical_model.pdf\" data-type=\"attachment\" data-id=\"6074\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">AirQ company, Research organization, Forniture store (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/database_design_exercises-text.pdf\">exercise text<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Beauty farm (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/04\/DB-design-beauty-farm.pdf\">exercise text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/DB-design-beauty-farm_text_sol.pdf\">draft solution<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">STEP Programme (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/DB-design-STEP-Programme.pdf\">exercise text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/DB-design-STEP-Programme-ER.pdf\">draft solution ER diagram<\/a>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__2a33d8aa-6afe-494f-9339-c78039a5b55d\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2a33d8aa-6afe-494f-9339-c78039a5b55d undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-0972c3\">\n<li class=\" eplus-wrapper\">Exercises: JOIN (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/04\/SQL-Ex-Join-text-1.pdf\">text<\/a>,  <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/SQL-Ex-Join-text_sol.pdf\">draft sol<\/a><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/01-SQL-Ex-Join-sol.pdf\">ution<\/a>) <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(draft solution now available<\/strong>)<\/mark><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercises: select, join, group by, having (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/02-SQL-Ex-GB.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/SQL-Ex-GB_text_sol.pdf\">draft solution<\/a>)  <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(draft solution now available<\/strong>)<\/mark><\/li>\n\n\n\n<li class=\" eplus-wrapper\">Exercises: in, not in (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/SQL-Ex-IN-NOTIN_text.pdf\">text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/SQL-Ex-IN-NOTIN_text_sol.pdf\">draft solution<\/a>) <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(draft solution now available<\/strong>)<\/mark><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__7945b9a2-f23e-43c8-b2a6-64c8bbc841b6\" class=\"ep_tab_item_wrapper ep_tab_wrapper__7945b9a2-f23e-43c8-b2a6-64c8bbc841b6 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-0e5d1a\">\n<li class=\" eplus-wrapper\">Italian household appliance company (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/DW-project-Italian_household.pdf\">exercise text<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Property rent adverts (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/05\/DW-project-SearchingYourHouse.pdf\">exercise text<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Italian wines (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/06\/DW-project-wine.pdf\">exercise text<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Sensors (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/05\/DW-project-sensors.pdf\">exercise text<\/a>)<\/li>\n<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .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__1ff2d041-f570-41af-b431-cc4b05166a42 .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__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .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__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__1ff2d041-f570-41af-b431-cc4b05166a42 .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n\n\n<div class=\"wp-block-group eplus-wrapper\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n\n\n\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-df2a67\">\n<li class=\" eplus-wrapper\">\n<\/ul>\n\n<\/div><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h3 class=\"eplus-nQUY5I wp-block-heading eplus-wrapper\">Laboratory Material<\/h3>\n\n\n\n<div class=\"wp-block-ep-tabs ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__7670975b-f42b-4561-8ef0-3d6d717dd0dc\" class=\"ep_label_main\"><span class=\"ep_label\">Database design<\/span><\/a><a href=\"#ep_tab_wrapper__c4c6b446-eb9b-4aa5-838e-5ab6f17884bd\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language (join, group by)<\/span><\/a><a href=\"#ep_tab_wrapper__bc2f2ac5-d7b6-4c3c-8598-a8f28823ec9a\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language (join, group by, in, not in)<\/span><\/a><a href=\"#ep_tab_wrapper__2da2b0bd-67b9-46da-a36f-0e0d04a1206c\" class=\"ep_label_main\"><span class=\"ep_label\">Google Looker Studio<\/span><\/a><\/div><div class=\"ep_tabs_wrapper undefined\">\n<div id=\"ep_tab_wrapper__7670975b-f42b-4561-8ef0-3d6d717dd0dc\" class=\"ep_tab_item_wrapper ep_tab_wrapper__7670975b-f42b-4561-8ef0-3d6d717dd0dc undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-96dea1\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/Lab1_DBdesign.pdf\">Exercise text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/Lab1_DBdesign_sol_v1.pdf\">Draft solution<\/a> <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(draft solution now available<\/strong>)<\/mark><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__c4c6b446-eb9b-4aa5-838e-5ab6f17884bd\" class=\"ep_tab_item_wrapper ep_tab_wrapper__c4c6b446-eb9b-4aa5-838e-5ab6f17884bd undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-4842ad\">\n<li class=\" eplus-wrapper\"><strong>Software : ORACLE APEX.<\/strong>\u00a0Oracle Apex (online version) available at\u00a0<a href=\"https:\/\/apex.oracle.com\/it\/\">https:\/\/apex.oracle.com\/<\/a> Using Oracle APEX online (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/03\/1_guida_apex_ENG.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">guide<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/SQL_oracle.pdf\">Exercise text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/SQL_oracle_output.pdf\">Query output<\/a>,  <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/SQL_oracle_sol.pdf\">Query solution<\/a> <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(draft solution now available<\/strong>)<\/mark><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/db_deliveries.zip\">Scripts for database creation<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__bc2f2ac5-d7b6-4c3c-8598-a8f28823ec9a\" class=\"ep_tab_item_wrapper ep_tab_wrapper__bc2f2ac5-d7b6-4c3c-8598-a8f28823ec9a undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-accb17\">\n<li class=\" eplus-wrapper\"><strong>Software : ORACLE APEX.<\/strong>\u00a0Oracle Apex (online version) available at\u00a0<a href=\"https:\/\/apex.oracle.com\/it\/\">https:\/\/apex.oracle.com\/<\/a> Using Oracle APEX online (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/03\/1_guida_apex_ENG.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">guide<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/Lab-SQL-3_new.pdf\">Exercise text<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/Lab-SQL-3_new_output.pdf\">Query output<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/Lab-SQL-3_new_sol.pdf\">Query solution<\/a> <mark style=\"background-color:#fef202\" class=\"has-inline-color\"><strong>(draft solution now available<\/strong>)<\/mark><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/db_deliveries.zip\">Scripts for database creation<\/a><\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__2da2b0bd-67b9-46da-a36f-0e0d04a1206c\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2da2b0bd-67b9-46da-a36f-0e0d04a1206c undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-1e46f2\">\n<li class=\" eplus-wrapper\">Practice #1: Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/Looker_Studio___lab1.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Practice #2: Text (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/Looker_Studio___lab2.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">pdf<\/a>, Video tutorials available on <a href=\"https:\/\/www.youtube.com\/channel\/UCeLc6xHRXd-9kP6Ilqx6usg\" target=\"_blank\" rel=\"noreferrer noopener\">youtube channel<\/a>)<\/li>\n<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .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__70617192-1670-4164-8365-b553f8c81b1c .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__70617192-1670-4164-8365-b553f8c81b1c .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .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__70617192-1670-4164-8365-b553f8c81b1c .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__70617192-1670-4164-8365-b553f8c81b1c .ep_tabs_header {\n                \n                justify-content: flex-start;\n            }<\/style><\/div><\/div>\n\n\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n\n\n\n\n\n\n\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<h3 class=\" wp-block-heading eplus-wrapper\">Homework<\/h3>\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><strong>General information on Homework<\/strong>. Homework delivery is optional. For each homework, students can obtain the corresponding points if the homework is delivered by the deadline. The final exam grade is defined by considering the evaluation of the written part, and, optionally, of the delivered homework. Points from homework are considered only if the grade of the written part is 18 or above. Homework texts are pisted on the Moodle platforma available on the Didactic portal.<\/p>\n\n\n\n\n\n\n\n\n\n<p class=\"eplus-wrapper wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>General Information Teaching Material SUBJECT MATERIAL Course introduction Course introduction Introduction to databases Introduction to databases Relational model Relational model Relational database design Conceptual design: E-R modelLogical design: Traslation of ER schema into Relational model (updated 2026-03-13)Restructuring ER schemaTime management SQL Language SQL Language: select, join, aggregated operators, group by &hellip;<\/p>\n","protected":false},"author":22,"featured_media":3455,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"editor_plus_copied_stylings":"{}","footnotes":""},"categories":[37],"tags":[],"class_list":["post-3243","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\/3243","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\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/comments?post=3243"}],"version-history":[{"count":312,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3243\/revisions"}],"predecessor-version":[{"id":14383,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3243\/revisions\/14383"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media\/3455"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media?parent=3243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=3243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=3243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}