{"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-14T11:51:43","modified_gmt":"2026-05-14T09:51:43","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-2ba5e7\">\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\"><\/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\"><\/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\"><\/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__b6970846-9157-4451-bf42-34b8269b26b5\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__263207df-681f-4a1b-80a1-5d56a1a91520\" class=\"ep_label_main\"><span class=\"ep_label\">Relational model<\/span><\/a><a href=\"#ep_tab_wrapper__2e9e3081-4929-47a9-b8b5-e469cbc0532c\" class=\"ep_label_main\"><span class=\"ep_label\">Design of relational database<strong>s<\/strong><\/span><\/a><a href=\"#ep_tab_wrapper__df1f0c8a-6e7d-47c6-9c85-0f22dc188ec4\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language<\/span><\/a><a href=\"#ep_tab_wrapper__03517730-3e62-4d86-8c24-f7f3c6448c25\" 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__263207df-681f-4a1b-80a1-5d56a1a91520\" class=\"ep_tab_item_wrapper ep_tab_wrapper__263207df-681f-4a1b-80a1-5d56a1a91520 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-a45411\">\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__2e9e3081-4929-47a9-b8b5-e469cbc0532c\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2e9e3081-4929-47a9-b8b5-e469cbc0532c undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f6092f\">\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__df1f0c8a-6e7d-47c6-9c85-0f22dc188ec4\" class=\"ep_tab_item_wrapper ep_tab_wrapper__df1f0c8a-6e7d-47c6-9c85-0f22dc188ec4 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-286141\">\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__03517730-3e62-4d86-8c24-f7f3c6448c25\" class=\"ep_tab_item_wrapper ep_tab_wrapper__03517730-3e62-4d86-8c24-f7f3c6448c25 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-072c40\">\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<\/ul><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .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__b6970846-9157-4451-bf42-34b8269b26b5 .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__b6970846-9157-4451-bf42-34b8269b26b5 .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .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__b6970846-9157-4451-bf42-34b8269b26b5 .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__b6970846-9157-4451-bf42-34b8269b26b5 .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\"><\/p>\n\n\n\n\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-3bf7d8\"><\/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__648ff87f-8a43-4d23-bf6d-59db12ca45bf\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__b71cb72f-6812-41b5-9ed5-49bc101d6e1d\" class=\"ep_label_main\"><span class=\"ep_label\">Database design<\/span><\/a><a href=\"#ep_tab_wrapper__4b2445ce-7d0f-4302-bd3a-e22acacfa941\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language (join, group by)<\/span><\/a><a href=\"#ep_tab_wrapper__2a75148b-6eb1-4663-ad4a-4ae4e87a4616\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language (join, group by, in, not in)<\/span><\/a><a href=\"#ep_tab_wrapper__46cc3df1-acdb-494e-840c-c5e1ae7bbad5\" 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__b71cb72f-6812-41b5-9ed5-49bc101d6e1d\" class=\"ep_tab_item_wrapper ep_tab_wrapper__b71cb72f-6812-41b5-9ed5-49bc101d6e1d undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-dbd9de\">\n<li class=\" eplus-wrapper\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/Lab1_DBdesign.pdf\">Exercise text<\/a> <\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__4b2445ce-7d0f-4302-bd3a-e22acacfa941\" class=\"ep_tab_item_wrapper ep_tab_wrapper__4b2445ce-7d0f-4302-bd3a-e22acacfa941 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-9e0858\">\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> <\/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__2a75148b-6eb1-4663-ad4a-4ae4e87a4616\" class=\"ep_tab_item_wrapper ep_tab_wrapper__2a75148b-6eb1-4663-ad4a-4ae4e87a4616 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-1e1b35\">\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><\/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__46cc3df1-acdb-494e-840c-c5e1ae7bbad5\" class=\"ep_tab_item_wrapper ep_tab_wrapper__46cc3df1-acdb-494e-840c-c5e1ae7bbad5 undefined\"><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .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__648ff87f-8a43-4d23-bf6d-59db12ca45bf .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__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .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__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__648ff87f-8a43-4d23-bf6d-59db12ca45bf .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<p class=\" eplus-wrapper\"><\/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\"><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\"><\/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":306,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3243\/revisions"}],"predecessor-version":[{"id":14294,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3243\/revisions\/14294"}],"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}]}}