DBMS 8: Converting ER Diagrams into Tables with Example | ER Model | DBMS Tutorial for Beginners

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

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

  • @shanthapriyamanikandan4756
    @shanthapriyamanikandan4756 2 года назад +30

    totally 7 tables should be there isn't it, bcuz acc to the rule many to many relationship has to have a seperate table for relationship as well ryt ?

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

      Not 7 tables..! 7 rules are there!

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

      yes I guess u r right at last the final table is wrong I guess
      Bcz m:n relation have three tables

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

      may be total 7 tables

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

      Also in the subject we should have lecture id and course id

    • @zainkhanz1
      @zainkhanz1 6 месяцев назад

      yes you are right

  • @dipayankanrar1145
    @dipayankanrar1145 Год назад +3

    very simple and easy explanation ,its very easy to understand

  • @stalinanthony
    @stalinanthony 8 месяцев назад +2

    Thank you so much maa'm it was very helpful

  • @rswm939
    @rswm939 Год назад +3

    Superb 😊👍👍... Clear and simple !! Pls make more !

  • @chandlerzhao181
    @chandlerzhao181 11 месяцев назад +1

    Very good video and easy to understand! 👍 ! I got a question about the last example, the M:N relationship between the students and lectures, also between the students and courses, but the logical model diagram does not present this. Do we need to present both the M:N relationship when we modling the data?

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

    Tq ma'am back paper test hai kal...
    This video helped me a lot

  • @Crazy_moments_of_footbal-qz1qr
    @Crazy_moments_of_footbal-qz1qr 6 месяцев назад +1

    you made it absolutely easy madam!!!!!!!!!👏👏👏👏👏👏👏👏👏

  • @vijaykhetre5678
    @vijaykhetre5678 2 года назад +4

    Nice teaching 😊👍

  • @Umais_Rasheed
    @Umais_Rasheed 27 дней назад

    6:00 Mam so we ignore the remaning attributes ?

  • @maryamakbar8772
    @maryamakbar8772 Год назад +3

    How can we solve if we have both maximum and minimum cardinality

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

    There must be primary for rollno and mobile no both in multivalued attribute

  • @AnkiitOp
    @AnkiitOp 2 года назад +2

    Case 3 and Case 4 way 01 is Similar ?

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

    Aabhari aahe 😊

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

    Very nice video 👍👍

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

    No questions, superb

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

    Firstly , the relationship is not possible between the entities if there is not even a single same attribute in each entity.

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

    Here we need to check data redundancy also know then how to check it ?

  • @Ashitha08
    @Ashitha08 5 месяцев назад +1

    7 tables should be there in the last eg

  • @milanstefanovic5090
    @milanstefanovic5090 6 месяцев назад +4

    Last table is not good, we have 2 M to N relationships, so we should have 2more Junction tables so instead of 4tables we should have 6

  • @sakshikhangar4819
    @sakshikhangar4819 7 месяцев назад +1

    Thank you so much

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

    Ma'am Jo ap ny example di table k sth ER diagram ki... Uski statement b bta dein kindly!!???.

  • @BluePaneTechnologies-nu4hh
    @BluePaneTechnologies-nu4hh 7 месяцев назад +1

    great...thnx

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

    thanks

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

    No 4 Explantion is not clear why leave out emp name,salary dept name

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

    thank you

  • @shivanshusawan423
    @shivanshusawan423 7 месяцев назад

    How to get slides

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

    What if there is no primary key?

  • @itsecurity2423
    @itsecurity2423 8 месяцев назад +1

    mam you are confusing the students in explaining rule No4, you are not explaining completely. kindly avoid confusion in your videos plz

    • @sakshiarya2991
      @sakshiarya2991 3 месяца назад

      @@itsecurity2423 bhai confuse ki baat kya dono trike he represent krne ke

  • @MJ.bucketlist_
    @MJ.bucketlist_ 10 месяцев назад +1

    Mam..you left age?

  • @harishwarreddy7628
    @harishwarreddy7628 Год назад +5

    worst explanation

  • @Bright-Plans
    @Bright-Plans Год назад +1

    💝

  • @amirhosein5677y
    @amirhosein5677y Месяц назад +1

    Thanks