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.
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