In this tutorial, you'll learn how to build a logical design from scratch using DbSchema - including entities, attributes, relationships, normalization (1NF to 3NF), naming rules, and more.
Perfect for beginners or anyone who wants to design clean, structured databases before deploying them.
🔗 Try DbSchema: https://dbschema.com/
📝 Full article: https://dbschema.com/blog/design/logical-design-for-databases/
0:00 Introduction
0:16 What is Logical Design?
0:32 Start a Logical Design using DbSchema
0:55 Create Entities &, Attributes with Data Types
2:04 Define Relationships
2:29 Non-Identifying - One to Many Relationship
3:09 Identifying - One Relationship
3:57 Many-to-Many Relationship
4:50 Normalization Explained
5:25 1NF - First Normal Form
6:04 2NF - Second Normal Form
7:08 3NF - Third Normal Form
8:00 Naming Dictionary
8:56 Conversion Dictionary
9:56 Comments & Tags in Logical Design
10:36 Git Integration, Multiple Diagrams, HTML5 Documentation
11:31 Convert to Physical Model
12:08 Download DbSchema for free
#DatabaseDesign #DbSchema #LogicalDesign #SQL #NoSQL #Database #erdiagram