Перейти к содержимому

ER Diagrams in Lucidchart: How to create an ER diagram in Lucidchart.

Coding Coach

0:00 / 0:00

ER Diagrams in Lucidchart: How to create an ER diagram in Lucidchart.

2 124 просмотра · 6 л. назад
Coding Coach
6,54 тыс. подписчиков
2 124 просмотра · 6 л. назад
This video builds off what we learned in our database design video by creating an actual data schema (Entity Relationship Diagram or ERD) in a free tool called Lucidchart. We explore to create an ER diagram in Lucidchart using a real project as a example schema. This video uses common real world examples including: Many to many user and role relationships How to handle multi-tenant databases How to break down complex requirements into relationships! I also use the opportunity of breaking down a large real world problem to solve (Creating an indoor localization software using BLE beacons for a multi-tenant cloud based product) to show how we can translate complicated requirements to database design. If you have not seen it already or are unfamiliar with the concepts behind database design, please start with this video:    • How to Design a Database Schema: Creating ...   I also have videos on normalization, Boyce Codd Normal Form, 1st, 2nd and 3rd Normal form: Normalization:    • 4.3.0 Database Normal Forms: 1NF, 2NF, 3NF...   1NF:    • 4.3.1 1NF (First Normal Form): Step by Ste...   2NF:    • 4.3.2 2NF (Second Normal Form): Step by St...   3NF:    • 4.3.3 3NF (Third Normal Form): Step by Ste...   We do not review creating your lucidchart account or creating the free educational account (make sure to use your .edu email address!). This video is part of a database course that you can find here:    • {DBMS - Database Management Systems - series}   Please like this video and subscribe and would like to see more like it!    / @codingcoach   Here are the slides used in the design video: https://drive.google.com/file/d/1XA_T... Book used in this course: Garcia-Molina, Hector. Database systems: the complete book. Pearson Education India, 2008. https://www.amazon.com/Database-Syste...