Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu03:theorie:d_crowfeet [2024/08/16 10:52] – vdemir
+++ modul:m290:learningunits:lu03:theorie:d_crowfeet [2024/10/02 15:14] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU03d - The Crow's Feet Notation ======
+====== LU04d - The Crow's Feet Notation ======
 ==== The Basics of Crow’s Foot Notation ====
@@ Zeile 18: / Zeile 18: @@
 The figure below shows all possible cardinalities between entities.
-{{:modul:m290:learningunits:lu03:theorie:crow-notation-chart-4127045304.png?400|}}
+{{:modul:m290:learningunits:lu03:theorie:crow-notation-chart-4127045304.png?300|}}
+[[https://www.youtube.com/watch?v=I-XHfuJ43ic| Lernvideo: ERD Crow's Feet Notation]]
 ==== Why Use Crow’s Foot Notation? ====
@@ Zeile 27: / Zeile 29: @@
 Consider a simple ERD for an online bookstore. The entities might include **Customers**, **Orders**, and **Books**.
-- **Customers** can place multiple **Orders** (One-to-Many).
+  * **Customers** can place multiple **Orders** (One-to-Many).
-- Each **Order** can include multiple **Books** (Many-to-Many).
+  * Each **Order** can include multiple **Books** (Many-to-Many).
 Using Crow’s Foot notation:
-- The relationship between **Customers** and **Orders** would have a single line connecting the entities with a vertical line on the **Customers** side and a crow’s foot on the **Orders** side.
+  * The relationship between **Customers** and **Orders** would have a single line connecting the entities with a vertical line on the **Customers** side and a crow’s foot on the **Orders** side.
-- The relationship between **Orders** and **Books** would have crow’s feet on both sides, representing the many-to-many relationship.
+  * The relationship between **Orders** and **Books** would have crow’s feet on both sides, representing the many-to-many relationship.
-### Conclusion
-Crow’s Foot notation is a powerful tool in the design and representation of relational databases. By visually capturing the relationships and cardinality between entities, it simplifies the process of database design, ensuring that data structures are well-organized and accurately reflect the complexities of real-world relationships. Understanding and applying Crow’s Foot notation is essential for anyone involved in the creation or management of relational databases, as it promotes both efficiency and clarity in database design.
-===== Assignments =====
-<nspages .:aufgaben -h1  -exclude:start -simpleList -textPages="">
-===== Vocabulary =====
+==== Vocabulary ====
+^English ^ Deutsch ^
+| to convey | vermitteln, mitteilen |
+| to refere to | Bezug nehmen auf |
+| instance | Beispiel |
+| nature | Wesen, Beschaffenheit |
+| to indicate | andeuten, zeigen |
+| might | möglicherweise |
+| to denote | bedeuten, hindeuten |
+| to depict | darstellen |
+| to imply | implizieren |
+| to enroll | einschreiben, sich anmelden |
+| to consider | in Betracht ziehen, bedenken |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir