Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu03:aufgaben:a05_erd [2024/09/05 08:35] – angelegt 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 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 24: | Zeile 24: | ||
| * A subject can be attended by many students. | * A subject can be attended by many students. | ||
| - | 2. ERM visualisatiob | + | 2. ERM visualisation |
| - | {{: | + | |
| + | {{: | ||
| + | |||
| ===== Solution ===== | ===== Solution ===== | ||