Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung
Vorhergehende Überarbeitung
modul:m290:learningunits:lu03:loesungen:l06 [2024/09/09 13:54] vdemirmodul:m290:learningunits:lu03:loesungen:l06 [2024/10/02 15:12] (aktuell) vdemir
Zeile 1: Zeile 1:
-====== LU03.A06 - ERM vs. ERD ====== +====== LU04.S06 - ERM vs. ERD ======
- +
- +
-**ERM** +
-  * Description: First step to find the entities and the correlations between them. +
-  * Purpose: Blueprint +
-  * Similiarties +
-    - sdfasdf +
-    - sdfasdf +
- +
-**ERD** +
-  * Definition:Identification of details, such as data-types, relation-table and the cardinality  +
-  * 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 similarities and differences.+Compare both terms, ERM and ERD,  and describe the purpose of each, and find at least similarities and differences. 
 + 
 +**ERM** 
 +  * Description: First step to find the entities and the correlations between them. 
 +  * Purpose: Blueprint of the business cases 
 + 
 +**ERD** 
 +  * Description:Identification of details, such as data-types, relation-table and the cardinality  
 +  * 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: 1:1, 1:n, n:m 
 +  * Entities have attributes
  
-===== Solution ===== + **Differences:** 
-[[modul:m290:learningunits:lu03:loesungen:l06|Lösung]]+  * Relations: 
 +    * ERMrhomb 
 +    * ERDrelalation-table 
 +    * ERDDescribed 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 
 +    * ERDMemory amount is describes within the data-type defintion
  
 ===== Vocabulary ===== ===== Vocabulary =====
  • modul/m290/learningunits/lu03/loesungen/l06.1725882853.txt.gz
  • Zuletzt geändert: 2024/09/09 13:54
  • von vdemir