Databases: Normalization example

Поделиться
HTML-код
  • Опубликовано: 12 янв 2025

Комментарии • 19

  • @TheTCPTalk
    @TheTCPTalk 10 месяцев назад +5

    I am preparing for a database exam right now and I just truly want to thank you for these videos the! the professor I have truly has messed up this subject for everybody in the class with very stupid examples he goes into politics, dating and all sorts of boomer examples because i guess he thinks that's "funny" to explain any simple concepts but these videos are phenomenal and now I finally understand everything I need for the exam! wishing you all the best!!

  • @charltondsouza9140
    @charltondsouza9140 3 месяца назад +2

    I think this is the only video anyone needs to watch for normalization

  • @aseatatthetablepodcast-wha1952
    @aseatatthetablepodcast-wha1952 2 года назад +3

    This is the most I have ever understood normalization thanks

  • @mohamedatallah7845
    @mohamedatallah7845 Год назад +4

    Hi, very good example and soo easy, but in Sales table you have composite key ( OrderNo and ProductNo) good job

  • @SneakyThew
    @SneakyThew 10 месяцев назад +1

    well done; you have fortunate students

  • @gnerjgvnskvdvnj
    @gnerjgvnskvdvnj 6 месяцев назад +1

    Great explanation

  • @kismatkc4245
    @kismatkc4245 2 года назад

    You explained in very good way thanks.

  • @ritwikgossain
    @ritwikgossain 11 месяцев назад

    This was very useful, thanks :)

  • @anmolratnapgol5328
    @anmolratnapgol5328 Год назад +1

    well explained

  • @martdiamond9633
    @martdiamond9633 5 месяцев назад

    Why are there similar values in the product id. As one of the composite keys.

  • @rohan_zaidy4234
    @rohan_zaidy4234 5 месяцев назад

    Well explained

    • @Ibn_Eldora
      @Ibn_Eldora 4 месяца назад

      I read it as indian say 😂😂

  • @MamaSashin
    @MamaSashin Год назад +2

    but the customer ID is null there are no values inside. .Please help

    • @zaidi7336
      @zaidi7336 Год назад

      Yess tell me this

    • @sobreinakentish8164
      @sobreinakentish8164 Год назад

      You would use a surrogate key in your design I.e is a made up key.

  • @youtubeprotv-t6v
    @youtubeprotv-t6v 9 месяцев назад

    Acc to me ORDER(OrderId ,OrderDate, CustomerID) this also should be correct . As we can take one attribute common .

  • @Lizini
    @Lizini 2 года назад

    Thanks :D

  • @cheto9560
    @cheto9560 9 месяцев назад

    tysm

  • @junaramarandhara1489
    @junaramarandhara1489 2 года назад

    3.5