Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
modul:m290:learningunits:lu03:loesungen:l04 [2024/09/12 16:28] vdemirmodul:m290:learningunits:lu03:loesungen:l04 [2024/10/02 15:13] (aktuell) vdemir
Zeile 1: Zeile 1:
-====== LU03.S04 - ERD: Travel DB ======+====== LU04.S04 - ERD: Travel DB ======
   * The attribut must be taken over and added with data-types and constraints (primary keys)   * 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 relations must be realized as relation tables, that connect the base tables
Zeile 6: Zeile 6:
   * The attribut must be taken over and added with data-types and constraints (primary keys)   * The attribut must be taken over and added with data-types and constraints (primary keys)
  
-{{:modul:m290:learningunits:lu03:loesungen:a04.drawio.png}}+ 
 +{{:modul:m290:learningunits:lu03:loesungen:s04.drawio.png?1500|}}
  
 ===== Case Study ===== ===== Case Study =====
 The relation between **Countries** and **Continents** is a so called **many-to-many-relation = n:m-relation**. In the following illustration, we can see, that one continent consists of several countries. For some countries, however, this relationship applies in both directions, e.g. Turkey and Russia, which are located in both Asia and Europe. The relation between **Countries** and **Continents** is a so called **many-to-many-relation = n:m-relation**. In the following illustration, we can see, that one continent consists of several countries. For some countries, however, this relationship applies in both directions, e.g. Turkey and Russia, which are located in both Asia and Europe.
  
-{{:modul:m290:learningunits:lu03:loesungen:country-relations.png?800Case study of the relation between Countries and Continents}}+{{:modul:m290:learningunits:lu03:loesungen:country-relations.png?1000|}} 
  
  
  • modul/m290/learningunits/lu03/loesungen/l04.1726151322.txt.gz
  • Zuletzt geändert: 2024/09/12 16:28
  • von vdemir