Entity Relationship Diagram (ERD) Tutorial - Part 2

Ғылым және технология

Learn how to create an Entity Relationship Diagram with Primary Keys, Foreign Keys, and Composite Keys in this advanced ERD tutorial. We provide step-by-step training on how to identify these different keys, as well as helpful information on bridge tables, data types, and how your ER Diagram relates to a database management system.
A Primary Key is an attribute (or field) that uniquely identifies every record in a certain table. There’s one Primary Key per entity, and they must be unique, never-changing, and never-null. You note a Primary Key in your Entity Relationship Diagram with “PK” to the left of the appropriate attribute.
A Foreign Key is an attribute in one entity that links to the Primary Key of another entity. Consequently, they enable relationships between those entities. There can be multiple foreign keys per entity, or none at all. You note a Foreign Key in your ERD with “FK” to the left of the appropriate attributes.
--
00:00 Overview
0:32 Recap from ERD Part 1
00:51 Primary Keys
00:56 Primary Key Examples
1:54 Primary Key Rules
5:43 Lucidchart
6:06 Foreign Keys
7:43 Foreign Key Rules
8:20 Composite Primary Keys
10:11 Composite Primary Key Rules
10:46 Bridge Tables
12:50 I've finished my ERD. Now what?
14:19 Wrap Up
--
Learn more at: training.lucid.co
Sign up for free at: www.lucid.co
Follow us:
Facebook: / lucidsoftware
Twitter: / lucidsoftware
Instagram: / lucidsoftware
LinkedIn: / lucidsoftware

Пікірлер: 89

  • @muriyadanthomson
    @muriyadanthomson7 ай бұрын

    Best explanation of ERDs on the internet! Thank you! 🙌

  • @rishitratan8460
    @rishitratan84607 ай бұрын

    The CSV to ER diagram functionality in Lucid Chart is huge! Such a simple yet useful idea.

  • @timhendriks3224
    @timhendriks32245 ай бұрын

    insanely good video, even helped me for my data mining course just to revisit the basics

  • @drchid
    @drchid3 ай бұрын

    The fact it can convert the diagram to code to create the tables! And to be able to do it in reverse from database to diagram! That is awesome and such a big time saver🙏🏾 thank you 😊

  • @simhthmss
    @simhthmss5 ай бұрын

    Please make more "lucid explains the internet" videos. Such as the snek and doggo videos. These are still being shared around social media to this day.

  • @kox8088
    @kox80886 ай бұрын

    what a flippin legend this guy is!!

  • @popspie
    @popspie7 ай бұрын

    Loved this explanation. Super clear

  • @hassanaliomurdad5779
    @hassanaliomurdad57794 ай бұрын

    You got a new subscriber with this video. Kudos to you!

  • @diderdubois
    @diderdubois3 ай бұрын

    I've worked on thousands of databases, yet I watched both parts with laser focus. The quality of this content is simply incredible. I wish I had access to that when I started out.

  • @DBSQ-wb3ht

    @DBSQ-wb3ht

    3 ай бұрын

    I'm starting out now, technically I'm making my second database, but my first only needed one table, my next one, it won't be so simple. Love youtube!

  • @diderdubois

    @diderdubois

    3 ай бұрын

    @@DBSQ-wb3ht That's the way to go man, keep it up.

  • @akshaykhandve4297
    @akshaykhandve42974 ай бұрын

    You save my day, thanks man 🎉

  • @adrianCoding
    @adrianCoding2 ай бұрын

    Thanks! very clear tutorial

  • @benaya6
    @benaya65 ай бұрын

    a great explanation, as always. one thing is missing for me - the relationship between entities(other than the quantitative you mentioned), and dependant entities and their notation. thanks alot!

  • @lovetheentertainment9949
    @lovetheentertainment99497 ай бұрын

    Make a full course It will be easy to follow in a structured way

  • @camilotello3296
    @camilotello3296Ай бұрын

    I loved this!!!

  • @adisatic
    @adisatic5 ай бұрын

    Such a boss. Great tutorial man

  • @cryptoWorldever
    @cryptoWorldever4 ай бұрын

    what a great piece of software it is. thanks very much sir

  • @DeKiesel
    @DeKiesel7 ай бұрын

    THANK YOU SO MUCH! I always used the export button in the right panel (it is much more prominent) and I found it so annoying to have to export all tables one by one.

  • @ericrobbins6953
    @ericrobbins69533 ай бұрын

    Thank you, this is great content

  • @mk17173n
    @mk17173n4 ай бұрын

    I like this guy. He explains everything really well and he is a big dude named Bear. As a fellow big dude i appreciate his name lol.

  • @dcatmakas
    @dcatmakas5 ай бұрын

    thank you a lot for this perfect video..

  • @Kumar-bg6nr
    @Kumar-bg6nr18 күн бұрын

    thanks to my man Bear for providing us this valuable information

  • @user-ev3cg9yx4p
    @user-ev3cg9yx4p5 ай бұрын

    thank you!! next part 3

  • @escobol
    @escobol3 ай бұрын

    this was really helpful thank you

  • @enockrotich4270
    @enockrotich4270Ай бұрын

    this is really helpful. Keep up the good work

  • @user-iz7ej1fn9f
    @user-iz7ej1fn9f2 ай бұрын

    Thank you.

  • @GbotemiAdeoye-iw8xt
    @GbotemiAdeoye-iw8xt15 күн бұрын

    Love this

  • @SunshineBurrito
    @SunshineBurrito6 ай бұрын

    We need more charts!!! We miss the charts :(

  • @mohammadalwahsh8449
    @mohammadalwahsh84497 ай бұрын

    TYSM!

  • @matyasblaha7302
    @matyasblaha73024 ай бұрын

    awesome! awesome! awesome!! Thank you! :)

  • @wew7930
    @wew79306 ай бұрын

    Bro uve explained it much better than my teacher

  • @tamimnorani
    @tamimnorani3 ай бұрын

    Very good video my guy

  • @necipoksuz9997
    @necipoksuz9997Ай бұрын

    Thanks

  • @Ethan_1422
    @Ethan_14226 ай бұрын

    If you do any requests/suggestions: may I suggest more sneke videos?

  • @waadturki2359
    @waadturki23592 ай бұрын

    We need a 3rd part about normalization 🥹🥹

  • @safiharisna8824
    @safiharisna88247 ай бұрын

    Thank you for your explanation! how about alternate key and candidate key??

  • @StudywithmeinPakistan
    @StudywithmeinPakistan2 ай бұрын

    Thanks i just saw the lucid chart

  • @BenCorvo-iy1nc
    @BenCorvo-iy1ncАй бұрын

    that was 900 pages of book summarized, thanks a lot

  • @OfficialSylvantianAUTTPforces
    @OfficialSylvantianAUTTPforces7 ай бұрын

    Please make the internet names ads again

  • @StudywithmeinPakistan
    @StudywithmeinPakistan2 ай бұрын

    Best animation on the topic. I will recommend it to my students in Pakistan. Can you tell me the software in which you make these animations . They are so cool.

  • @biomagician
    @biomagician5 ай бұрын

    Hello, and thank you for the great video! Where should I store the meaning of each column? Is it possible to add a 4th column to each table in a second toggable layer? Or should I store the column meanings in a different document in Lucidchart? Or in a different software altogether? Thanks for your insight!

  • @jacobluttrull1470
    @jacobluttrull1470Ай бұрын

    wish wgu used this software for our SQL course

  • @vansree
    @vansree6 ай бұрын

    I imported an existing SQL Server tables into the ER diagram using TSV export. CSV export is not doing the relationships, so did TSV. Great, it works! a) I placed each entity by clicking. Is there a way to add multiple tables at a single shot? (like ctrl select) b) I have over 80 tables and once placed very hard to find an entity. Is there a way to search the entity on the canvas/diagram? I see shapes pane and by clicking the name, it places one more entity in the canvas, which is not what I am looking for... c) Any techniques for senior data modelers? TIA

  • @ryndm
    @ryndm6 ай бұрын

    Isn't the Shipment table a bridge table too?

  • @smallyfry15941
    @smallyfry159416 ай бұрын

    i miss those animal chart stuff...

  • @OSMRDucksLIB
    @OSMRDucksLIB6 ай бұрын

    Explain panda chikens

  • @havefun5519
    @havefun55192 ай бұрын

    So, could only be exported SQL database, how about no SQL database? though it's not a relationship database, however, actually ERD is convenient for get idea what the database structure.

  • @Emad-1st
    @Emad-1st7 ай бұрын

    hello , can i know where did u get the excel sheet or how do i get it

  • @KarMa-ws3ll

    @KarMa-ws3ll

    7 ай бұрын

    u can google free excel or csv example data

  • @Emad-1st

    @Emad-1st

    7 ай бұрын

    @@KarMa-ws3ll that specific one is in my lectures that is why i need it the source

  • @IceTeaCrackHead
    @IceTeaCrackHead2 ай бұрын

    🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

  • @pineapplepineapple4725
    @pineapplepineapple47257 ай бұрын

    i miss the sneks

  • @seobizhub9116
    @seobizhub91165 ай бұрын

    So a ssn can be considered a primary key...

  • @tranquillity5437
    @tranquillity54374 ай бұрын

    Anyone reading this please answer, i dont have database in csv? how should i import database

  • @nithinkrishna1183
    @nithinkrishna11834 ай бұрын

    great explanation, I feel composite primary key concept is total waste, instead we can create a primary key and keep it very simple.

  • @UzmaScholarSphere
    @UzmaScholarSphere11 күн бұрын

    I am student of BSCS so, I have to make a project assignment "Design Document" on "Online mobile showroom app" Can any body help me to make ERD?.................I tried myself but I am confused to draw relationship between entities..

  • @asmaal-faqueeh8353
    @asmaal-faqueeh8353Ай бұрын

    how do if it is an embedded documents.. like comment collection in post

  • @jamwithjude2545
    @jamwithjude254513 күн бұрын

    I did'nt get the bridge table

  • @robtelford1988
    @robtelford19887 ай бұрын

    I feel like I should point out that at 4:18, Customer_ID is not 'randomly assigned', it's sequentially assigned. ;-) /pedantMode

  • @gregsmith8977
    @gregsmith89774 ай бұрын

    you guys should go back to your advertising from 4 years ago. it was kind of sad to discover this gem of a channel with the old ads, and then look and see that it's just a generic corporate channel now :( where snek?

  • @AnakMarzook
    @AnakMarzook6 ай бұрын

    your customer to order relationship is wrong , it should be one to many

  • @ntiuakiatoa7667

    @ntiuakiatoa7667

    2 ай бұрын

    Why is that?

  • @JXSeaton
    @JXSeaton5 ай бұрын

    Please fix this video to include the correct relationships. order to product is a many to one relationship.

  • @JXSeaton

    @JXSeaton

    5 ай бұрын

    Also the customer id is auto-incrementing NOT random

  • @NoBloons
    @NoBloons4 ай бұрын

    I miss your funny videos.

  • @Felix-Floof
    @Felix-Floof5 ай бұрын

    Someone called challenger1534 reposted your snake video.

  • @manofredearth
    @manofredearth4 ай бұрын

    So you started turning off comments? What is up with this train wreck of public engagement?

  • @johnsonwu4745
    @johnsonwu47454 ай бұрын

    I miss

  • @mohammednajeb3716
    @mohammednajeb37167 ай бұрын

    Free Palestine 🇵🇸

  • @Tocsiman

    @Tocsiman

    7 ай бұрын

    ???? Free Israel

  • @mohammednajeb3716

    @mohammednajeb3716

    7 ай бұрын

    @@Tocsiman free of what?! Israel isn't invaded so as to be freed!

  • @agamixx637

    @agamixx637

    7 ай бұрын

    @@Tocsimanאני מת

  • @agamixx637

    @agamixx637

    7 ай бұрын

    @@mohammednajeb3716bro all you do is bomb us and say allah Akbar

  • @Tocsiman

    @Tocsiman

    7 ай бұрын

    @@mohammednajeb3716 need to be freed from hamas’s terror and all the other Arab countries surrounding it

Келесі