Converting an ER Diagram to a Relational Table (or Schema)

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

КОМЕНТАРІ • 361

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

    It was really precise. The main thing is that you have a pleasing calming voice. I would prefer if you go into more detail about a complex ER- Diagram with giving out the number of tables needed. Thanks for the explanation.

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

    This was a great video; very concise. I missed 2 days of class, and managed to learn almost everything I missed in 7min 40sec.

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

    This was really very helpful. The best part being that you were calm throughout the video. Thanks.

  • @kaustubh.sharma
    @kaustubh.sharma 6 років тому +14

    Clear explanation better than attending 2 hr lecture in college.Ty

  • @omar-vr1kg
    @omar-vr1kg 4 роки тому +11

    is it just me or her voice directly reaches my brain

  • @jaideeplobo6096
    @jaideeplobo6096 3 роки тому +89

    Finally done dbms exam 😁😁😁, this concept written perfectly

  • @perfect.computer_classes3507
    @perfect.computer_classes3507 Рік тому +2

    The explanation is definitely a good one, precise and easy to comprehend. Last but not the least very impressive and attractive handwriting! Just looking at the notes feels like studying..ahh! Amazing job, keep it up! Yes, u can deep dive into further more in-depth concepts related to complex ER diagrams and do explain discriminators once with a bit detailed explanation. Thank You!

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

    thanks a lot madam,i did not understand anything in class ,but here i understood everything

  • @mraziz3230
    @mraziz3230 5 років тому +4

    It's very helpful before my exam. Thank you very much.

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

    great voice and one of the best sound quality compare to other lectures video... nd thak you for explanation.

  • @vinayak8100
    @vinayak8100 5 років тому +2

    My professor (who is from German) has a very weird accent, and this topic has been haunting me - until now. Thanks a lot ma'am, I understood everything from this vid lecture.

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

      Glad to hear that I made this concept easy for you :) Thank you... Means a lot...

  • @omairmeer5875
    @omairmeer5875 Рік тому +1

    Very very helpful vedio, with best way of teaching.❤

  • @atharvaphadtare2151
    @atharvaphadtare2151 Місяць тому +1

    Thankyou. I’m preparing for gate 25. This really helped me

  • @fabs-dz3jz
    @fabs-dz3jz 5 років тому +1

    Thanks @Ritu Kpur Classes I have an exam tomorrow and I got my goal from this short video

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

    There is teacher hiding in you,you must have a bright future,god given gift🎁❤️

  • @anushreevirtualgaming226
    @anushreevirtualgaming226 2 роки тому +1

    Your voice and knowledge has really helped me to calm down my strees and solved many douts, keep up the good work

    • @ritukapurclasses1591
      @ritukapurclasses1591  Рік тому +1

      Glad to hear that! 😊

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

      Kuch jyada hi jalid reply aagaya , after 10 months, no issues got 8.57 CGPA in my 5th sem@@ritukapurclasses1591

  • @Andrewtate724
    @Andrewtate724 2 роки тому +1

    Landed to a perfect video I have a dbms exam on Wednesday

  • @shakeelakbar7
    @shakeelakbar7 4 роки тому +5

    It was very useful for my semester exams. Thank you

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

    ur voice ,explanation & writing is so beautiful .

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

    you really helped me a lot. and your voice is so calming. you just got a new subscriber and lots of likes

  • @piyushkumar-wg8cv
    @piyushkumar-wg8cv 4 роки тому +1

    Great, I have been searching for it for 30 minutes.

  • @tadiwanasheabelsampindi4615
    @tadiwanasheabelsampindi4615 5 років тому +3

    Short and precise. Found it more helpful, Thanks for the video!

  • @bandarurohitha572
    @bandarurohitha572 9 місяців тому +1

    super, simple explanation....this Single viedeo is enough for such a big concept....keep going mam. Now 1 am ur subscriber....by watching a single Viedeo of u

  • @jamespottex5197
    @jamespottex5197 5 років тому +12

    Sweet voice and sweetly explained...

  • @308_NishchayRaj
    @308_NishchayRaj 10 місяців тому +1

    5:06 "aaloo gobhi baigan leloooo" you can tell she was very irritated xd
    very articulated video thank you ma'am

  • @Random-gv5ln
    @Random-gv5ln 8 місяців тому +1

    Thank you very much for the video, i can see youve put a lot of though into it (especially the part where the street vendor interrupted you xD), its a very well articulated video, thank you.

    • @ritukapurclasses1591
      @ritukapurclasses1591  8 місяців тому +1

      Thank you so much for appreciating! Means a lot!!! 🥹

    • @Random-gv5ln
      @Random-gv5ln 8 місяців тому +1

      @@ritukapurclasses1591 just got back from my exam, it went amazing thanks to you! (I studied last minute yet still remembered everything you taught)

    • @ritukapurclasses1591
      @ritukapurclasses1591  8 місяців тому +1

      @@Random-gv5ln Really happy that I was able to help in some manner 😊

  • @SimpleLivingHigherThinking
    @SimpleLivingHigherThinking Рік тому +1

    Thanks I have my database design exam in 4 hours you saved me maam😁

  • @IronmannoxSGSG
    @IronmannoxSGSG 3 місяці тому +3

    Really nice explanation of the topic, thnx a lot !!!!!!!!!!!!!!!!!!!!

  • @shlokmantri799
    @shlokmantri799 Рік тому +1

    super awesome mam keep going !!! you tought better than my college lecturer !👍👍👍

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

    finally ! i got this topic. Watched many videos but were not able to understand it. Seriously ! it is very good ! It would be more beneficial if u upload a video solving a complete Er model to Relational Schema.

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

      Sure I'll do so. I'm glad it was that helpful to you :) Made my day... Thank you....

  • @abhishekkumartiwari3834
    @abhishekkumartiwari3834 3 роки тому +1

    Very helpful video and You've got a nice voice with beautiful writing..👍

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

    Clarity of Concepts done right

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

    This Hit my brain directly thank you... and that background voice you paused the video several times ye tu hoga When you livin in India or Pakistan 😂

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

    am just happy i can do my exam with peace next week.thanks mum.totally understood

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

    just subbed amazing video explained very clearly. I have been looking at a lot of videos in youtube yours is the best at explaining relational table.

  • @Twadi-maa-da-yar-1727
    @Twadi-maa-da-yar-1727 5 років тому +5

    Thankyou so so so much ritu... In just 8 min you cleared my concepts.... Your hands and voice so beautiful 😅

  • @ajitkumaryadav8298
    @ajitkumaryadav8298 4 роки тому +2

    thanks ma'am for the beautiful explanation...

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

    Thnku so much it really helped i think this would be the best explanation of this topic🤩🤩❤❤

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

      Thank you so much :)

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

      ❤❤❤❤❤❤what i said i literally mean it coz this video really helped me a lot.the night before my exam i was just scrolling the videos on UA-cam but luckily i found your video and i got this topic🔥🔥🤩🤩❤❤

  • @itsme-vn8ip
    @itsme-vn8ip 4 роки тому +1

    Thank you mam. It was really helpful.

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

    Thank you
    It was really helpful

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

    Explained Beautifully.. got all the concepts

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

    Great today is my exam and i prepared this i hope it will cover all the things

  • @yutaitadori7318
    @yutaitadori7318 3 роки тому +1

    U nailed it,🔥 awesome garllll

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

    Was very much helpful thank you so much mam

  • @JD-eb5qu
    @JD-eb5qu 2 роки тому +1

    It's very useful mam thanks a lot

  • @umeshpathak4558
    @umeshpathak4558 4 місяці тому +1

    Kya bat hai i like your voice ❤

  • @Darkness_to_light0
    @Darkness_to_light0 5 місяців тому +1

    Thank you so much mam tommarow is my Dbms exam..❤

  • @someotherstuffs
    @someotherstuffs 4 роки тому +2

    Thank you ma'am 😊U helped a lot!

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

    Excellent video, just subscribed 👍

  • @tejaskamat4528
    @tejaskamat4528 9 місяців тому +1

    you havent covered multivalued attributes, you just mentioned about composite and skipped to the weak entity. I hope you cover it since i was here for multivalued only.

    • @ritukapurclasses1591
      @ritukapurclasses1591  9 місяців тому +1

      its der in the video but i am creating a short individual video on it especially for you 🙂

    • @tejaskamat4528
      @tejaskamat4528 9 місяців тому +1

      @@ritukapurclasses1591 it's okay I already passed my exams ❤️

    • @ritukapurclasses1591
      @ritukapurclasses1591  9 місяців тому

      @@tejaskamat4528 Congratulations!!!

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

    Pretty good summary! Thanks!

  • @anishali8042
    @anishali8042 Рік тому +2

    Such a sweet voice

  • @vishalgupta7522
    @vishalgupta7522 Рік тому +3

    thank you mam tomorrow is my mid sem exam

  • @Aditya-zv5et
    @Aditya-zv5et Рік тому +1

    thankssss for this amazing video

  • @simantakasaju4514
    @simantakasaju4514 4 роки тому +2

    in weak entity pay number shoulb be underlined with dashed line bcoz it is partial key

  • @siddharth2520
    @siddharth2520 10 місяців тому +1

    Itni pyari awaj ho to lecture attend karunga hi mai

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

    Very helpful Mam. 🖒🖒🖒

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

    I really understood.... thank you so much.

  • @BATOOL_KHAN123
    @BATOOL_KHAN123 9 місяців тому +1

    Awesome job ❤️👍

  • @saugatktm181
    @saugatktm181 2 роки тому +1

    u have such a sweet voice di.

  • @PrabhjotSingh-bu3rq
    @PrabhjotSingh-bu3rq 2 роки тому +1

    Your voice...so sweet.

  • @demetridoes
    @demetridoes 3 роки тому +1

    Great explanation, thank you!

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

    Thank you so much.Keep up the good work

  • @abcd.8
    @abcd.8 Рік тому +1

    Your vocabulary is good

  • @a8hi_24__
    @a8hi_24__ 8 місяців тому +1

    Really helpful video..exam on 14may Covering 6 months syllabus in 10 days almost done only normalization process is tough nhi smj araa.

    • @ritukapurclasses1591
      @ritukapurclasses1591  8 місяців тому +1

      normalisation ki bhot sari videos hain channel pr. check the playlist and you can also post any of your doubts as comments. Happy Learning! 😊

  • @jaideeplobo6096
    @jaideeplobo6096 3 роки тому +3

    Soon exams are coming, I understand this correctly

  • @soapmactavish6001
    @soapmactavish6001 2 роки тому +1

    very calming voice

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

    you have very sweet voice

    • @osamasameer9204
      @osamasameer9204 6 місяців тому

      tharki, pharne aya tha tou pharhai kar na

  • @निर्माण-ष3ष
    @निर्माण-ष3ष 5 років тому

    I have understood all clearly thanks

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

    Can you answer this question:
    Q:design the relational schema for E-R diagram that you have drawn for part question
    enter about 5 sets of meaningful data in each of the relations
    identify the domain of various attributies

  • @MoeezSAEED-y9u
    @MoeezSAEED-y9u 3 місяці тому

    the best entertainment was *pheeri waly uncle *🤣

  • @ganesha.k.s
    @ganesha.k.s 5 років тому +1

    Thanks for this. It really helped me in one of my tests.

  • @Tiagoo-360
    @Tiagoo-360 6 місяців тому +1

    5:07 is hittin different

  • @निर्माण-ष3ष
    @निर्माण-ष3ष 5 років тому

    You have a nice voice which is very refreshing and touch my ❤️

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

    Great explaination thank you❤️

  • @mauscanio
    @mauscanio 4 дні тому

    4:13 command drop? are we in baldur's gate?

  • @omairmeer5875
    @omairmeer5875 Рік тому +2

    Kon kon paper sa pahla ya vedio dak Raha hay :)

  • @Ironman-ml3rc
    @Ironman-ml3rc Місяць тому

    Your voice is so sweet

  • @bhargavareddy8954
    @bhargavareddy8954 5 років тому +2

    it's really good

  • @chelsearoseantony993
    @chelsearoseantony993 5 років тому +2

    Thank you Soo much Ritu Mam it did work .....thank you very much

  • @se7en592
    @se7en592 Рік тому +1

    love the way how she's annoyed by the raddiwala XD

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

    1:50 i think you must create new table for multi valued with that attribute and the primary key. only mentioned composite attributes is mentioned

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

    Thank you it was great help

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

    A veryy Good lecture 👍👍 kEep it up !! 💖

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

    im sorry but that is noch correct what you said in 7:08, there should be two tables: Account(acc-no, balance) and branch (branch name, city, assets, acc-no (acting as foreign key))

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

      Yes you are right that it should return two entity set. But one more thing based in what you've said, if acc-no acting as foreign key after doing relationship, so the entity set still can't uniquely identify since there is no primary key?

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

      you are right, as Branch is a strong entity it should have one primary key.
      In three ways we can map 1:N or N:1 relationship to relation.
      1. Foreign key approach( as she did)
      2. Merged approach( in case of Total participation on both sides).
      3. Relationship relation. (creating a new relation for relationship)
      Assuming N:1 relationship between Account and Branch( as nothing mentioned, only Participation are given)
      In case of FK approach we add the PK of 1-side as a FK on N-side.(assuming BranchName as PK of Branch entity)
      Relations are : ACCOUNT(Acc.No(PK), Balance, BranchName(FK)).
      BRANCH(BranchName(PK),Br_city,Assets).

  • @ushanmadu4663
    @ushanmadu4663 Рік тому +1

    Thnk you. From 🇱🇰

  • @AutoNCar4U
    @AutoNCar4U 2 місяці тому +1

    aapki voice 🥰🥰

  • @sushantkr420
    @sushantkr420 11 місяців тому +2

    Thank you ma'am❤

  • @KarthikKannan01
    @KarthikKannan01 2 роки тому +1

    In one to many or many to one, the entity whose is sending one to many is in total participation right?
    Or will the entity which is many will be in total participation?

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

    good work can you explain if the relationship have attribute in next video

  • @computergeek8617
    @computergeek8617 4 роки тому +2

    Thanks mam for this video I have one doubt what if in 1:M and M:1 we have total participation from both the sides in that case what we should we add in the relational schema ?

  • @kunnalgupta3264
    @kunnalgupta3264 2 роки тому +1

    tnku soo much mam English notes to badiya hai but hindi me thoda describe kiya kijiye mam..

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

    Great voice🤩🤩

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

    Thans.....very help full

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

    4:23 have you uploaded the video .Can i have that link??

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

    Thank you for this video mam

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

    thanks ...
    very helpful

  • @aslanmusic547
    @aslanmusic547 7 місяців тому +1

    Thank you so much!

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

    why was customer-loan relationship taken as example for many to many? isn't it one to many as one loan can be taken by one customer only?
    or is there a joint loan type of scheme taken into consideration
    though the conversion to relational table is right for many to many. thanks.

  • @kanji689
    @kanji689 10 місяців тому +1

    What about the multivalued attribute how do we write them ?