Case 1 :tarzan:the wonder car movie mein Ajay Devgan ki bhatakti aatma car ko drive kar rahi hoti h aur idhar kuda deti hai.. , toh is case mein , Car aur Accident mein kya relationship hai ? Kyu ki aatma ek invisible entity hai jo responsible h car ko chalane mn . Case 2 : Tesla Car agar autopilot mode par chal rhi ho aur kahi crash kar jaye toh us case mein kya hoga ? @Dinesh Bhawnani sir ji batayiye plzz :)
Irrespective of cases, agar car aatma chala rahi ho ya autopilot mode me chal rahi ho damage amount car ka hi count hoga jiska insurance ho kyunki er diagram car insurance company ke liye banaya gaya hai jiske dwara insurance provide kiya gaya hai..
Irrespective of cases, agar car aatma chala rahi ho ya autopilot mode me chal rahi ho damage amount car ka hi count hoga jiska insurance ho kyunki er diagram car insurance company ke liye banaya gaya hai jiske dwara insurance provide kiya gaya hai..
@@dinudineshdbms Thank you sir , abhi main car khareedne jaa sakta hu .. Lekin sir ek aur case reh raha tha .. 🙆♂ Agar hum Person --- car --- Accident ki baat karein .. aur us case mein agar Selmon bhoi jaise footpath wala scene ho toh.. kya Person --- car --- Accident relationship valid hoga? Apart from jokes.. Wonderful explanation of the concept sir. It is very much helpful. 🙏
Mapping cardinalities are shown in only binary relationships and not in ternary relationships. Because for mapping binary relationships into relational tables have 3 rules but mapping ternary relationship into relational table only have 1 rule.
In 3rd qn, shouldn't team_played be a unary relationship? Because a team plays only with another team, right? If done so, we could remove Opponent attribute from MATCH entity and add Opponent_score as another attribute in team_played relationship.
Look for this solution in 4th question. In 3rd question er diagram is made for your favorite sports team only so oppenent score and own score should be maintained.
Definitely one can have a policy then only he/she can claim the insurance amount but that table is beyond the scope of this er diagram. It should be stored in insurance company database.
Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): the NHL has many teams, each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, a team captain is also a player, a game is played between two teams (referred to as host team and guest team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2). Construct a clean and concise ER diagram for the NHL database send me answer sir pls u explaining so awesome 😊😊
We will not represent cardinality on ternery relationships or in others words in every er diagram ternery relationship always represent many to many relationships and participation is always partial.
I have playlist for complete syllabus you can go to playlist section.. For designing the db you need to understand the whole project that requires software engineering SDLC concept..
Accident ka total participation rakh bhi sakate hai but usase koi fark nahi padeha kyunki jab er diagram to relational model me convert karenge to participated relationship ki table banegi hi kyunki wo ternary relationship hai. Total participation and cardinality ratio hamesha binary relationship ka hi dekha jata hai kyunki usme convert karne ke alag alag steps hai kabhi relation merge karna hota hai kabhi relayionship ki alag table banani hoti hai but for ternary relationship hamesha alag hi table banati hai so cardinality ratio and total participation ka koi importance nahi hai usme. For more doubt you can watch er diagram to relational mapping video.
sir koi khadi gaadi ko bhi to thok sakta hai , in this case there is no person inside the car, suppose he parked his car for 2 minutes for toilet and other car hit the car then this also a case
It is a rule of identifying relationship that identifying relationship is always one to many from identifying entity set to weak entity set. Course offering are many but one course offering belong to only 1 course that is why it is 1 to many from course to course offerings.
hello sir, last question mai student enrolls course offering mai apne course offering mai double rectangle kyu banaya hai? agar aapne course offering ko weak entity liya hai toh enrolls bhi double diamond mai hona chahiye ,
Every weak entity set is always associated to one identifying entity set through a identifying relationship so that relationship is represented through double diamond box not every relationship is identifying relationship so thats why i have not drawn it with double diamond box
No according to er diagram question students should enroll to course offerings which is offered within courses. So ultimately students enrolled to courses though course offerings.
It is dependent on the region, here in india people learn with local language but for communicating with outside world it is required to speak english thats why study in english... So for teaching the concepts here we used mixed language i.e. hindi + english..
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
best explanation across entire internet, found this video a day before my exams and i am just so happy that i came across it. thank you sir!
Thanks for watching... all the best for exam...
best explanation, found this video a night before my exam of DBMS refered by my friend. Thanks
Thanks for reviewing... All the very best for exam...
came across this video with my final being in 2 days, thanks a lot sir
All the very best for exam..
thankyou for the explanation sir
nobody explained an example as well you could❤️
My pleasure.. Thanks for reviewing....
wonderful. ....you cleared all my doubts....thankyou very much
Thanks for watching...
Many Manry Thanks Sir. may Allah Bless You
Thanks and welcome...
Thank you for clearing all the doubt💯😀
Welcome...👍
Its 4 am tmrw 10 am exam and im watching this❤😂
All the very best....
Nice explanation sir..!🙏🏻
All doubts clear ho gaye
Thanks for reviewing...
Well Explained....watching from Pakistan
Thanks for reviewing...
Bohot mst sikhaya sir aapne❤️❤️
Thanks for liking it..
3 months of course cover in 30 minutes 😂
Love from Pakistan 🇵🇰
Congrats..and all the best for exams if you have any..
Thank you so much Sir for such a wonderful explanation
Thanks for reviewing...
Thankyou for explaining it in such an easy wat sir.. I'm from Shankaracharya College Durg😄
Thanks for reviewing...
Excellent explanation sir
Thanks...
Nice explanation
Thanks for liking
My god sir heads off to you🖖
Thanks for watching...
Sir normal forms aur transaction concurrency ke uper bhi question layiye plz 22 dec ko exam ha DBMS ka plz sir... 😊
good explained🤩
Thanks for watching...
Can you please make a video in which you code a whole project and explain it step by step, yk just practicle skills, our college is lacking those.!
It will require time because for that i need to create whole project along with erd, dfd and other uml diagrams.
Thank you sir!
Welcome...
Best!
Case 1 :tarzan:the wonder car movie mein Ajay Devgan ki bhatakti aatma car ko drive kar rahi hoti h aur idhar kuda deti hai.. , toh is case mein , Car aur Accident mein kya relationship hai ? Kyu ki aatma ek invisible entity hai jo responsible h car ko chalane mn .
Case 2 : Tesla Car agar autopilot mode par chal rhi ho aur kahi crash kar jaye toh us case mein kya hoga ?
@Dinesh Bhawnani sir ji batayiye plzz :)
Irrespective of cases, agar car aatma chala rahi ho ya autopilot mode me chal rahi ho damage amount car ka hi count hoga jiska insurance ho kyunki er diagram car insurance company ke liye banaya gaya hai jiske dwara insurance provide kiya gaya hai..
Irrespective of cases, agar car aatma chala rahi ho ya autopilot mode me chal rahi ho damage amount car ka hi count hoga jiska insurance ho kyunki er diagram car insurance company ke liye banaya gaya hai jiske dwara insurance provide kiya gaya hai..
@@dinudineshdbms Thank you sir , abhi main car khareedne jaa sakta hu .. Lekin sir ek aur case reh raha tha .. 🙆♂
Agar hum Person --- car --- Accident ki baat karein .. aur us case mein agar Selmon bhoi jaise footpath wala scene ho toh.. kya Person --- car --- Accident relationship valid hoga?
Apart from jokes.. Wonderful explanation of the concept sir. It is very much helpful. 🙏
thank you so much for the video !
Thanks for liking...
Watching before 38 minutes from exam
All the very best...
Legend
Hahaha same here
Tmkc
Confident dheet
Thank you so much sir ❤
Welcome..
Thank you so much sir 🙏
Welcome.. and thanks for reviewing..
Thank You Sir
Thanks for reviewing..
Very nice video
Thanks
watching from Bangladesh before three hours of exam 🥲
All the very best
before 2:15 hrs,not even 3
thank you sir,it was really helpfull
Thanks for watching..
Thnx a lot sir..
Thanks for watching...please reply from which place you are watching...
Thank you so much🤩
Welcome
welll explained
Thanks for watching
very nicely explained sir
Thanks for watching...
What will be the cardinality for the entities shown in the ternary relationship in question 2?
Mapping cardinalities are shown in only binary relationships and not in ternary relationships. Because for mapping binary relationships into relational tables have 3 rules but mapping ternary relationship into relational table only have 1 rule.
In 3rd qn, shouldn't team_played be a unary relationship? Because a team plays only with another team, right? If done so, we could remove Opponent attribute from MATCH entity and add Opponent_score as another attribute in team_played relationship.
Look for this solution in 4th question. In 3rd question er diagram is made for your favorite sports team only so oppenent score and own score should be maintained.
can we have an policy table with policy id ,premium in 1st question.?
car has policy?
Definitely one can have a policy then only he/she can claim the insurance amount but that table is beyond the scope of this er diagram. It should be stored in insurance company database.
Suppose you are given the following requirements for a simple database for the
National Hockey League (NHL):
the NHL has many teams,
each team has a name, a city, a coach, a captain, and a set of players,
each player belongs to only one team,
each player has a name, a position (such as left wing or goalie), a skill level, and
a set of injury records,
a team captain is also a player,
a game is played between two teams (referred to as host team and guest team)
and has a date (such as May 11th, 1999) and a score (such as 4 to 2).
Construct a clean and concise ER diagram for the NHL database send me answer sir pls u explaining so awesome 😊😊
Ok i am trying..
@@dinudineshdbms ok Sir tqq🤗🤩
Hloo sir
th-cam.com/video/oJS6LvSq8RM/w-d-xo.html
drive.google.com/file/d/1gS4bDOoaA5W8cFHSSyQulOBkmgD1mS5u/view?usp=drive_link
Life saver. 5am
Sir, are descriptive attributes compulsory? and also love your teaching method from Pakistan💌
Yes sometimes it is neccessary because we cannot add it into some entities and we have to represent in relationship only.
1 din pehle dekh rahe heyy
All the very best. BTW which university have exams now.
@@dinudineshdbms PUNE UNIVERSITY
Sir take some more complex problem of conversation ER to Relational model
th-cam.com/video/yXBDFIJ-Rw4/w-d-xo.html
th-cam.com/video/MN1PePz8YvA/w-d-xo.html
question no 2 mein jo turnary relationship bana hai us mein cardinality and modality kiya hogi
We will not represent cardinality on ternery relationships or in others words in every er diagram ternery relationship always represent many to many relationships and participation is always partial.
@@dinudineshdbms thank you
Sir do you have a complete playlist for dbms? We are taught only to pass the exam. I still can NOT design the db
I have playlist for complete syllabus you can go to playlist section..
For designing the db you need to understand the whole project that requires software engineering SDLC concept..
Q1 sir driver less cars exist !!
Yes today driverless cars exist but we do not consider it for making the er diagram.
@@dinudineshdbms Alright and in last Q i think you missed a double diamond between strong and weak entity like between course offering and instructor
Accident total participation mai nhi hoga kya?
Accident ka total participation rakh bhi sakate hai but usase koi fark nahi padeha kyunki jab er diagram to relational model me convert karenge to participated relationship ki table banegi hi kyunki wo ternary relationship hai. Total participation and cardinality ratio hamesha binary relationship ka hi dekha jata hai kyunki usme convert karne ke alag alag steps hai kabhi relation merge karna hota hai kabhi relayionship ki alag table banani hoti hai but for ternary relationship hamesha alag hi table banati hai so cardinality ratio and total participation ka koi importance nahi hai usme.
For more doubt you can watch er diagram to relational mapping video.
sir koi khadi gaadi ko bhi to thok sakta hai , in this case there is no person inside the car, suppose he parked his car for 2 minutes for toilet and other car hit the car then this also a case
Ho sakata hai but database me esse koi fark nahi padega accident hoga to claim to person lega hi na agar insurance karaya hai toh..
11:14
Sir kl pls pass kardena paper me
mujhe bhi sir ✋
All the very best..
Sir plz add English subtitles
respected sir, at time stamp 29:54 how is course and course offering 1 to Many. Out of all courses many courses can be offered.
It is a rule of identifying relationship that identifying relationship is always one to many from identifying entity set to weak entity set.
Course offering are many but one course offering belong to only 1 course that is why it is 1 to many from course to course offerings.
respected sir please make a video on transforming ERD into relations/table😌
Sir I can't find the lecture 1st of E R diagram
th-cam.com/video/hD3nRfIFsA0/w-d-xo.html
Will That Be wrong if we make score as a weak entity in Question 3
Then how you relate which player scored how much from which match
Watching 21 before exam
All the best...
Just 1hour before exam
All the very best..
hello sir, last question mai student enrolls course offering mai apne course offering mai double rectangle kyu banaya hai? agar aapne course offering ko weak entity liya hai toh enrolls bhi double diamond mai hona chahiye ,
Every weak entity set is always associated to one identifying entity set through a identifying relationship so that relationship is represented through double diamond box not every relationship is identifying relationship so thats why i have not drawn it with double diamond box
@@dinudineshdbms oh okay sir thankyou so much !
I guess student should enroll in course not in course offering
No according to er diagram question students should enroll to course offerings which is offered within courses. So ultimately students enrolled to courses though course offerings.
No need y b chaval hi h 😂
please note in the title that the video is not in English to avoid wasting people's time!
Thanks for suggestion..
@@dinudineshdbms Thank you for the prompt reply and action, you are a respectable person 🙏🏻
use english pls
It is dependent on the region, here in india people learn with local language but for communicating with outside world it is required to speak english thats why study in english...
So for teaching the concepts here we used mixed language i.e. hindi + english..
Thank you! Sir
Welcome...
Watching before 50 minutes to exam
All the very best..
Hahaha same😂
Us bhai us