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:a05_erd [2024/09/12 08:58] – vdemir | modul:m290:learningunits:lu03:aufgaben:a05_erd [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 6: | Zeile 6: | ||
| * Work type: Peer | * Work type: Peer | ||
| * Means of aid: only teaching materials, no use of ai. | * Means of aid: only teaching materials, no use of ai. | ||
| - | * Timeframe: | + | * Timeframe: |
| * Expected result: A Word/PDF file with an ERD that visualises the given business case. | * Expected result: A Word/PDF file with an ERD that visualises the given business case. | ||
| Zeile 14: | Zeile 14: | ||
| * Identify additional attributes | * Identify additional attributes | ||
| * Establish relation with inkl. the primary keys and foreign keys | * Establish relation with inkl. the primary keys and foreign keys | ||
| - | * Connect the tables and finish your work by fixing the entities (0:1, :1, 0:n) | + | * Connect the tables and finish your work by fixing the entities (1:1, 1:n, n:m) |
| Zeile 26: | Zeile 26: | ||
| 2. ERM visualisation | 2. ERM visualisation | ||
| - | {{: | + | {{: |
| + | |||
| ===== Solution ===== | ===== Solution ===== | ||