2.6 Mapping Cardinalities and Cardinality Ratio in ER diagram

[@KNOWLEDGEGATE_kg]

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

[@PriyanshuPareek]

Hatsoff to you sir! You are an amazing teacher. You reduce all these big scary topics to just basics which only need some practice before main exams like GATE, NET and these are always helpful in B.Tech and many other fields. I would like to help you in every aspect possible because I want you to really get paid off of the hard work you have done. I've been sharing all your videos with all my friends. I thank you from the bottom of my heart.

[@sauravranjansharma1592]

The way you teach is very unique 🙏🙏🙏🙏🙏

[@kanakmittal3756]

Example of Many to One - Religion (Hindu, Muslim, Sikh, Christian) ----------- -----------> INDIAN

[@SaumyaSharma007]

Bro it's more of a one to many relationship

[@shivangisrivastava1158]

Every topic you cover gets crystal clear. hats off Sir 🙌🙏❤️

[@KNOWLEDGEGATE_kg]

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

[@saurabhgupta7785]

Sir, Please upload lectures on B and B+ trees.

[@vaibhavkumar4951]

I have seen the best explanation of this topic .................. thank you sir

[@KNOWLEDGEGATE_kg]

You are most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@vaibhavkumar4951]

@@KNOWLEDGEGATE_kg sir, i am preparing for IBPS SO IT OFFICER and SEBI IT OFFICER........ is this playlist helpful for...... these exams???

[@uditchaudhary9318]

something

[@rahulimishra9322]

Sir thanks a lot and please complete this series as early as possible 😀✌️

[@lsuremusic3787]

I m preparing for my exams .. and KG rocks🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥

[@fazalkhan5714]

Best teacher in the world

[@KNOWLEDGEGATE_kg]

Thanks a lot Roman.. Keep learning and supporting. Do visit our website www.knowledgegate.in for more courses and contents.

[@shubhambhatia4968]

Nice lecture sir, your lectures are so meaningful 👌👌👌👌👌👌👌👌

[@uditchaudhary9318]

"something"

[@saketkumar4972]

At 14:10 m:n should be in the middle and 1:1 should be on the outer rectangle

[@vlogwithankit6546]

Thank you sir for better understanding 🤗

[@KNOWLEDGEGATE_kg]

You're most welcome Ankit.. keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@sharmilanag6296]

Sir, you are awesome. Very good explanation. 👌👌

[@Nitimoy]

thak hoyeche

[@akakop]

Sir pls make a video on how to find minimum no of tables for an er diagram type questions

[@harshavardhankakade9036]

Concept is crystal and clear 😌

[@KNOWLEDGEGATE_kg]

Glad you liked it, @harshavardhankakade9036. Stay connected & keep learning👍

[@dheerajtiwari9923]

Nc lecture tdy. I'm waiting for next lecture..

[@faizanbhatti5489]

Such a wonderful explanation ❤️ Love from Pakistan 🔥❤️🔥

[@KNOWLEDGEGATE_kg]

Thank you so much! Keep supporting & stay connected for more amazing contents👍😊

[@sagarkulkarni4498]

At 11:30 it is said that every one to one is one to many or many to one ...... how can that be?? It can be agreed that every one to many or many to one is one to one!

[@mkpkartik1359]

Same here...still confused

[@skittles6486]

Sir, can you please make video on EER Model?

[@yaad-e-madina4992]

I need the examples of ERD but in play list there is no vedio 😑 But your teaching method is amazing 👍👌 Your examples are very simple and interesting In one day i understand ERD Jazakallah ❣

[@KNOWLEDGEGATE_kg]

Thanks a lot dear student.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@aradhyasinghnaruka1345]

sir superb vidoes..hats off to you..i have only one small doubt.. at 11:27 min ..you said every one to one is many to one or one to many...how is that possible sir...in many to one we will have one entity from one set which have relation with 2 or more entities in other set..while one to one it can have relations at most one..then how is that statement valid..i didn't get this only in whole lecture

[@casualsadi3144]

sorry in advance for my bad english.... in one to many u have one entity relating to 2 or more and in many to one u have 2or more entities relating to one ... so in every scenario ... one entity must relate to one entity... thus one to one exists in both of them....

[@uzairtanveer9140]

awesome series . Thank you so much

[@its_SR07]

just a reminder sir, you are awesome

[@KNOWLEDGEGATE_kg]

Thanks a lot dear for your generous words, keep learning & stay connected for more amazing contents👍😊

[@k_devyansh4332]

14:12 since there are going to be multiple select questions in 2021, will we have to select all the 4 options ( 1:1 , 1:n , n:1 , n:m ), if the answer is (1:1) ??? can anyone expalin this...........

[@uditchaudhary9318]

'something'

[@yawargillyawargill7420]

Sir u r the best😇 teacher 👍

[@KNOWLEDGEGATE_kg]

Thanks a lot dear yawar.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@zeeshanparacha1940]

sir you are amazing teacher love from pakistan

[@pulkitgoel2638]

you have explained very well. can you please explain hashing in dbms..

[@AhamedKabeer-wn1jb]

Well explained...

[@swatisingh2015]

Bhut ache sir ji

[@lybaarshadtarar4052]

Recursive and none or zero is also part of the type of relationship of cardinality

[@parthshah8057]

6:05 best action....

[@ms.shivanithakur2841]

Sir ye series complete krdo..aap bht acha krwate ho

[@vinitsingh216]

Ye dekhne ke bad 2008 ka GATE question clear ho gya, jo ab tak mujjhe galat lag rha tha. thanks

[@onkaryadav6243]

What a teacher

[@ganeshvernekar2797]

Video starts at 3:00

[@codewithshalini]

Best lecture sir

[@KNOWLEDGEGATE_kg]

Thanks,Visit tiny.cc/yt_kgwebsite for more helpful content and courses👍

[@NishaSharma-nd1dk]

Thanks sir g

[@kumariabha1382]

wow sir, really concepts clear kr dete hain ap Puri tarah .... tq

[@praveenpandey6520]

Nice sir🙏🙏

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Praveen, keep learning & supporting ! Do visit our website www.knowledgegate.in for more courses & contents !

[@zakahaider932]

Good job!

[@rkstories-z2e]

Sir, your explanation is beautiful keep it up.. Group theory ke or parts kanha hai.... Homomorphism, quationt ratio etc

[@farhadazami6147]

thank you very much ! .

[@muhammadsafiullah8428]

I wish I could give 1000 likes to your video ♥♥♥♥

[@shivamchhabra7135]

Thank you so much sir for giving ur time to us by these awesome lectures U r a very good teacher ❤️ May ur subscribers rise and rise more

[@epicclips8881]

Op Explanation Sir ❤️❤️❤️❤️❤️❤️❤️

[@saddamahmad2310]

thank you very much sir for this video

[@samarendumal8583]

sir aap ki wajah se bach gaye iss year.... uffff!!!! thank you so much...

[@amanagarwal5936]

Sir DBMS ka practical tutorials bhi banaiye na.

[@alphaprokiller7438]

sir, Relational calculus peoblems are quitr tricky in dbms.... Do make videos over problem solving of relational calculus....

[@hotmail031985]

Dear Sanchit, Will u make the Videos on System Analysis And Design Concepts along with Programming Conceptson Java!

[@SID-nh7gb]

Thanks

[@oyeitsvishal6666]

sir u r best

[@KNOWLEDGEGATE_kg]

Thanks a lot dear 😍 Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@oyeitsvishal6666]

Sure sir i will definitely visit 🥰🤗

[@monikasharma1184]

thank you sir🙏

[@AdeshPaul]

Thanks!

[@AbhishekKumar-rq4rt]

Thnku so much sir 🙏🙏

[@imshubhxmj4304]

chaliye shuru karte he

[@rohan8758]

Is this DBMS playlist cover all topics of GATE??

[@shakusharma7791]

Sir weak entity set and strong entity ka video dalo sir

[@ashishpathak3980]

Sir if you continue creating such video one day you will be like physics wallah and unacadmy ❤❤

[@twinklegarg1413]

Sir mapping constraints nd mapping cardinalitiea same hain ?

[@codeWithRisingGeek]

What will be the cardinality for follower following system like in twitter? If I have 2 separate table for users and followers?

[@rushivachhani8615]

sir please continue the er diagram lectures please

[@sarthaksharma1999]

Are these videos sufficient for preparation of gate ?

[@mehrajmeer1900]

Thxu sir!

[@bossmemes3308]

thankyou sir, just curious to know how the duster is getting attached to board?

[@KNOWLEDGEGATE_kg]

Because its a magnetic duster for white board.

[@theabhineshtilak]

GREAT

[@KNOWLEDGEGATE_kg]

Thank you! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@sachinthakkar5027]

hello sir, you content and method of explanation is very good but there is too much ads in video

[@utsachattopadhyay8049]

Thanx..

[@ujjwalkumar7048]

What's the example for N:1(many to one).

[@dhruvpolara8487]

sir shayad apne 14:26 par galti se galat samja diya gaya kya ?? kyuki m:m also 1:1 but vice versa is not possible take your adahar card exmple vo to galat hoga na plz sir explain aur agar ap rid karte ho to comment pin kar dena taki dusaro ko confusion na ho isi liye

[@KNOWLEDGEGATE_kg]

Dear Dhruv, we have checked it at our end, everything is fine in the video.

[@narendraparmar1631]

Thanks sir😆

[@anishjain8096]

Sir I am cs 1st year student and saw your lecture so how I have to prepare or make notes or how to make notes and similar query please make a vedio how I have study to crack gate

[@siddharthaghosh64]

Sir apne bola ki koi relationship 1 to 1 hai to wo many to many ho sakta hai... Par wo to aadhar card ki example me work nahi karta???

[@zubairjeelani4380]

Sir, great lecture as always but u have used Aadhar Number as an entity in your example that doesnt seem right to me. Aadhar Number can be an attribute of an indian citizen and not an entity

[@KNOWLEDGEGATE_kg]

Ok dear noted, thanks for your feedback!

[@naseemsiddiqui7298]

Sr plzz upload reccurence relation and sequence sr

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

[@saifullahshamil4707]

Exelant

[@syedarbaz3781]

Jidhar n hota h....udhar arrow lgegaa naa sir?

[@FarhanAhmed-cm2ry]

vip sir tusi great hooooooooooo

[@aasancreation8516]

आपका मतलब है वन टू वन relationship ko many to many bhi kaha ja sakta hai?

[@riabhardwaj8]

Why is there no video on ER diag practice questions

[@SomeoneSH20]

Haan sahi bole hai....yes sir plz make some practice vds

[@salokyadeb1344]

Shouldn't mobile number be an attribute? in previous videos, mobile number was considered as an attribute (multi-attribute).

[@princebhatia09]

strong and weak relationships?

[@iammayurn]

Some have 1:M, some have 1:N what is correct?

[@RohitSharma-bc3ce]

Both correct

[@Tprakh-iw6qt]

Awesome

[@KNOWLEDGEGATE_kg]

Thank you, keep learning👍

[@nidhimalhotra1941]

Adhar number cannot be an entity, it is consider as attribute.. so please don’t write Adhar no as entity as students might get confused

[@ashiskumarprasad9839]

It is totally correct, you need to study the topic

[@ch.ali7shahzad657]

J2EE k lectures plzzz

[@muj99ali]

Good 'ol days when Aadhar determined citizenship of an Indian 😂😣

[@reyazalam1391]

Can anyone tell me... How every one to one relation is many to one or one to many??

[@epicclips8881]

Fnatic Ftw ❤️❤️❤️❤️❤️❤️❤️

[@AmeerHamza-cy6km]

sir 1 to 1 jo he wo many to many nahi ho skta sirf many to many 1 to 1 ho skta he

[@jiveshshrivastav9722]

Every MANY to MANY can be ONE TO ONE but ONE to ONE can't be MANY to MANY I think he said the opposite...

[@aayushmakkar7566]

NO. every ONE TO ONE can be called many to many. But any MANY TO MANY can't be ONE TO ONE as it will violate the definition of ONE TO ONE.

[@vyrl4145]

Sir your lecture is somehow missing something...like without explaining what is cardinality you started teaching cardinality mapping...you taught foreign key without explaining

[@monolito8556]

i see english words in the whiteboard, but listen tonguetwister... have any dubbed or subbed video?

[@KNOWLEDGEGATE_kg]

No dear!

[@paulomisadhukhan2774]

1 to 1 as in first example can not be one to many