3 жыл бұрын
Пікірлер
@AnsirAli-z6e 2 күн бұрын
❤
@dinudineshdbms 2 күн бұрын
🙏
@mr.twente7 9 күн бұрын
This whole playlist is absolute gem 💎! The way you explain things is so clear, Thank u sir for uploading such amazing content it’s been a huge help sir !!❤
@dinudineshdbms 9 күн бұрын
Thanks for appretiation....
@mehulgupta5785 16 күн бұрын
thankyou for the explanation sir nobody explained an example as well you could❤️
@dinudineshdbms 16 күн бұрын
My pleasure.. Thanks for reviewing....
@Coder-1117 16 күн бұрын
Sir plz give the notes😢.
@dinudineshdbms 16 күн бұрын
Goto first lecture descriptikn, waha link hai sabhi slides ka..
@thecrapbag3433 17 күн бұрын
Can we take the captain as a descriptive structure in the belongs to relationship between team and player? Instead of making a captain relationship.
@dinudineshdbms 16 күн бұрын
We can but in this question a team must have captain so for this we need to place the total participation of team in belong_to relationship and if this is modelled than every team have players is also going to modelled. That is why we need to keep captain as a separate relationship.
@Mad_Monk29 18 күн бұрын
very well explained sir , make more vedios you will get great recomendition
@dinudineshdbms 18 күн бұрын
Thanks for reviewing....👍
@buttonsmasher8846 20 күн бұрын
Kch smjh ni ara awaz irritating hai
@dinudineshdbms 18 күн бұрын
Thanks for reviewing...
@HasaniHardik 27 күн бұрын
Daddho Sutho. Love your teaching sir :)))
@dinudineshdbms 27 күн бұрын
Budhhi kare sutho lago....dhanyawad :)
@ayushghonge Ай бұрын
aap bhagwan bankr aaye ho teacher ji mere feed me:) thank you so much
@dinudineshdbms Ай бұрын
Welcome... all the very best for exam..
@azuboof Ай бұрын
thanks sir, always helpful. have a good day
@dinudineshdbms Ай бұрын
Welcome...
@WizardHary Ай бұрын
sir please provide all the ppts of dbms
@dinudineshdbms Ай бұрын
Go to dbms lec 1 description for ppts link....
@heroqasimyt Ай бұрын
best explanation, found this video a night before my exam of DBMS refered by my friend. Thanks
@dinudineshdbms Ай бұрын
Thanks for reviewing... All the very best for exam...
@Coolpratik10 Ай бұрын
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 :)
@dinudineshdbms Ай бұрын
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 Ай бұрын
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..
@Coolpratik10 Ай бұрын
@@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. 🙏
@TalesChristian Ай бұрын
Good work sir Kindly suggest book for this subject where problem question and answer available like that
@dinudineshdbms Ай бұрын
1. Software Engineering with UML by bhuvan unhelkar 2. MCS-024: Object Oriented Technologies and Java Programming by Dr. D K Sukhani 3. UML Diagramming A Case Study Approach By Suriya Sundaramoorthy
@TalesChristian Ай бұрын
@@dinudineshdbms thank you sir
@atiyawarsi111 Ай бұрын
Thank you sir
@dinudineshdbms Ай бұрын
Welcome...
@NvShortcuts Ай бұрын
sir your content is too good , love from nit surat .
@dinudineshdbms Ай бұрын
Thanks for reviewing...spread the joy of learning..
@vidhibhatt1632 2 ай бұрын
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!
@dinudineshdbms 2 ай бұрын
Thanks for watching... all the best for exam...
@mastermaxx5352 2 ай бұрын
tameez se padha do yar koi.
@dinudineshdbms 2 ай бұрын
Matlab es vedio se samajh nahi aaya kya?
@mastermaxx5352 2 ай бұрын
@@dinudineshdbms did not mean to hate but ye 4nf and 5nf to genuinely samjh nhi aa rha
@mastermaxx5352 2 ай бұрын
kal exam hai sir pakka fail hone wala hoon.
@dinudineshdbms 2 ай бұрын
Please mail me the question paper after exam..
@mastermaxx5352 2 ай бұрын
@@dinudineshdbms sir 4nf 5nf aya hi nahi paper me. sql query ayi thi bhejoon ?
@Ajay-life 2 ай бұрын
I Subscribe 👍
@dinudineshdbms 2 ай бұрын
Thanks for supporting me...
@azuboof 2 ай бұрын
wait somehow i understood everything..youre goated. Thanks a bunch sir.
@dinudineshdbms 2 ай бұрын
Always Welcome... Spread the joy of learning...
@karankadlag727 2 ай бұрын
sir please send some notes
@dinudineshdbms 2 ай бұрын
drive.google.com/drive/folders/1V-nhhE1NXeY9njfNGxl5uY012fJHDryw?usp=drive_link
@digitalsolutions1057 2 ай бұрын
Thank you so much for your time and effors sir. This has been very helpful
@dinudineshdbms 2 ай бұрын
Welcome... spread the joy of learning...
@himanichoudhary4653 2 ай бұрын
really impressive. no other youtuber give such detailed explanation really helping me alot thnku sir.
@dinudineshdbms 2 ай бұрын
Welcome... spread the joy of learning...
@amiteshsingh5559 2 ай бұрын
phenomenal sir 👋
@dinudineshdbms 2 ай бұрын
Thank you...
@ANKRY10 2 ай бұрын
14:27 Q4 RA : ⊓ pname (Employee ⋈ Company) should be correct then right?
@dinudineshdbms 2 ай бұрын
This query does not specify whether the employee works on the company or not? That is why it is incorrect.
@kaustubh.sharma 2 ай бұрын
Thankyou~
@dinudineshdbms 2 ай бұрын
Welcome...
@kaustubh.sharma 2 ай бұрын
Thankyou~
@dinudineshdbms 2 ай бұрын
Welcome..
@ammanrajput1252 3 ай бұрын
Sar kya yah playlist aktu ke liye valid hai
@dinudineshdbms 3 ай бұрын
Syllabus check karlo wahi hai to valid hai
@ammanrajput1252 3 ай бұрын
@@dinudineshdbms thoda thoda lag to raha hai lekin ismein C plus plus... Hota to vahi rahata
@ammanrajput1252 3 ай бұрын
@@dinudineshdbms main kuchh videos dekh kar dekhta hun
@mastermaxx5352 3 ай бұрын
nice
@dinudineshdbms 3 ай бұрын
Thanks...
@mastermaxx5352 3 ай бұрын
@@dinudineshdbms the questions you do in your videos come directly in my exams.
@yuvrajdhamija559 3 ай бұрын
sir can we not use natural join in question 4??
@dinudineshdbms 3 ай бұрын
Kiya toh hai maine use natural join bhi...
@s.pareshkumar8049 2 ай бұрын
acha bhaiya
@kirtijindal654 2 ай бұрын
no you can't
@s.pareshkumar8049 16 күн бұрын
kar sakte hain
@driss6208 3 ай бұрын
Sir you a great teacher thank you very much for this lesson ❤❤
@dinudineshdbms 3 ай бұрын
Welcome, spread the joy of learning..
@Bull_of_markets 3 ай бұрын
1 din pehle dekh rahe heyy
@dinudineshdbms 3 ай бұрын
All the very best. BTW which university have exams now.
@atharvaghorpade15804 3 ай бұрын
@@dinudineshdbms PUNE UNIVERSITY
@Malaika_ki_rahein 3 ай бұрын
sir please continue your quality teaching for the subject of DBMS from korth and navathe also please give some more examples please sir
@dinudineshdbms 3 ай бұрын
Sure i am working for that also i am planning to solve university questions from different universities papers
@HowtoHardik 3 ай бұрын
big fan of your teaching sir....mai bhi sindhi hu😁(assuming you are sindhi as well ) btw i am from vit chennai :)
@dinudineshdbms 3 ай бұрын
Dhado suttho...Thank you for reviewing..
@avinashgupta5632 3 ай бұрын
Thankyou for explaining it in such an easy wat sir.. I'm from Shankaracharya College Durg😄
@dinudineshdbms 3 ай бұрын
Thanks for reviewing...
@akshatanagpure11 3 ай бұрын
Nice explanation sir..!🙏🏻 All doubts clear ho gaye
@dinudineshdbms 3 ай бұрын
Thanks for reviewing...
@nsudhir_here 3 ай бұрын
29:50 is it possible to create nested relations in today's modern dbms?
@dinudineshdbms 3 ай бұрын
Yes but may be not in RDBMS. It may be possible in NOSQL databases.
@medhavipajgade9685 4 ай бұрын
Best!
@CE015_PrinceJ.Chaudhari 4 ай бұрын
1 number
@dinudineshdbms 4 ай бұрын
Thanks..
@_pranjal_nale 4 ай бұрын
Thank you for clearing all the doubt💯😀
@dinudineshdbms 4 ай бұрын
Welcome...👍
@jitendrasaverker 5 ай бұрын
thank u sir
@dinudineshdbms 5 ай бұрын
Welcome
@madhusridharmaraj 5 ай бұрын
Sir plz add English subtitles
@anonmityslayer 6 ай бұрын
sir around 40:00 when we are finding candidate keys in step 2 how we are able to minimize that super key just by cutting based on FD means i want to know what's the logic behind this ?
@dinudineshdbms 6 ай бұрын
Logic is that first take all the attributes of the relation and then omit all the dependent variables from it and then take closure of this set, if it contains all the attributes then it is a candidate key and if it is not then it is not a candidate key but is a part of every candidate key. Then you need to take the closure of its superset. In this case number of candidate keys are muptiple that means more than one. But if by omitting dependent variables if it does not contain any attribute then we have multiple candidate keys and no attribute is common in those keys.
@anonmityslayer 6 ай бұрын
@@dinudineshdbms got it sir 🙏
@anonmityslayer 6 ай бұрын
now i know subqueries more than just syntax memory.
@anonmityslayer 6 ай бұрын
Moment at 45:51 when sir says "bade jaldi nind se jage yaar" 😅😅
@anonmityslayer 6 ай бұрын
this is some quality content
@anonmityslayer 6 ай бұрын
sir can you please provide these .sql files for reference i didn't make any notes for all these lectures as your ppt is detailed and rich in knowledge similarly these sql files would better act as a visual memory sync with this lecture 🙏
@dinudineshdbms 6 ай бұрын
Thanks for reviewing. It will try to find these sql scripts so that one can use it.
@anonmityslayer 6 ай бұрын
@@dinudineshdbms thank you sir I am on the mission to complete this playlist for indepth knowledge of dbms 🙏
@dinudineshdbms 6 ай бұрын
Here is a link of complete lecture notes with scripts. drive.google.com/drive/folders/1jkGriaIhUZmFNO7gS5HU-9S48wx6P9vg?usp=drive_link
@anonmityslayer 6 ай бұрын
@@dinudineshdbms thank you so much sir 🙏 🙏🙏
@anonmityslayer 6 ай бұрын
so noice far better than many teachers at prominent institutions like iits and nits and way better then any university in west bengal. lucky students
@dinudineshdbms 6 ай бұрын
Thanks a ton for the shoutout, Glad you find my content helpful!
@samarthhemrajani2025 6 ай бұрын
Q1 sir driver less cars exist !!
@dinudineshdbms 6 ай бұрын
Yes today driverless cars exist but we do not consider it for making the er diagram.
@samarthhemrajani2025 6 ай бұрын
@@dinudineshdbms Alright and in last Q i think you missed a double diamond between strong and weak entity like between course offering and instructor