Common Beginner's ERD Mistakes

Mistakes to avoid when creating Entity Relationship Diagrams (ERD) or conceptual data models.
To learn more or for mentorship: https://courses.why-change.com/courses/
00:00 The value of data models
01:50 ERD building blocks
03:05 What is a relationship
05:10 Cryptic names
05:48 Plural entity names.
06:15 Too many words in entity names
06:34 Too specific (categorized)
07:54 Confusing entities and states
09:25 Missing identifying attributes
11:03 Missing time attributes
12:20 Confusing attributes with values
15:06 One-directional relationship
16:59 Confusing parent and child attributes
19:13 Missing one-to-many relationships
22:20 Mixing up modelling notations
23:47 Confusing metrics and attributes

The video covers 13 common errors that beginners make when defining entities, attributes and relationships, and how to correct them and create more professional ER Diagrams.

#erd #erdiagram #datamodeling #datamodel #ERModel #EntityRelationshipModel #dataarchitect #dataanalyst

Contact Yulia directly for training, business analysis and analytics practice development: [email protected]

Have you watched this? How To Create a Conceptual Data Model:    • How to Create a Conceptual Data Model  

How to create business models - Pictures Speak playlist:    • Pictures Speak  

Modelling best practices - Clarity, Consistency, Conciseness: https://why-change.com/2020/04/13/mod...

Templates and downloads: https://shop.why-change.com/collectio...

Recommended mini-course by Yulia:
Business Analysis Career: Resume and Interview Crash Course https://courses.why-change.com/course...

💭 Website: https://why-change.com
💭 Subscribe to the Why Change channel and hit the bell to receive all the updates:    / @whychange  
💭 Connect with Yulia on LinkedIn:   / yulia-kosarenko  
💭 Get your copy of the book Business Analyst: a Profession and a Mindset: https://www.amazon.com/dp/199912202X​​
💭 Courses: https://courses.why-change.com/course...
💭 Training programs: https://why-change.com/corporate-trai...
💭 Why Change blog: https://why-change.com/blog/​​
💭 Publications: https://why-change.com/publications/​​
💭 Corporate consulting: https://why-change.com/consulting-ser...
💭 Webinars: https://why-change.com/speaking/​​
💭 Book me for speaking: mailto:[email protected]
💭 About: https://why-change.com/about