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:loesungen:l06 [2024/09/09 13:54] – vdemir | modul:m290:learningunits:lu03:loesungen:l06 [2024/10/02 15:12] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| - | + | ||
| - | + | ||
| - | **ERM** | + | |
| - | * Description: | + | |
| - | * Purpose: Blueprint | + | |
| - | * Similiarties | + | |
| - | - sdfasdf | + | |
| - | - sdfasdf | + | |
| - | + | ||
| - | **ERD** | + | |
| - | * Definition: | + | |
| - | * Purpose: technical plan, ready to construct the data base | + | |
| - | + | ||
| - | | Purpose | | | | + | |
| - | | Similaritiy | Notation method for data-base strucure in order to descripe business cases| | | + | |
| - | | Differences | | + | |
| ===== Prerequisites | ===== Prerequisites | ||
| Zeile 25: | Zeile 8: | ||
| ===== Task ===== | ===== Task ===== | ||
| - | Compare both terms, ERM and ERD, and describe the purpose of each, and find at least 3 similarities and 3 differences. | + | Compare both terms, ERM and ERD, and describe the purpose of each, and find at least 2 similarities and 2 differences. |
| + | |||
| + | **ERM** | ||
| + | * Description: | ||
| + | * Purpose: Blueprint of the business cases | ||
| + | |||
| + | **ERD** | ||
| + | * Description: | ||
| + | * Purpose: construction plan, ready to build up the data-base physically | ||
| + | |||
| + | **Similarties** | ||
| + | * Both notation methods are used to describe the data-base structure of the business cases | ||
| + | * Entity = rectangle | ||
| + | * Cardinalities: | ||
| + | * Entities have attributes | ||
| - | ===== Solution ===== | + | |
| - | [[modul:m290:learningunits:lu03:loesungen:l06|Lösung]] | + | * Relations: |
| + | * ERM: rhomb | ||
| + | * ERD: relalation-table | ||
| + | * ERD: Described in the Crow's foot notation | ||
| + | * Attributes: | ||
| + | * ERM: bubbles above, which are connected with the entity | ||
| + | * ERD: As details in the Entity, including data-type | ||
| + | * ERD: Memory amount is describes within the data-type defintion | ||
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||