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:theorie:c_erm_erd [2024/08/23 15:25] – [Entity-Relationship Diagram = ERD] vdemir | modul:m290:learningunits:lu03:theorie:c_erm_erd [2024/10/02 15:14] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ==== Entity-Relationship Model = ERM ==== | ==== Entity-Relationship Model = ERM ==== | ||
| The Entity-Relationship Model (ERM) is a **conceptual data-model** used in database design to represent relationships between data entities in a system. An entity is a real-world object or concept, such as customer or product, and each entity has specific attributes that describe it. **ERM serves as a blueprint for creating databases, ensuring that data is accurately captured and linked**. The following illustration shows a database of students, their teachers and the rooms in which the lessons are are held. | The Entity-Relationship Model (ERM) is a **conceptual data-model** used in database design to represent relationships between data entities in a system. An entity is a real-world object or concept, such as customer or product, and each entity has specific attributes that describe it. **ERM serves as a blueprint for creating databases, ensuring that data is accurately captured and linked**. The following illustration shows a database of students, their teachers and the rooms in which the lessons are are held. | ||
| + | |||
| + | |||
| + | ==== ERM / ERD Editor ==== | ||
| + | Draw.io is a powerful visualisation editor, which is available as an online version as well as an offline app. | ||
| + | |||
| + | * Available: [[https:// | ||
| + | * The necessary icons are offered on the left hand side, under the category " | ||
| + | * The save function is quite obvious an needs no further explaination | ||
| + | * After you have completed your assignment, you can "Datei > Export > PNG/ | ||
| + | |||
| + | |||
| + | ==== Youtube tutorials ==== | ||
| + | * [[https:// | ||
| + | |||
| + | ==== Additional Youtube tutorials ==== | ||
| + | * [[https:// | ||
| + | * [[https:// | ||
| + | |||
| {{: | {{: | ||
| Zeile 13: | Zeile 31: | ||
| ===== Additonal material ===== | ===== Additonal material ===== | ||
| - | * [[https:// | ||
| - | * [[https:// | ||
| - | * [[https:// | ||
| * [[https:// | * [[https:// | ||
| * [[https:// | * [[https:// | ||