Database Design 30 - Simple Key, Composite Key, Compound Key

Поділитися
Вставка
  • Опубліковано 9 лют 2025

КОМЕНТАРІ •

  • @corriedotdev
    @corriedotdev 9 років тому +7

    what three years of uni made me debate you successfully taught in 5 mins. I appreciate the video guides. Thanks man!

  • @RickR22
    @RickR22 8 років тому +16

    dude for some reason i like your vids ... you like that guy in class you ask a quick question cos i didnt hear what the lecturer said so now i need a crash course LOL and your dry humour kills me haha

  • @codebreakthrough
    @codebreakthrough  10 років тому +1

    Learn about Simple Keys, Composite Keys and Compound Keys by watching this Database Design video!
    buff.ly/1oiTySV

  • @wmcapunoify
    @wmcapunoify 9 років тому +2

    Thank you for this video, this was very helpful and the topic gives me a clear understanding.

  • @Onizukaash
    @Onizukaash 2 роки тому

    Your intro is kind of primary key👀

  • @cmjackson26
    @cmjackson26 10 років тому +1

    Thank you Caleb! This was super helpful! I was searching through Access help files and what I found wasn't nearly as good as your examples. Thanks!

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

    Thank you caleb. This is so well explained

  • @TheKDAProductions
    @TheKDAProductions 9 років тому +3

    To skip for compound key: 6:35

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

    Very Well Explained , I like the way you Explain it especially using chalk Adds the effect of Interest since everybody uses marker and they move tooic very quickly , Using chalks gives me time to absorb of what u said 👍.

    • @kamilo1175
      @kamilo1175 4 роки тому +1

      Lol try online where the teacher zooms around on excel.

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

      @@kamilo1175 hahah , I have been through thay experience . When Teacher comes back to the slides second time i cant even remember if he taught it before 😅

  • @imran_ashraf
    @imran_ashraf 10 років тому

    Hi Caleb, when is it wise to use/not to use a surrogate key in a intermediary table? can you please give the pro and cons? can you please make a video on this? Thanks buddy

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

    Really helpful vid, thanks for making it!

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

    What is the friking annotation for compound key and do I need to put it on a normalization form? the annotation is like a well hidden secret!

  • @enjoyyourvideos7245
    @enjoyyourvideos7245 7 років тому +2

    what a nice duster lol

  • @rodrigosilveira6886
    @rodrigosilveira6886 8 років тому +1

    If email would always need to be unique, why would you composite the key on (fn + ln + email) instead of just using the email?

    • @ayubsharif7359
      @ayubsharif7359 8 років тому +1

      lets say the email is not unique. then it has to be composite, its just an example my friend :)

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

      Rodrigo Silveira Very well said 😂👍

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

    Can I use a composite unique key?

  • @3litepker
    @3litepker 10 років тому

    CalebTheVideoMaker2 9:40 - I'll prove that wrong for you ;)

    • @sudhagunamgari9602
      @sudhagunamgari9602 8 років тому

      +3lite can you explain me why is it a wrong example? @9.40

  • @3litepker
    @3litepker 10 років тому

    +CalebTheVideoMaker2 9:40 - I'll prove that wrong for you ;) - see

  • @mahmoudabukhadier5605
    @mahmoudabukhadier5605 9 років тому

    I don't know why but it bothers me that your chalk is so small, otherwise good video.

  • @javar1987
    @javar1987 8 років тому

    i like your eraser.. :)

  • @moavazkhokhar5095
    @moavazkhokhar5095 9 років тому +1

    your explanation is hard to digest. lol .

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

    he makes me confused

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

      Look at textbook. Easier and more comprehensive.

  • @Que2701
    @Que2701 9 років тому +7

    This is what happens when you just record without preparing. -1

    • @codebreakthrough
      @codebreakthrough  9 років тому +13

      Tumelo M. Motloutsi The sad thing is I prepared for like 2-3 months for this series. lol

    • @Que2701
      @Que2701 9 років тому +3

      CalebTheVideoMaker2 lol++ liar liar pants on fire. don't you mean it took you 2-3 months to come up with better example of a composite key in M:N relation? o_O

    • @minhtao9774
      @minhtao9774 7 років тому +4

      You did great, don't even sweat it!

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

      You prepared for 2-3 months, but did you do any actual work?

  • @asifnawaz-lk7uu
    @asifnawaz-lk7uu 7 років тому +1

    don't do extra over acting