https://wiki.bzz.ch/ 2026-04-07T22:11:22+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-17T10:32:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l01?rev=1729161155&do=diff LU04.S01 - Choose data-types Which datatype would you use to store the following information? Give reason for your decision. 1. Product-title like trousers up to 50 characters: * VARCHAR(50) * Titles can be at the most 50 characters. A fix length like a simple CHAR(50) makes no sense in that case. text/html 2024-10-02T13:13:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l02?rev=1727874800&do=diff LU04.S02 - ERM: Travel DB For this scenario, the following entity(-types) are identified: 1. Country * Attributes * CountryID (Primary Key) * CountryName * ContinentName 2. Trip * Attributes * TripID (Primary Key) * CountryID (Foreign Key) text/html 2024-10-02T13:13:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l03?rev=1727874791&do=diff LU04.S03 - ERM: SchoolGrades_DB For this scenario, the following entity-types are identified: 1. Grad * Attributes * grade_id: INT * grade_Value: INT 2. Student * Attributes * student_id (PK) * name: VARCHAR(50) 3. Subject * text/html 2024-10-02T13:13:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l04?rev=1727874783&do=diff LU04.S04 - ERD: Travel DB * The attribut must be taken over and added with data-types and constraints (primary keys) * The relations must be realized as relation tables, that connect the base tables * The attributes of the relation tables are: id, and the primary key of each base table as foreign key text/html 2024-10-02T13:12:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l05?rev=1727874776&do=diff LU04.S05 - ERD: SchoolGrades_DB * The attribut must be taken over and added with data-types and constraints (primary keys) * The relations must be realized as relation tables, that connect the base tables * The attributes of the relation tables are: id, and the primary key of each base table as foreign key text/html 2024-10-02T13:12:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l06?rev=1727874768&do=diff LU04.S06 - ERM vs. ERD Prerequisites * Work type: Peer * Means of aid: only teaching materials, no use of ai. * Timeframe: 5 Minutes * Expected result: A Word/PDF file with an a comparison of the terms ERM vs. ERD. Task Compare both terms, ERM and ERD, and describe the purpose of each, and find at least 2 similarities and 2 differences. text/html 2024-10-17T11:27:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu03/loesungen/l07?rev=1729164424&do=diff LU04.S07 - ERD: Reingineering of an existing database Task Go to the W3Schools-Website, to the SQL-Editor, and analyze the existing data-structure. Create furthermore an ERD, that describes the existing data-structure in the Crow's Foot Notation. Suggested approach