Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu03:loesungen:l04 [2024/08/30 15:27] – vdemir | modul:m290:learningunits:lu03:loesungen:l04 [2024/10/02 15:13] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| * 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 | ||
| * The attributes of the relation tables are: id, and the primary key of each base table as foreign key | * The attributes of the relation tables are: id, and the primary key of each base table as foreign key | ||
| * Finally, the cardinalities must be added, which show how the relationships between the tables actually are. | * Finally, the cardinalities must be added, which show how the relationships between the tables actually are. | ||
| + | * The attribut must be taken over and added with data-types and constraints (primary keys) | ||
| + | |||
| + | |||
| + | {{: | ||
| + | |||
| + | ===== Case Study ===== | ||
| + | The relation between **Countries** and **Continents** is a so called **many-to-many-relation = n: | ||
| + | |||
| + | {{: | ||
| - | {{: | ||
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||
| ^ English ^ German ^ | ^ English ^ German ^ | ||
| - | | contraint | + | | constraint |
| | given | gegebene, vorausgesetzt | | | given | gegebene, vorausgesetzt | | ||
| + | | case study | Fallbeispiel | | ||
| ---- | ---- | ||
| [[https:// | [[https:// | ||