Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu03:loesungen:l02 [2024/08/14 15:32] – vdemir
+++ modul:m290:learningunits:lu03:loesungen:l02 [2024/10/02 15:13] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU03.L02 - Designing an ERD ======
+====== LU04.S02 - ERM: Travel DB ======
-===== Given business case =====
+For this scenario, the following entity(-types) are identified:
-As overreaching goal, we want to administrate our holidays. Though we want to store the following information:
-  * which countries we visited so far
-  * how long we stayed in each country
-  * on which continent each country is located
-  * the price for each trip
-  * the date of each trip
-===== Task: Design a ERD  ====
-Analyse the given business case and design an ERD that matches the requirements of the business case.
-===== Solution =====
-For this scenario, the following entities are identified:
 . Country
@@ Zeile 45: / Zeile 33: @@
- ERD in Crow's feet notation
+. ERM in Crow's feet notation
-Continent (1) ————< has >———— (∞) Country
+  * Continent (1) ————< has >———— (∞) Country
-Country (1) ————< hosts >———— (∞) Trip
+  * Country (1) ————< hosts >———— (∞) Trip
+{{:modul:m290:learningunits:lu03:loesungen:lu03.l02.png?1000|}}
 ===== Vocabulary =====
 ^ English ^ German ^
 | prerequisite | Grundvoraussetzung |
+| given| gegebene, vorausgesetzt |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir