https://wiki.bzz.ch/ 2026-04-07T17:21:34+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-02T13:14:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a01?rev=1727874877&do=diff LU04.A01 - Choose data-types Prerequisites * Work type: Peer * Means of aid: only teaching materials, no websearch, no use of ai. * Timeframe: 10 Minutes * Expected result: A Word/PDF file with selected data types and an explanation of why. text/html 2024-10-02T13:14:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a02?rev=1727874865&do=diff LU04.A02 - ERM: Travel_DB Prerequisites * Work type: Peer * Means of aid: only teaching materials, no websearch, no use of ai. * Timeframe: 10 Minutes * Expected result: A Word/PDF file with an ERM that visualises the given business case. text/html 2024-10-02T13:13:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a03?rev=1727874838&do=diff LU04.A03 - ERM: SchoolGrades_DB Prerequisites * Work type: Peer * Means of aid: only teaching materials, no websearch, no use of ai. * Timeframe: 15 Minutes * Expected result: A Word/PDF file with an ERM that visualises the given business case. text/html 2024-10-02T13:13:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a04?rev=1727874830&do=diff LU04.A04 - ERD: Travel DB After developing our conceptional data model, the next step to establish a physical data base is shape a ERD, the Entity Relationship Diagram. Prerequisites * Work type: Peer * Means of aid: only teaching materials, no use of ai. text/html 2024-10-02T13:13:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a05_erd?rev=1727874822&do=diff LU04.A05 - ERD: SchoolGrades DB After developing our conceptional data model, the next step to establish a physical data base is shape a ERD, the Entity Relationship Diagram. Prerequisites * Work type: Peer * Means of aid: only teaching materials, no use of ai. text/html 2024-10-02T13:13:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a06?rev=1727874815&do=diff LU04.A06 - ERM vs. ERD In the previous lessons, you learnt what the term ERM means and what is generally understood by ERD. It is high time to consolidate these two technical terms. Prerequisites * Work type: Peer * Means of aid: only teaching materials, no use of ai. text/html 2024-10-17T11:27:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu03/aufgaben/a07_erd?rev=1729164432&do=diff LU04.A07 - ERD: Reingineering of an existing database From time to time, we may need to analyze an existing database in order to optimize the structure, e.g. for the next software version. Prerequisites * Work type: Peer * Means of aid: W3Schools-SQL-Editor * Timeframe: 45 Minutes