2.7 Participation Constraints in ER Diagram

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@MrHimanshun]

Sir, there's no video on ER to Relational translation or No. Of tables for a given ERD! If this reaches you, please cover them. Thanks and Happy Diwali !!

[@arshanjada2985]

Yes sir plzzz

[@tinkukumarsejwal6991]

Important thing are left out, jo gate m ata ,baki definition jo Koi n pochta us par 15 min ki video,

[@anandprabhakar3453]

Sir aap majak hi kr diye 8 video dekhnae k bad pta chl rha h Jo main topic h wo pardhye hi nhi ho

[@m.sibtenshekh4797]

yes there is most important topic...

[@aloktiwari9172]

Bhai gazabb chutiya kata apna.Lol.

[@zahidahmadallaie6824]

What a teacher you are : Others : Explaining main concept with more focus and basics with less focus. YOU: Explaining basics of a concept with 101% of focus and skips MAIN Concept . WAH ✌✌✌✌👍👍👍👍👍👍👍👌✌👍👍✌✌👌

[@sakshitiwari2883]

Sir, Please complete this series on weak entity set and conversion of ER model to relational model. Thanks!!

[@Alonkete]

😂😂

[@fati.11]

Hase kyu?​@@Alonkete

[@RohitGupta_06]

Sir where is the video of Weak Entity set - Strong Entity set and Conversion of an ER diagram to Relational model, as you said in video 2.7. Please share the link of that videos sir.

[@yamisharma4879]

Sir god bless you..... thanks for mind blowing explanation

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@jyotiuttra8775]

Hello sir,. Lecture for weak and strong entities are missing and I guess few more lectures are missing. There is no continuation after 2.7we reach 3.1 functional dependency after this...

[@Divyanshu_rawat-r7j]

​@@jyotiuttra8775 This is the main problem in free content. 😢

[@youvendradhaker946]

Sir upload part 2.8 and complete er diagram series.

[@csmazindia]

I have also the same concern... Please provide..

[@abuibrahym1182]

Me also

[@deepakamboj]

Yes sir, y are you not giving any reply

[@lightbinger]

Telling you from Feb 2020 (1 yr after your comment): "ts not coming."

[@usmansohail5556]

same me tooo

[@PeterDeveros]

Bhai kya teacher hain yaar ye, itna clear and itna calm.

[@vivekkrthakur_101]

next topic karwaya hi nhi hai sir ne kro Main topic are skipped

[@aswinremesh6312]

This ER diagram video series is like the GoT books. #releasethenextpart

[@adityalodhi4023]

Sir Please make video on how to convert ER diagram in relational model

[@ashutoshdwivedi3976]

I 😍 this course and liked all of your videos, but disliked this video because you have not uploaded the next part of the 📼 video. Please don't do this. At least complete this topic. I had bought Ravindra Babu Sir's lecture but followed yours considering that you have uploaded all the topics, but after watching 20 videos , I saw that you have not completed the course. Sir please don't do this. It was the most frustrating thing happened with me. I wasted my precious time by following your tutorials. Atleast read the comments in the videos. Everyone is telling you to complete the topic but you are not doing. I think It was my mistake, I followed your tutorial.I have wasted my time by watching Your tutorials. Will never recommend it to anyone 😡. Friendly bump 👊 🤜

[@amitojsingh9373]

tomorrow is my exam and after watching this and all previous videos I got to know that the main topics of constructing ER and translation to table is missing......very bad sir

[@Nishant12375]

Good description 🙏

[@pintulakra1992]

Same.

[@mohibfayyaz4582]

He has complete these topic but for that you have to purchase this course. link in the description. somehow i was also waiting for the 2.8 lecture

[@kaushiksutariya2445]

YOU ARE "WORLD BEST TEACHER........."

[@aadishjain6838]

no u

[@raht9578]

no u

[@vinaysingh2089]

धन्यवाद गुरूदेव 🙏मै DBMS मे आपके ही भरोसे पर हू । GATE के प्रश्न भी हल करवाईयेगा ।

[@priyanshurastogi9102]

thank you sir. you are the best. i have my exam tomorrow. you saved my life. may god bless you.

[@KNOWLEDGEGATE_kg]

Most welcome dear, wish you all the very best for your exam, keep supporting❤ You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@sandeeprajakrishnan7496]

Sir , please complete the series , I have exams coming up , your exams have helped me a lot

[@shivirajput750]

Sir please complete this series.....it's very helpful for us ...... thanks a lot for videos ......

[@abhishekagrawal3618]

sir there no video of er to relational model and finding no of tables plz sir upload these ASAP

[@bongmou2845]

Sir, please continue this section as this is an important area for gate.

[@vedapradhan6011]

Sir, you teach so well, thank you. One thing I wanna say, I could not find Weak Entity-Strong Entity & translation to relational model video of your channel anywhere.

[@chakshujain7557]

Sir, Kindly complete this sub-topic series. I am really enjoying this subject.

[@apoorvasingh3921]

Sir please upload videos on weak and strong entity sets and conversion of ER diagrams to relational model!

[@dkgupta7557]

Sir your lectures are awesome and you are doing really a great work. Thanks a lot for your hard work. Sir you left main conversation topics, please cover the topics and complete your playlist as soon as possible.

[@ms.shivanithakur2841]

Sir aap bht acha teach krte ho.. muje b aap jaisa banna hai

[@potatopotato4676]

Disliking this video.. because wasted my time not knowing that there will be missing lectures. Thank you, Sanchit Jain sir and Unacademy for wasting our time.

[@pankajjatav6448]

dhyan se samajiyega!!! best video series for dbms for university exams, thank you sir.

[@python123]

Whole session was good.. pls provide videos on strong and weak entity and mapping from ER diagram to relational model..

[@Aditya_jazz]

Sir please also upload vedio teaching converting ER DIAGRAM TO RELATIONAL TABLE. THANKYOU SIR YOUR ARE EXPLANATION ARE PERFECT

[@DevenderSingh-yo9hu]

Sir I'm following your videos for my exam preparation . Thanks for providing enough content ❤❤. But , some videos are missing , sir Focus on it.

[@KNOWLEDGEGATE_kg]

Dear Devender, for complete content on DBMS, you can check out our course link below: www.knowledgegate.in/learn/DBMSbysanchitsir

[@tarunbawari2858]

Sir please registers pe bhi videos banaye jaise flip flop pe banayi he and sir your videos are very useful for me so please sir ho sake to register pe bhi video banaye ga

[@pratikgupta6474]

7:00 - Participation

[@smadasamy81]

It's one of the best course series. You have an excellent art of teaching with crisp tapic in each section and make the viewer to pay attention till the end. Thanks Mr.Sachit. I am eagerly waiting for the 2.8 part. Please don't delay it.

[@saptarshidasgupta9538]

Sir please upload the remaining videos in this series like weak entity set and strong entity set and conversion of er diagram to relational model

[@KNOWLEDGEGATE_kg]

Visit tiny.cc/KGwebsite for full courses and content👍

[@saptarshidasgupta9538]

@@KNOWLEDGEGATE_kg dbms course not available

[@abirpaul9027]

@@saptarshidasgupta9538 yes I also saw DBMS was not there

[@pinkipatel7000]

Sir plzzzzz upload a vedio series of how to convert a ER diagram into realational model as soon as possible...

[@sagarkumar0711]

Although it doesn't matter, but just saying it's whether not weather. Lecture is very nice.. appreciated

[@cpt.ghostriley735]

very nice lecture but in this lecture you did not explain the word constrain in hindi or simple english "Rules"

[@KNOWLEDGEGATE_kg]

Dear learner, for complete content on DBMS, you can refer our DBMS course, link is shared below: www.knowledgegate.in/learn/DBMSbysanchitsir

[@anubhav1020]

Missing Videos !! after 2.7 on Strong and Weak Entity Set and Discriminator attribute. Kindly upload the videos sir.

[@uzairhasan288]

Thanks Brother! Very Helpful For Me.

[@NadeemKhan-iw9ow]

sir please upload 2.8 part.my exams are coming soon(10 MAY 2019) RTU KOTA [RAJASTHAN]

[@aadishjain6838]

address bhi bata pagal!!

[@anjanasinha8705]

Sir its Nov now....pls upload er diagram series....🙏🙏

[@NishaSharma-nd1dk]

Thanks sir g

[@narendraparmar1631]

Dhanyawad sir ji😆

[@SandeepSharma-fd6zz]

Sir , after indulging us into your thrilling lecture, you are now putting us far away by not uploading the following lecture of 2.8, where you said I will be based on Strong and Weak Entity Concept..... Provide us soon sir...we are waiting.

[@MuhammadUmairShaykh]

Excellent ❤❤❤

[@KNOWLEDGEGATE_kg]

Thank you, keep learning & stay connected👍

[@surajmohanty528]

Nyc description sir

[@pritammondal1455]

sir please upload er diagram series next video

[@KNOWLEDGEGATE_kg]

Hi Pritam.. Thanks for letting us know your requirement. We will try to consider it.

[@pritammondal1455]

@@KNOWLEDGEGATE_kg weak entity and strong entity ,traps, conversion of relationship into table

[@sight-explore]

kzbin.info/www/bejne/kIeYqaGKlrF_na8

[@shakusharma7791]

Hii sir u r best teacher

[@AbdulWahab-mp4vn]

Amazing ! Love from Pakistan

[@KNOWLEDGEGATE_kg]

Thanks a lot Abdul..Stay blessed :) Keep learning and supporting !!

[@suvabratagiri9978]

Helpful contents

[@sairajdas6692]

Good explanation

[@csmazindia]

Hello Sir, Kindly provide a entire class about the ER diagram to relational model with the examples.... Eagerly waiting in order to complete the full chapters....

[@sirajkhanshinwari]

Very NYC sir gd explaination

[@nabhavlogs371]

Amazing sir!!

[@himanshuranjan4226]

thank you so much sir .......but please complete the series

[@kaushiksutariya2445]

Thanks for this vidio

[@ratankumar1399]

sir plz upload the videos regrading weak and strong entity....

[@abhaytyagi2711]

Thank you so much....

[@suparnobhattacharya6345]

I don't know if you will ever notice these comments ... But I want to say that you should be more interactive in these comment section. We can only reach you through this. Plz complete the weak entity topic .

[@sanjanaghosh051]

Sir aapne weak entity set strong entity set nahi padhaya

[@poonamrathore7160]

Sir please upload videos on translation from ER to relational model

[@kumariabha1382]

haaan sir such m kafi accha tha

[@monikasharma1184]

thank you sir 🙏

[@naive-fleek7420]

Sir, there's no video on ER to Relational translation or No. Of tables for a given ERD! If this reaches you, please cover them.

[@KNOWLEDGEGATE_kg]

Dear student, please visit our website www.knowledgegate.in

[@iuashrafi]

11 lectures dekhne ke baad , pata chala incomplete hain ;🥲

[@KNOWLEDGEGATE_kg]

Dear student, for complete content on DBMS, you can check out our course link below; www.knowledgegate.in/learn/DBMSbysanchitsir

[@aadishjain6838]

eagerly waiting for 2.8!!!!

[@tuljadewangan714]

Sir please complete weak entity and strong entity concepts and ER to RDBMS topics sir. Pls sir complete ERdiagram series ✍🏻

[@HarshKumar-tw3st]

yaar ye to mazak hogaya, itna mast samjhaya yahan tak aage ka video hi nahi hain ;_; Sir ab theater tak leke aaye ho to movie to dikhado... yahan paper sar par hai auar aap 2 saal se agla part nahi daale.... eiq bar me eiq series khatam karen please, then agla shuru

[@anmolgoyal6010]

Yes sir there is no video for strong and weak entity

[@mannusharma321]

Sir plz SQL pr b video bnaiye🙏

[@kaushiksutariya2445]

Yes ....SQL pe bhi vidio bana do sir

[@mustafam2374]

Sir, great video...make the next video fast plzz

[@akashkumaryadav1827]

great

[@KNOWLEDGEGATE_kg]

Thank you! keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@salikkhan1951]

Sir, digital electronic ka lecture complete please.. waiting from a long time

[@minivashishta9288]

sir, u r the Best

[@askariaziz4163]

thanks

[@manojyadav-ej6kz]

Sir, where is strong entity vs weak entity set .... You haven't completed this series

[@shahrukhafzal2555]

sir, please upload more videos on ER diagram as soon as you can

[@tabindabhat9078]

Sir please upload full videos on ER diagram and relational data model....

[@jyotipandey1313]

Hello sir pls complete this video series and plz upload strong and weak entity se and conversion of ER into table.plz..

[@muhammadnawazseo3407]

ASSLAMUALAKUM DEAR SIR...!!!! I Liked and learn from your vedioes very much and i am very thankful to for your nice and clear teaching but there is a little problem, as i belong to pakistan i can't understand difficult hindi words so my humble request is that you please will translate those words in english or urdu. again thank u vry much.

[@anuragsaraf2424]

Please upload a video explaining weak entity set

[@chloekimball536]

Sir please teach us EER and conversion of EER and ER to a database. Thanks!

[@DinoWinoSaur]

Thanks yaar

[@dhruvdesai4515]

you are best sir $

[@architkeshri7295]

Sir please upload ER diagram conversion lecture . Exams are near. Thank you.

[@mayurigarg3527]

Sir plz yeh complete krne k Baad dbms k concurrency protocol ki video bi bnaye

[@saifsiddique8425]

Sir ER diagram k lecture to complete kr dijiye

[@subhashmandal9580]

Sir please make videos on conversion ER MODEL TO RELATIONAL MODEL PLEASE

[@Dreamer_100x]

Sir in the ending You said that we will talk about weak and strong entity set .... But there are no such video in the playlist. Please make videos on that.

[@KNOWLEDGEGATE_kg]

Sure dear, also for complete course on DBMS, you can check out our course, sharing course link below: www.knowledgegate.in/learn/DBMSbysanchitsir

[@deepikaranaut3259]

Sir ,there is no such video as u mentioned at the last please upload 2.8 part also

[@comitora5346]

Sir explain the strong entity and week entity . And conversation of er diagram

[@aradhyasinghnaruka1345]

sir,haven't got er to relational transition,weak and strong entity videos...pls release them..i have exams near...btw Thank you..amazing video..

[@Anishkumar9696]

Sir please upload all other videos related to this topic

[@TheRohit901]

sir pls conversion aur baaki ki videos upload kar dijiye

[@souradeep54]

The one which I was looking for, ie Conversion is not there. Don't commercialize this channel. Many students depend on this, including me. If people need to study by paying money, they would go for MadeEasy or Applied Gate or Vani Institute, not Knowledge Gate. Thank you!

[@usamaabdulmoeed988]

If minimum cardinality of project is 3 then according to definition of minimum cardinality, at least 3 entities of project must participate in a project-employee relation. It means each employee must have atleast 3 projects. This exolanation is based on the definition. But the explanation you have given in this lecture can only be justified if cardinalities of project are (0,2) and cardinalities of employee are (3,15) Please make this correction or tell me if i am wrong

[@KNOWLEDGEGATE_kg]

Dear @Usama, you're wrong when you say that each employee should have at least 3 projects when the minimum cardinality of project is 3. those 3 projects maybe distributed to 3 different employees. when it comes to employee, then each employee may have no work that is 0 projects and at most 2 projects to handle. It can be assumed that the employee may be working solo or more than one employees could be sharing a projects.

[@usamaabdulmoeed988]

@@KNOWLEDGEGATE_kg Sir! The confusion actually arose when I came across two different definitions of minimum cardinality. The definition you provided in the lecture is: "Minimum cardinality defines the minimum number of times an entity occurence participating in a relationship" Now when we follow this definition, if minimum cardinality of "Project" is 3, then at least 3 projects must participate in a relationship. I know it does not make sense that each employee must be associated with a minimum of 3 projects but i am just trying to follow the definition The other definition that I came across was from ChatGPT and I found it after I had posted my comment. This definition is as follows: "Minimum cardinality refers to the minimum number of related entities that must be associated with a particular entity in a relationship" Now please pay attention to the words "related entities" in this definition. When we follow this definition, if the minimum cardinality of "Project" is 3, it means that at least 3 employees must be associated with each project in a relationship. Now this is also how you explained in the lecture. And this explanation is justified with ChatGPT's definition because it clearly states in its definition that minimum cardinality is the number of RELATED ENTITIES that must be associated with an entity in a relationship. Not the number of the entity itself, but the number of related entities All the confusion had occurred when I tried to follow the provided definition but it did not comply with the explanation

[@shubhamrastogi7701]

sir please upload the whole series of videos for er diagram.......sir please upload asap.

[@nishujain3478]

Hi, Sir, i think @6:28 you have mistakenly written (3,15) on wrong side because in previous part2.5 @10:28 you have clearly stated that when citizen has mobile number (cardinality is 1 to N ) N written on mobile number side. So here also, (3,15) should be written on employee's side instead of project's side.

[@nishujain9876]

It would be very helpful if you can provide clarity on this doubt. Thanks.

[@Anuragsinghkashyap]

sir,please complete this series.

[@vipulparmar4040]

Sir er digram to relational model conversion ki video kb aaygi

[@ashishjain7182]

Sir pls complete all topics of er diagram and relational model