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:aufgaben:a04 [2024/09/19 16:01] – [LU03.A04 - ERD: Travel DB] vdemir | modul:m290:learningunits:lu03:aufgaben:a04 [2024/10/02 15:13] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| After developing our conceptional data model, the next step to establish a physical data base is shape a ERD, the Entity Relationship Diagram. | After developing our conceptional data model, the next step to establish a physical data base is shape a ERD, the Entity Relationship Diagram. | ||
| Zeile 13: | Zeile 13: | ||
| Below figure of a conceptual data-model illustrates | Below figure of a conceptual data-model illustrates | ||
| + | {{: | ||
| ==== Task ==== | ==== Task ==== | ||
| Zeile 20: | Zeile 21: | ||
| - realize the relation as relation tables (id, fk_tab1, fk_tab2, ...) | - realize the relation as relation tables (id, fk_tab1, fk_tab2, ...) | ||
| - finalize the ERM by adding the cardinalities (1:1, 1:many, ...) | - finalize the ERM by adding the cardinalities (1:1, 1:many, ...) | ||
| + | - | ||
| ===== Solution ===== | ===== Solution ===== | ||
| + | |||
| [[modul: | [[modul: | ||