Entity Relationship Diagrams
An easy-to-follow tutorial on Entity Relationship Diagrams (ERDs). In this video, we explore how ERDs help to clarify crucial aspects of what’s going on in a database design. Using a range of examples, we go step-by-step through the process of taking a set of information requirements and turning it into an ERD.
👉📘Download the FREE PDF (Decomplexify Quick Reference Guide) - a concise guide to Entity Relationship Diagram (ERD) Chen & Crow's Foot Notation, plus normal forms:
https://decomplexify.myflodesk.com/wm...
🔥🎥 Got a database schema that feels ‘off’? Send it in—I might feature it in a video where I pick it apart and show how I’d redesign it. (On my channel page, click on “More about this channel” → “View email address”.)
0:00 Introduction
0:57 Extracting information requirements
2:58 Relationships
4:07 Cardinality
6:42 Basics of Chen notation
9:50 Attributes
11:04 Weak entities
13:17 Crow's foot notation
15:10 M-M / 1-M / 1-1 relationships
18:07 From ERD to relational database
20:00 Conclusion