DBMS - Weak Entity Set with Total Participation Watch more Videos at www.tutorialsp... Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited
Thanks! I know this is pretty basic stuff, but it's still pretty hard to understand when you're a beginner. You explained it very clearly and were much easier to understand than the previous videos I found.
The relationship is many to one that means 1. One loan can be pay in multiple payment s 2. One payment number associated with only one loan numbers But in the above example you are using same payment I'd for multiple loan numbers how can it possible???
Well you got it a little wrong when he said "arrow is coming from many to one in this case" at 1:54 he was talking with respect to payment entity,it is simple actually when we say one to many that means one entity in "set A" is associated with many entities in "set B" now what if we consider "set B" to be our initial set instead of "set A" then the case becomes many to one it's just the matter of perspective nothing more, if you still don't get it just forget it and for simply understanding take this case as one to many
Payment id represents deposit slip number. He's using a single deposit slip which has slip number as 20 to pay for all the three loans at once. He's not using separate slips.
Consider hotel(name, id) and room(number, beds) entity. 1. Hotel is strong entity. 2. Room is weak entity as its existence depends on hotel. 3. Many hotel can have a room with same room number but different bed numbers. 4. How do you model that. What confused me in above scenario is: 1. Its hard to find the room for specific hotel as two hotel have same room number.
To Get Certification, Click Here: bitly.ws/PXXy
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Thanks! I know this is pretty basic stuff, but it's still pretty hard to understand when you're a beginner. You explained it very clearly and were much easier to understand than the previous videos I found.
I think you should enable captions because i get hard time to understand this accent this course is very good but im not native in english
Could you help us by making a weak entity strong??? Thank you!!! and Greetings from Greece
He just explained how to do it
Take me to Greece 😅
as per your perspective what is the meaning of "against"?
The relationship is many to one that means
1. One loan can be pay in multiple payment s
2. One payment number associated with only one loan numbers
But in the above example you are using same payment I'd for multiple loan numbers how can it possible???
Well you got it a little wrong when he said "arrow is coming from many to one in this case" at 1:54 he was talking with respect to payment entity,it is simple actually when we say one to many that means one entity in "set A" is associated with many entities in "set B" now what if we consider "set B" to be our initial set instead of "set A" then the case becomes many to one it's just the matter of perspective nothing more, if you still don't get it just forget it and for simply understanding take this case as one to many
Payment id represents deposit slip number. He's using a single deposit slip which has slip number as 20 to pay for all the three loans at once. He's not using separate slips.
holy shit u explained it so well ur a legend
What happens if the amount is different?
Good job..keep it up
Just hit like for him.....
Explained very well
Thank you so much sir.
thank you so much for
not sure if it is a different notation but isn't the arrow should be pointing towards the relationship ( and not the entity ) ?
watched this in 1.25x speed and it was perrect
No..1.75
@@shubhangigupt151 no. 2x
@@contents.ai_ no 2.25x
@@midhunrajrpillai3884 not available in youtube for now
@@contents.ai_ yes! there are video speed boosting extensions.
what is partial key
Great
Great explained..
Consider hotel(name, id) and room(number, beds) entity.
1. Hotel is strong entity.
2. Room is weak entity as its existence depends on hotel.
3. Many hotel can have a room with same room number but different bed numbers.
4. How do you model that.
What confused me in above scenario is:
1. Its hard to find the room for specific hotel as two hotel have same room number.