{"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-04-21T16:28:46","modified_gmt":"2026-04-21T14:28:46","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-ef4d76\">\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__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__39c3495e-26b0-4222-b174-0a43ff42a936\" class=\"ep_label_main\"><span class=\"ep_label\">Relational model<\/span><\/a><a href=\"#ep_tab_wrapper__91f061f0-8cf2-4f20-9b4e-6bcfab031908\" class=\"ep_label_main\"><span class=\"ep_label\">Design of relational database<strong>s<\/strong><\/span><\/a><a href=\"#ep_tab_wrapper__5674fdc1-a2bd-44a3-8f59-573629060e14\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language<\/span><\/a><a href=\"#ep_tab_wrapper__c3749166-7ab2-4beb-8d06-d8e77e55b94b\" 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__39c3495e-26b0-4222-b174-0a43ff42a936\" class=\"ep_tab_item_wrapper ep_tab_wrapper__39c3495e-26b0-4222-b174-0a43ff42a936 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-9bc8fc\">\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__91f061f0-8cf2-4f20-9b4e-6bcfab031908\" class=\"ep_tab_item_wrapper ep_tab_wrapper__91f061f0-8cf2-4f20-9b4e-6bcfab031908 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-b9e289\">\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__5674fdc1-a2bd-44a3-8f59-573629060e14\" class=\"ep_tab_item_wrapper ep_tab_wrapper__5674fdc1-a2bd-44a3-8f59-573629060e14 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f160aa\">\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>)<\/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>)<\/li>\n<\/ul><\/div>\n\n\n\n<div id=\"ep_tab_wrapper__c3749166-7ab2-4beb-8d06-d8e77e55b94b\" class=\"ep_tab_item_wrapper ep_tab_wrapper__c3749166-7ab2-4beb-8d06-d8e77e55b94b undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-7cea78\">\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<\/div><style>.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .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__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .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__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .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__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__75958fdb-4ae4-4a35-b59e-d0a07fcf7d10 .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<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<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-4f06c9\">\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__3b0c5ac6-ea43-41e9-8c36-44dace3b192c\"><div class=\"ep_tabs_root ep_tabs_top\" data-autoplay=\"false\" data-delay=\"1000\"><div class=\"ep_tabs_header \"><a href=\"#ep_tab_wrapper__463e8145-c601-4128-9fbf-120b153b7bb4\" class=\"ep_label_main\"><span class=\"ep_label\">Database design<\/span><\/a><a href=\"#ep_tab_wrapper__68ca1a1d-859e-4d8a-bd1e-5e7e1da7a878\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language (join, group by)<\/span><\/a><a href=\"#ep_tab_wrapper__97330ad1-2311-4404-9736-f1957d50f014\" class=\"ep_label_main\"><span class=\"ep_label\">SQL Language (join, group by, in, not in)<\/span><\/a><a href=\"#ep_tab_wrapper__c2497fb3-73ca-4bd8-94de-3311375ff6d4\" 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__463e8145-c601-4128-9fbf-120b153b7bb4\" class=\"ep_tab_item_wrapper ep_tab_wrapper__463e8145-c601-4128-9fbf-120b153b7bb4 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-76e827\">\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__68ca1a1d-859e-4d8a-bd1e-5e7e1da7a878\" class=\"ep_tab_item_wrapper ep_tab_wrapper__68ca1a1d-859e-4d8a-bd1e-5e7e1da7a878 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-a1948a\">\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__97330ad1-2311-4404-9736-f1957d50f014\" class=\"ep_tab_item_wrapper ep_tab_wrapper__97330ad1-2311-4404-9736-f1957d50f014 undefined\"><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f3a7a4\">\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__c2497fb3-73ca-4bd8-94de-3311375ff6d4\" class=\"ep_tab_item_wrapper ep_tab_wrapper__c2497fb3-73ca-4bd8-94de-3311375ff6d4 undefined\"><\/div>\n<\/div><style>.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_tabs_header {\n                \n                flex-basis: 15% ;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_tabs_root {\n                \n                gap: 0px ;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .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__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .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__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_active_tab .ep_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_active_tab .ep_sub_label {\n                \n                color: #ffffff;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .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__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_label_main:hover {\n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_active_tab {\n                \n                background-image: linear-gradient(#007cba, #007cba);\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_tab_item_wrapper {\n                \n                background-image: linear-gradient(#f0f0f0, #f0f0f0);\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_label_main {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_tab_item_wrapper {\n                \n                padding-top: 15px ;\npadding-right: 15px ;\npadding-bottom: 15px ;\npadding-left: 15px ;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .ep_tabs_header {\n                \n                gap: 5px ;\n            }.eplus_styles .ep_tabs_wrapper__3b0c5ac6-ea43-41e9-8c36-44dace3b192c .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":302,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3243\/revisions"}],"predecessor-version":[{"id":14120,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3243\/revisions\/14120"}],"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}]}}