MySQL 21 - 3NF

Поділитися
Вставка
  • Опубліковано 23 жов 2024

КОМЕНТАРІ • 23

  • @wanderborn.
    @wanderborn. 6 років тому +19

    Great presentations. Detailed, informative, humorous and very short (not boring) all at once. Definitely you have a talent for that. Thanks a lot!

  • @mirkodemagistris2803
    @mirkodemagistris2803 3 роки тому +2

    Thanks a million Caleb very well explained. You are really good in this and you helped me a lot in understanding transitive dependencies, where my uni book took 3 pages to describe it 🤷‍♂️. Thanks again.

  • @TheJupiteL
    @TheJupiteL 6 років тому +6

    Always got confused learning normalizations back in uni, can't believe they're this simple.

  • @bunburyLZD
    @bunburyLZD 3 роки тому

    SO thankful for you!!

  • @tusharniras
    @tusharniras 7 років тому +5

    Nice Video chain... thank you! It helped me a lot ..

  • @redx12ae33
    @redx12ae33 3 роки тому

    great video
    I also find it interesting that even nature is telling us that a direct connection with the Determinant is best and not a Transitive Dependancy where we connect with the Determinant through other Attributes.
    Basically, its best to connect to God directly and not through any other people or entities.
    Sorry I know most of y'all dont really wanna hear this but I just wanted to share it.
    Peace

  • @majicMix911
    @majicMix911 Рік тому

    Just passed my exam pre-test because of you sir. Thanks homie.

  • @matthewmarcus1849
    @matthewmarcus1849 7 років тому +1

    Great Video, I liked it even though I am not even studying SQL / databases now.

  • @expansivegymnast1020
    @expansivegymnast1020 3 роки тому

    You are amazing for this.

  • @laurent4147
    @laurent4147 3 роки тому

    bro you're saving my ass (i hope) for upcoming exams.
    not all heros wear capes

  • @randb9378
    @randb9378 5 років тому +1

    so transitive dependency says that no column must depend on a non-primary key

  • @St0ner1995
    @St0ner1995 5 років тому +1

    doesn't category_description depend solely on the category? that should be a separate table with only one column in this one referencing that one
    unless of course, the category description does change even if the category stays the same
    I honestly would have picked this up in 1NF

  • @bencsikkrisztian98
    @bencsikkrisztian98 4 роки тому

    Amazing video, thank you!

  • @yasssh7835
    @yasssh7835 4 роки тому

    Thanks a lot!

  • @蹦太君-o4d
    @蹦太君-o4d 2 роки тому

    good explain!!!!!

  • @camillas3758
    @camillas3758 7 років тому

    Thanks a ton!

  • @mahmoud-fi2ul
    @mahmoud-fi2ul 4 роки тому

    Thank you , now we can say that there is a O-T-M relationship between categories and listings table ?

  • @alialsawaf750
    @alialsawaf750 6 років тому +2

    Shouldn't the category column in the listings table (after adding the categories table) be changed to category_id?

    • @codebreakthrough
      @codebreakthrough  6 років тому

      Any references should be _id. I didn't watch the video to see context, but if there is another table for categories then yes.

  • @cinithomas6902
    @cinithomas6902 4 роки тому

    Nice explanation

  • @blakefeucht960
    @blakefeucht960 5 років тому

    No videos on BCNF or 4NF?

  • @ashtreylil1
    @ashtreylil1 5 років тому

    what is 4nf?!

  • @andregomes2629
    @andregomes2629 6 років тому

    nicee