{"id":3190,"date":"2022-02-24T08:52:02","date_gmt":"2022-02-24T07:52:02","guid":{"rendered":"https:\/\/dbdmg.polito.it\/dbdmg_web\/?p=3190"},"modified":"2026-04-30T00:49:06","modified_gmt":"2026-04-29T22:49:06","slug":"introduction-data-bases","status":"publish","type":"post","link":"https:\/\/dbdmg.polito.it\/dbdmg_web\/2022\/introduction-data-bases\/","title":{"rendered":"Introduction To Databases"},"content":{"rendered":"\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"informazioni-generali\">General Informations<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-6ddfee\">\n<li class=\" eplus-wrapper\">SSD: ING-INF\/05<\/li>\n\n\n\n<li class=\" eplus-wrapper\">ECTS: 8<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Official <a href=\"https:\/\/didattica.polito.it\/pls\/portal30\/gap.pkg_guide.viewGap?p_cod_ins=01RKWLM&amp;p_a_acc=2023&amp;p_header=S&amp;p_lang=EN&amp;multi=N\">information sheet<\/a> of the course<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Professor: Lia Morra <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Teaching Assistants: Francesco Manigrasso, Pietro Basci, Andrea Sordello, Alberto Verna<\/li>\n<\/ul>\n\n\n<h4 class=\" wp-block-heading eplus-wrapper\" id=\"avvisi\">Announcements<\/h4>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-ee6336\">\n<li class=\" eplus-wrapper\">Announcements are posted on the Teaching Portal (Portale della Didattica)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">All discussions about the course can be opened on <a href=\"https:\/\/piazza.com\/polito.it\/spring2026\/01rkwlm\">Piazza<\/a>.<\/li>\n<\/ul>\n\n\n<h4 class=\" wp-block-heading eplus-wrapper\" id=\"avvisi\">Timetable<\/h4>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>Type<\/strong><\/td><td><strong>Day of the week<\/strong><\/td><td><strong>Time<\/strong><\/td><td><strong>Classroom<\/strong><\/td><\/tr><tr><td>Lecture<\/td><td>Monday<\/td><td>13:00-16:00<\/td><td>Room R2<\/td><\/tr><tr><td>Lecture<\/td><td>Wednesday<\/td><td>16:00-19:00<\/td><td>Room R2<\/td><\/tr><tr><td>Lab <\/td><td>Friday<\/td><td>10:00-11:30<\/td><td>Laib1<\/td><\/tr><tr><td>Lab <\/td><td>Friday<\/td><td>13:00-14:30<\/td><td>Laib1<\/td><\/tr><\/tbody><\/table><\/figure>\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<h2 class=\" wp-block-heading eplus-wrapper\" id=\"material\">Material<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-a2a6d3\">\n<li class=\" eplus-wrapper\"><strong>Introduction to the course<\/strong> (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/02\/00.-Course-introduction-25-26.pdf\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Introduction to databases<\/strong> (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/01.-Introduction-to-databases.pdf\" data-type=\"attachment\" data-id=\"8468\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/01.-Introduction-to-databases-6x.pdf\" data-type=\"attachment\" data-id=\"8467\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Relational data model<\/strong> (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/02.-Relational-model.pdf\" data-type=\"attachment\" data-id=\"8507\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/02.-Relational-model-6x.pdf\" data-type=\"attachment\" data-id=\"8508\">pdf6x<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Database design<\/strong><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-2cb94c\">\n<li class=\" eplus-wrapper\">Entity-Relation Model (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/03.-ER-Model-1.pdf\" data-type=\"attachment\" data-id=\"8628\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/03.-ER-Model-6x-1.pdf\" data-type=\"attachment\" data-id=\"8627\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Time representation (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/04.-ER-model-time-representation-1.pdf\" data-type=\"attachment\" data-id=\"8642\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/04.-ER-model-time-representation-6x-1.pdf\" data-type=\"link\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/04.-ER-model-time-representation-6x-1.pdf\">pdf6x<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Logical design &#8211; Translation (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/05.-Relational-logical-design.pdf\" data-type=\"attachment\" data-id=\"8644\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/05.-Relational-logical-design-6x.pdf\" data-type=\"attachment\" data-id=\"8645\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Conceptual design example (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/06.-ER-Conceptual-design-example.pdf\" data-type=\"attachment\" data-id=\"8640\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/06.-ER-Conceptual-design-example-6x.pdf\" data-type=\"attachment\" data-id=\"8641\">pdf6x<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Logical design example (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/06.-ER-Logical-design-example.pdf\" data-type=\"attachment\" data-id=\"8670\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/06.-ER-Logical-design-example-6x.pdf\" data-type=\"attachment\" data-id=\"8669\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Normalization (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/07.-Normalization.pdf\" data-type=\"attachment\" data-id=\"8625\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/07.-Normalization-6x.pdf\" data-type=\"attachment\" data-id=\"8624\">pdf6x<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Relational algebra <\/strong>(<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/08.-Relational-algebra.pdf\" data-type=\"attachment\" data-id=\"8735\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/03\/08.-Relational-algebra-6x.pdf\" data-type=\"attachment\" data-id=\"8734\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>SQL language<\/strong><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-4157f5\">\n<li class=\" eplus-wrapper\">Fundamentals (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/09.-SQL-Introduction.pdf\" data-type=\"attachment\" data-id=\"8849\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/09.-SQL-Introduction-6x.pdf\" data-type=\"attachment\" data-id=\"8848\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Nested queries (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/10.-SQL-Nested-queries.pdf\" data-type=\"attachment\" data-id=\"8940\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/10.-SQL-Nested-queries-6x.pdf\" data-type=\"attachment\" data-id=\"8939\">pdf6x<\/a>) <\/li>\n\n\n\n<li class=\" eplus-wrapper\">Set operators (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/11.-SQL-set-operators.pdf\" data-type=\"attachment\" data-id=\"8948\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/11.-SQL-set-operators-6x.pdf\" data-type=\"attachment\" data-id=\"8947\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Advanced queries (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/12.-SQL-Advanced-queries.pdf\" data-type=\"attachment\" data-id=\"8949\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/12.-SQL-Advanced-queries-6x.pdf\" data-type=\"attachment\" data-id=\"8950\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Update commands (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/13.-SQL-update-commands.pdf\" data-type=\"attachment\" data-id=\"9060\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/13.-SQL-update-commands-6x.pdf\" data-type=\"attachment\" data-id=\"9059\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Table management (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/14.-SQL-Table-management.pdf\" data-type=\"attachment\" data-id=\"6483\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/04\/14.-SQL-Table-management-6x.pdf\" data-type=\"attachment\" data-id=\"9057\">pdf6x<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Advanced SQL (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/04\/18.-SQL-Advanced-topics-1.pdf\" data-type=\"attachment\" data-id=\"6775\">pdf<\/a>, <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/18.-SQL-Advanced-topics-6x.pdf\">pdf6x<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>SQL for applications<\/strong><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-9488b5\">\n<li class=\" eplus-wrapper\">Web applications (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/16.-Web-Applications.pdf\" data-type=\"attachment\" data-id=\"6720\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Streamlit (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/16.-Streamlit.pdf\" data-type=\"attachment\" data-id=\"6721\">pdf<\/a>)<\/li>\n\n\n\n<li class=\" eplus-wrapper\">Live coding (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/17.-Live-Coding.pdf\" data-type=\"attachment\" data-id=\"6719\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n<li class=\" eplus-wrapper\"><strong>Trigger<\/strong><ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f4da79\">\n<li class=\" eplus-wrapper\">Trigger (<a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/04\/15.-Trigger.pdf\">pdf<\/a>)<\/li>\n<\/ul><\/li>\n\n\n\n\n\n\n\n\n<\/ul>\n\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\" id=\"exercizes\">Classroom exercises <\/h2>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\">DesignER tool presentation: <a href=\"https:\/\/designerdb.io\/\">Link to presentation<\/a><\/p>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>Topic<\/strong><\/td><td><strong>Text<\/strong><\/td><td><strong>Solution<\/strong><\/td><\/tr><tr><td>Relational model<\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Relational-model-exercise.pdf\" data-type=\"attachment\" data-id=\"5659\">Relational model exercises<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Relational-model-exercise-commented.pdf\" data-type=\"attachment\" data-id=\"5896\">Relational model exercises commented<\/a><\/td><\/tr><tr><td>ER model<\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_conceptual_model_exercises.pdf\" data-type=\"attachment\" data-id=\"5693\">Entity relationship exercises<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_conceptual_model-solution.pdf\">Entity relationship exercises solution (pdf)<\/a> <br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/ER_conceptual_model_solutions_designer.zip\">Entity relationship exercises solutions (Designer)<\/a> <br><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\">ER restructuring and translation (pdf)<\/a><\/td><\/tr><tr><td>Conceptual design<\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/conceptual_logical_design_exercises_part1.pdf\"><br>Exercises part I<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/conceptual_logical_design_exercises_part2.pdf\">Exercises part II<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/03\/ex5_babyparking_draft_c.zip\" data-type=\"attachment\" data-id=\"13923\">ex5 Babyparking<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/conceptual_logical_design_exercises_solutions.pdf\" data-type=\"link\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/conceptual_logical_design_exercises_solutions.pdf\">Draft solutions (pdf)<\/a> <\/td><\/tr><tr><td>Relational algebra<\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/03\/Algebra-SQL-I-website.pdf\" data-type=\"attachment\" data-id=\"11594\">Algebra part 1<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2022\/04\/Esercitazione-Algebra-2_exercises.pdf\">Algebra part 2<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/04\/Sol-Algebra-exercises-part-I.pdf\" data-type=\"attachment\" data-id=\"14155\">Solution part 1<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2026\/04\/Sol-Algebra-exercises-part-II.pdf\" data-type=\"attachment\" data-id=\"14156\">Solution part 2<\/a><\/td><\/tr><tr><td>SQL<\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/SQL-Exercises-partI.pdf\"><br>SQL exercises part I<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/SQL-Exercises-partII.pdf\">SQL exercises part II<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/05\/SQL-Exercises-partIII.pdf\">SQL exercises part III<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/SQL-Exercises-partI-solutions.pdf\" data-type=\"attachment\" data-id=\"6234\">SQL exercises part I (solutions)<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/SQL-Exercises-partII-solutions.pdf\" data-type=\"attachment\" data-id=\"6292\">SQL exercises part II (partial solutions)<\/a> <\/td><\/tr><tr><td>Triggers<\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_ranking-EN.pdf\">Ranking exercise<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_studentgrant-EN-1.pdf\" data-type=\"attachment\" data-id=\"3585\">Scholarship exercise<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_calendar-EN.pdf\">Event calendar exercise<br><\/a><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_leave-EN.pdf\">Leave requests exercise<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_studentgrant_sol-EN.pdf\" data-type=\"attachment\" data-id=\"3585\"><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_ranking_sol-EN.pdf\" data-type=\"link\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_ranking_sol-EN.pdf\">Ranking draft solution<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_studentgrant_sol-EN.pdf\" data-type=\"attachment\" data-id=\"3585\">Scholarship exercise<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_calendar_sol-EN.pdf\" data-type=\"attachment\" data-id=\"9478\">Event calendar draft solution<br><\/a><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2024\/05\/trigger_leave_sol-EN.pdf\" data-type=\"attachment\" data-id=\"9480\">Leave requests draft solution<\/a><\/a><\/td><\/tr><\/tbody><\/table><\/figure>\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<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\" id=\"lab-sw\">Lab practice<\/h2>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\">Groups are divided by the surname initials.<\/p>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>Student Group<\/strong><\/td><td><strong>Day of the week<\/strong><\/td><td><strong>Time<\/strong><\/td><td><strong>Classroom<\/strong><\/td><\/tr><tr><td>Team 1: A-B<\/td><td>Friday<\/td><td>10:00-11:30<\/td><td>LAIB1<\/td><\/tr><tr><td>Team 2: C-K<\/td><td>Friday<\/td><td>10:00-11:30<\/td><td>LAIB1<\/td><\/tr><tr><td>Team 3: L-R<\/td><td>Friday<\/td><td>13:00-14:30<\/td><td>LAIB1<\/td><\/tr><tr><td>Team 4: S-Z<\/td><td>Friday<\/td><td>13:00-14:30<\/td><td>LAIB1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<figure class=\" wp-block-table eplus-wrapper\"><table><tbody><tr><td><strong>Lab dates<\/strong><\/td><td><strong>Topic<\/strong><\/td><td><strong>Material<\/strong><\/td><td><strong>Solution<\/strong><\/td><\/tr><tr><td>20\/03\/2026 (A-K)<br>20\/03\/2026 (L-Z)<\/td><td>ER and logical design<\/td><td>DesignER tool available at <a href=\"https:\/\/designerdb.io\/\">https:\/\/designerdb.io\/<\/a><br><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Lab1_DBdesign.pdf\" data-type=\"attachment\" data-id=\"6069\">Lab exercises (text)<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/03\/Lab1_DBdesign_sol.pdf\" data-type=\"attachment\" data-id=\"6086\">Solution (pdf)<\/a><\/td><\/tr><tr><td>10\/04\/2026 (A-K)<br>10\/04\/2026 (L-Z)<\/td><td>Algebra<\/td><td><br>See Moodle<\/td><td><\/td><\/tr><tr><td>24\/04\/2026 (A-K)<br>24\/04\/2026 (L-Z)<\/td><td>SQL I<\/td><td>Oracle Apex (online version) available at&nbsp;<a href=\"https:\/\/apex.oracle.com\/it\/\">https:\/\/apex.oracle.com\/<\/a><br>Lab: <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/04\/SQL_oracle.pdf\" data-type=\"attachment\" data-id=\"6289\">text<\/a> &#8211; <a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2023\/04\/db_deliveries.zip\" data-type=\"attachment\" data-id=\"6288\">database<\/a><\/td><td><a href=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/04\/SQL_oracle_sol.pdf\" data-type=\"link\" data-id=\"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-content\/uploads\/2025\/04\/SQL_oracle_sol.pdf\">Solution (pdf)<\/a><\/td><\/tr><tr><td>08\/05\/2026 (A-K)<br>08\/05\/2026 (L-Z)<\/td><td>SQL II<\/td><td><\/td><td><\/td><\/tr><tr><td>15\/05\/2026 (A-K)<br>15\/05\/2026 (L-Z)<\/td><td>Triggers<\/td><td><\/td><td><\/td><\/tr><tr><td>29\/05\/2026 (A-K)<br>29\/05\/2026 (L-Z)<\/td><td>Web applications Streamlit I<\/td><td><\/td><td><\/td><\/tr><tr><td>05\/06\/2026 (A-K) <br>05\/06\/2026 (L-Z)<\/td><td>Web applications Streamlit II<\/td><td><\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-0f84a8\">\n<li class=\" eplus-wrapper\">\n<\/ul>\n\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-a23dc9\"><\/ul>\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\" id=\"homeworks\">Homeworks<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-f02895\">\n<li class=\" eplus-wrapper\">Homeworks will be published on the Moodle platform<\/li>\n<\/ul>\n\n\n\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-59bbde\">\n<li class=\" eplus-wrapper\">\n<\/ul>\n\n\n\n\n<hr class=\" wp-block-separator has-css-opacity eplus-wrapper\"\/>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<h2 class=\" wp-block-heading eplus-wrapper\" id=\"temi-d-esame\">Past Exams<\/h2>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-16b591\">\n<li class=\" eplus-wrapper\">Past exams will be made available on Moodle<\/li>\n<\/ul>\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n\n<p class=\" eplus-wrapper\"><\/p>\n\n\n<ul class=\" wp-block-list eplus-wrapper eplus-styles-uid-867607\">\n<li class=\" eplus-wrapper\">\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>General Informations Announcements Timetable Type Day of the week Time Classroom Lecture Monday 13:00-16:00 Room R2 Lecture Wednesday 16:00-19:00 Room R2 Lab Friday 10:00-11:30 Laib1 Lab Friday 13:00-14:30 Laib1 Material Classroom exercises DesignER tool presentation: Link to presentation Topic Text Solution Relational model Relational model exercises Relational model exercises commented &hellip;<\/p>\n","protected":false},"author":11,"featured_media":3453,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"editor_plus_copied_stylings":"{}","footnotes":""},"categories":[37],"tags":[],"class_list":["post-3190","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\/3190","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/comments?post=3190"}],"version-history":[{"count":329,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3190\/revisions"}],"predecessor-version":[{"id":14189,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/posts\/3190\/revisions\/14189"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media\/3453"}],"wp:attachment":[{"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/media?parent=3190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/categories?post=3190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbdmg.polito.it\/dbdmg_web\/wp-json\/wp\/v2\/tags?post=3190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}