Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Nächste Überarbeitung
Vorhergehende Überarbeitung
modul:m290:learningunits:lu03:loesungen:l07 [2024/09/12 13:08] – angelegt vdemirmodul:m290:learningunits:lu03:loesungen:l07 [2024/10/17 13:27] (aktuell) vdemir
Zeile 1: Zeile 1:
-====== LU03.S07 - ERD: Reingeneering from the database  ======+====== LU04.S07 - ERD: Reingineering of an existing database  ======
  
 ===== Task  ===== ===== Task  =====
Zeile 11: Zeile 11:
       * Shippers        * Shippers 
       * Suppliers       * Suppliers
-  - Then we determine the attributes and the data-types of each entity (-table)+  - Then we determine the attributes and the data-types of each entity (-table).
   - We continue with the analysis of the relations. These are tables, which have foreign keys in their attribute list.   - We continue with the analysis of the relations. These are tables, which have foreign keys in their attribute list.
-  - Finally, we connect the tables with each other in the right fashion.+     * Orders 
 +     * OrderDetails 
 +     * Products   
 +  - Finally, we connect the tables with each other in the right fashion and determine the cardinalities (1:1, 1:n, n:m)
  
  
 ===== Solution ===== ===== Solution =====
 +{{:modul:m290:learningunits:lu03:loesungen:l07.drawio2.png?1500|}}
  
-{{:modul:m290:learningunits:lu03:loesungen:l07.drawio.png?1000| Solution of W3Schools data-base}} 
 ===== Vocabulary ===== ===== Vocabulary =====
 ^ English ^ German ^  ^ English ^ German ^ 
  • modul/m290/learningunits/lu03/loesungen/l07.1726139286.txt.gz
  • Zuletzt geändert: 2024/09/12 13:08
  • von vdemir