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.

[@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

[@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 ✌✌✌✌👍👍👍👍👍👍👍👌✌👍👍✌✌👌

[@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...

[@rawat-r2n]

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

[@yamisharma4879]

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

[@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.

[@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

[@aswinremesh6312]

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

[@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.

[@sandeeprajakrishnan7496]

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

[@PeterDeveros]

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

[@vhack4224]

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

[@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

[@vinaysingh2089]

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

[@shivirajput750]

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

[@adityalodhi4023]

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

[@kaushiksutariya2445]

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

[@aadishjain6838]

no u

[@raht9578]

no u

[@chakshujain7557]

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

[@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

[@python123]

Whole session was good.. pls provide videos on strong and weak entity and mapping from ER diagram 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.

[@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.

[@bongmou2845]

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

[@anubhav1020]

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

[@apoorvasingh3921]

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

[@Aditya_jazz]

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

[@shishirshi1858]

Thank you sir🙏🙏

[@KNOWLEDGEGATE_kg]

Most welcome dear❤Keep learning & supporting! Stay connected for more amazing videos & upcoming contents 👍😊You can also check out our CS bundle course for complete preparation of Computer Science subjects, sharing course link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@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

[@pinkipatel7000]

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

[@NishaSharma-nd1dk]

Thanks sir g

[@pankajjatav6448]

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

[@abhishekagrawal3618]

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

[@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 .

[@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

[@uzairhasan288]

Thanks Brother! Very Helpful For Me.

[@rashmisharma5625]

Thanks

[@sairajdas6692]

Good explanation

[@abhaytyagi2711]

Thank you so much....

[@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

[@sagarkumar0190]

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

[@shakusharma7791]

Hii sir u r best teacher

[@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.

[@AbdulWahab-mp4vn]

Amazing ! Love from Pakistan

[@KNOWLEDGEGATE_kg]

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

[@suvabratagiri9978]

Helpful contents

[@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

[@ms.shivanithakur2841]

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

[@surajmohanty528]

Nyc description sir

[@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!

[@kaushiksutariya2445]

Thanks for this vidio

[@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.

[@himanshuranjan4226]

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

[@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

[@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

[@nabhavlogs371]

Amazing sir!!

[@NadeemKhan-iw9ow]

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

[@aadishjain6838]

address bhi bata pagal!!

[@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

[@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

[@narendraparmar1631]

Dhanyawad sir ji😆

[@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..

[@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.

[@ratankumar1399]

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

[@bhupeshjoshi9371]

Is Cardinality and Cardinality constraints means same ?

[@mustafam2374]

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

[@Singh11225]

souldn't (3,15) be written on right side and (0,2) be written on left side?

[@kumariabha1382]

haaan sir such m kafi accha tha

[@MuhammadUmairShaykh]

Excellent ❤❤❤

[@KNOWLEDGEGATE_kg]

Thank you, keep learning & stay connected👍

[@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

[@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.

[@himanshuaggarwal1076]

Please complete the series

[@anmolgoyal6010]

Yes sir there is no video for strong and weak entity

[@tuljadewangan714]

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

[@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

[@aadishjain6838]

eagerly waiting for 2.8!!!!

[@adiz_gaming3671]

Sir plz complete this series

[@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

[@Anuragsinghkashyap]

sir,please complete this series.

[@DinoWinoSaur]

Thanks yaar

[@dhruvdesai4515]

you are best sir $

[@minivashishta9288]

sir, u r the Best

[@sanjanaghosh051]

Sir aapne weak entity set strong entity set nahi padhaya

[@pratikgupta6474]

7:00 - Participation

[@shahrukhafzal2555]

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

[@mannusharma321]

Sir plz SQL pr b video bnaiye🙏

[@kaushiksutariya2445]

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

[@jyotipandey1313]

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

[@rohitpatel6374]

sir please upload that videoas soon as possible of example on how to convert ER Model in to Relational Table.

[@salikkhan1951]

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

[@anjanasinha8705]

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

[@anuragsaraf2424]

Please upload a video explaining weak entity set

[@gaurav_das]

sir,if(min>0),can we say that total participations occur for that entity to the relationship?

[@Anishkumar9696]

Sir please upload all other videos related to this topic

[@ibotonmeitei4854]

thank u sir . sir please make video on ugc net questions

[@deepaksaxena2182]

Sir i am not gettjng video on ER DIAGRAM TO TABLE CONVERSIONS NUMERICAL......is it on your channel or not

[@architkeshri7295]

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

[@mukulborole]

Sir please upload further videos

[@tabindabhat9078]

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

[@manojyadav-ej6kz]

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

[@abubakarnasir2568]

Zabardast sir

[@subhashmandal9580]

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

[@ashishjain7182]

Sir pls complete all topics of er diagram and relational model