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.
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!
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.
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
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.
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.
❤❤❤❤❤❤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 RUclips but luckily i found your video and i got this topic🔥🔥🤩🤩❤❤
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.
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
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))
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?
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).
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?
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 ?
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.
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
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.
HAHAHAHHA
siiiimmmpppp
@@aryanmenon995 bitch that's called appreciation:)
Line maar rha bkl.
This was a great video; very concise. I missed 2 days of class, and managed to learn almost everything I missed in 7min 40sec.
Thanku :) Means a lot :)
6 years .. hope you are working for miscrosoft now
This was really very helpful. The best part being that you were calm throughout the video. Thanks.
Thank you for the positive feedback :)
Clear explanation better than attending 2 hr lecture in college.Ty
Thank you :) Means a lot...
is it just me or her voice directly reaches my brain
Thank you 😊
Finally done dbms exam 😁😁😁, this concept written perfectly
Great 🙂
Tomorrow is mine☺
@@ssrinivas9721 all the best
Impressive......
@THE HIN BOY 👽 try to cover all the answers, never give up. All the best
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!
thanks a lot madam,i did not understand anything in class ,but here i understood everything
It's very helpful before my exam. Thank you very much.
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.
Glad to hear that I made this concept easy for you :) Thank you... Means a lot...
great voice and one of the best sound quality compare to other lectures video... nd thak you for explanation.
Very very helpful vedio, with best way of teaching.❤
Glad to hear that 😊
Thankyou. I’m preparing for gate 25. This really helped me
Thanks @Ritu Kpur Classes I have an exam tomorrow and I got my goal from this short video
There is teacher hiding in you,you must have a bright future,god given gift🎁❤️
Thank you so much for your wishes... Means a lot to me...
Your voice and knowledge has really helped me to calm down my strees and solved many douts, keep up the good work
Glad to hear that! 😊
Kuch jyada hi jalid reply aagaya , after 10 months, no issues got 8.57 CGPA in my 5th sem@@ritukapurclasses1591
Landed to a perfect video I have a dbms exam on Wednesday
It was very useful for my semester exams. Thank you
ur voice ,explanation & writing is so beautiful .
Thank you so much 🙂
you really helped me a lot. and your voice is so calming. you just got a new subscriber and lots of likes
Thank you so much dear... Means a lot...
Great, I have been searching for it for 30 minutes.
Glad I could help :)
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
Thank you so much 🙂
Short and precise. Found it more helpful, Thanks for the video!
Thank you... Means a lot..
Sweet voice and sweetly explained...
yeah right!!
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.
Thank you so much for appreciating! Means a lot!!! 🥹
@@ritukapurclasses1591 just got back from my exam, it went amazing thanks to you! (I studied last minute yet still remembered everything you taught)
@@Random-gv5ln Really happy that I was able to help in some manner 😊
5:06 "aaloo gobhi baigan leloooo" you can tell she was very irritated xd
very articulated video thank you ma'am
Thanks I have my database design exam in 4 hours you saved me maam😁
All the best!
super awesome mam keep going !!! you tought better than my college lecturer !👍👍👍
Thanks a lot 😊
Really nice explanation of the topic, thnx a lot !!!!!!!!!!!!!!!!!!!!
@@IronmannoxSGSG thanku 😊
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.
Sure I'll do so. I'm glad it was that helpful to you :) Made my day... Thank you....
Very helpful video and You've got a nice voice with beautiful writing..👍
Thank you so much 🙂
Clarity of Concepts done right
Thank you 😊
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 😂
Thank you 😊
am just happy i can do my exam with peace next week.thanks mum.totally understood
Thank you...
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.
Thank you so much... Means a lot...
Thankyou so so so much ritu... In just 8 min you cleared my concepts.... Your hands and voice so beautiful 😅
thanks ma'am for the beautiful explanation...
Thnku so much it really helped i think this would be the best explanation of this topic🤩🤩❤❤
Thank you so much :)
❤❤❤❤❤❤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 RUclips but luckily i found your video and i got this topic🔥🔥🤩🤩❤❤
Thank you mam. It was really helpful.
Most welcome 😊
Thank you
It was really helpful
Explained Beautifully.. got all the concepts
Great today is my exam and i prepared this i hope it will cover all the things
How was your exam then 😂?
How was your exam bro? I have a test tomorrow. -_-
U nailed it,🔥 awesome garllll
Thank you 😊
Was very much helpful thank you so much mam
It's very useful mam thanks a lot
Thank you for appreciating 😊
Kya bat hai i like your voice ❤
Thank you so much mam tommarow is my Dbms exam..❤
thank you 🙏😍
Thank you ma'am 😊U helped a lot!
Thank you 😊
Excellent video, just subscribed 👍
Welcome aboard! Thank you so much 😊
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.
its der in the video but i am creating a short individual video on it especially for you 🙂
@@ritukapurclasses1591 it's okay I already passed my exams ❤️
@@tejaskamat4528 Congratulations!!!
in weak entity pay number shoulb be underlined with dashed line bcoz it is partial key
thank you mam tomorrow is my mid sem exam
Pretty good summary! Thanks!
Such a sweet voice
thankssss for this amazing video
Most welcome 😊
Itni pyari awaj ho to lecture attend karunga hi mai
I really understood.... thank you so much.
Thank you for your appreciation 🙂
Very helpful Mam. 🖒🖒🖒
Awesome job ❤️👍
Thank you! Cheers!
u have such a sweet voice di.
Thank you :)
Your voice...so sweet.
Great explanation, thank you!
Thank you 😃
Thank you so much.Keep up the good work
Thank you...
Your vocabulary is good
Thanks 😊
Really helpful video..exam on 14may Covering 6 months syllabus in 10 days almost done only normalization process is tough nhi smj araa.
normalisation ki bhot sari videos hain channel pr. check the playlist and you can also post any of your doubts as comments. Happy Learning! 😊
Soon exams are coming, I understand this correctly
Thank you for the appreciation :)
very calming voice
Thank you 😊
you have very sweet voice
tharki, pharne aya tha tou pharhai kar na
I have understood all clearly thanks
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
the best entertainment was *pheeri waly uncle *🤣
Thanks for this. It really helped me in one of my tests.
5:07 is hittin different
You have a nice voice which is very refreshing and touch my ❤️
Great explaination thank you❤️
Kon kon paper sa pahla ya vedio dak Raha hay :)
Your voice is so sweet
it's really good
Thank you Soo much Ritu Mam it did work .....thank you very much
love the way how she's annoyed by the raddiwala XD
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
Thank you it was great help
Happy to help...
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))
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?
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).
A veryy Good lecture 👍👍 kEep it up !! 💖
Thnk you. From 🇱🇰
You are welcome 😊
aapki voice 🥰🥰
Thank you ma'am❤
Most welcome 😊
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?
good work can you explain if the relationship have attribute in next video
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 ?
tnku soo much mam English notes to badiya hai but hindi me thoda describe kiya kijiye mam..
Thans.....very help full
4:23 have you uploaded the video .Can i have that link??
Great voice🤩🤩
Thank you for this video mam
Glad to help...
Thank you so much!
You're welcome!
What about the multivalued attribute how do we write them ?
Posted the mva video
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.
What if we have a relation 1:N with r
Total participation on the 1 side
thanks ...
very helpful