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 🙏🙏🙏🙏🙏

[@shivangisrivastava1158]

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

[@kanakmittal3756]

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

[@SaumyaSharma007]

Bro it's more of a one to many relationship

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

[@saurabhgupta7785]

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

[@rahulimishra9322]

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

[@faizanbhatti5489]

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

[@KNOWLEDGEGATE_kg]

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

[@lsuremusic3787]

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

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

[@MusicCorpo]

Concept is crystal and clear 😌

[@KNOWLEDGEGATE_kg]

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

[@shubhambhatia4968]

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

[@uditchaudhary9318]

something

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

[@sharmilanag6296]

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

[@Nitimoy]

thak hoyeche

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

[@saketkumar4972]

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

[@dheerajtiwari9923]

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

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

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

[@skittles6486]

Sir, can you please make video on EER Model?

[@akakop]

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

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

[@uzairtanveer9140]

awesome series . Thank you so much

[@uditchaudhary9318]

"something"

[@NishaSharma-nd1dk]

Thanks sir g

[@muhammadsafiullah8428]

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

[@zeeshanparacha1940]

sir you are amazing teacher love from pakistan

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

[@onkaryadav6243]

What a teacher

[@AhamedKabeer-wn1jb]

Well explained...

[@praveenpandey6520]

Nice sir🙏🙏

[@KNOWLEDGEGATE_kg]

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

[@epicclips8881]

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

[@farhadazami6147]

thank you very much ! .

[@vinitsingh216]

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

[@ms.shivanithakur2841]

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

[@pulkitgoel2638]

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

[@theabhineshtilak]

GREAT

[@KNOWLEDGEGATE_kg]

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

[@AdeshPaul]

Thanks!

[@zakahaider932]

Good job!

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

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

[@swatisingh2015]

Bhut ache sir ji

[@AbhishekKumar-rq4rt]

Thnku so much sir 🙏🙏

[@monikasharma1184]

thank you sir🙏

[@saddamahmad2310]

thank you very much sir for this video

[@uditchaudhary9318]

'something'

[@mehrajmeer1900]

Thxu sir!

[@parth_shah_99]

6:05 best action....

[@twinklegarg1413]

Sir mapping constraints nd mapping cardinalitiea same hain ?

[@SID-nh7gb]

Thanks

[@lybaarshadtarar4052]

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

[@rkstories-z2e]

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

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

[@codewithshalini]

Best lecture sir

[@KNOWLEDGEGATE_kg]

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

[@kumariabha1382]

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

[@Tprakh-iw6qt]

Awesome

[@KNOWLEDGEGATE_kg]

Thank you, keep learning👍

[@shakusharma7791]

Sir weak entity set and strong entity ka video dalo sir

[@amanagarwal5936]

Sir DBMS ka practical tutorials bhi banaiye na.

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

[@rohan8758]

Is this DBMS playlist cover all topics of GATE??

[@ganeshvernekar2797]

Video starts at 3:00

[@utsachattopadhyay8049]

Thanx..

[@samarendumal8583]

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

[@narendraparmar1631]

Thanks sir😆

[@sarthaksharma1999]

Are these videos sufficient for preparation of gate ?

[@ashishpathak3980]

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

[@rushivachhani8615]

sir please continue the er diagram lectures please

[@alphaprokiller7438]

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

[@saifullahshamil4707]

Exelant

[@hotmail031985]

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

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

[@sachinthakkar5027]

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

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

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

[@syedarbaz3781]

Jidhar n hota h....udhar arrow lgegaa naa 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

[@imshubhxmj4304]

chaliye shuru karte he

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

[@codeWithRisingGeek]

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

[@ujjwalkumar7048]

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

[@salokyadeb1344]

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

[@riabhardwaj8]

Why is there no video on ER diag practice questions

[@SomeoneSH20]

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

[@aasancreation8516]

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

[@FarhanAhmed-cm2ry]

vip sir tusi great hooooooooooo

[@naseemsiddiqui7298]

Sr plzz upload reccurence relation and sequence sr

[@epicclips8881]

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

[@reyazalam1391]

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

[@princebhatia09]

strong and weak relationships?

[@monolito8556]

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

[@KNOWLEDGEGATE_kg]

No dear!

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

[@iammayurn]

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

[@RohitSharma-bc3ce]

Both correct

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

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

[@muj99ali]

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

[@ch.ali7shahzad657]

J2EE k lectures plzzz

[@mkpkartik1359]

1:1 is also 1:n how? Please explain still confused

[@shimulbhattacharjee9560]

I think because one entity can be related with maximum n entities. So, if it is 1:1 relationship then it can have 1:n relationship.

[@Ali_Murtaza_Memon]

Sir every many to many relation is also called as one to one, or sir correct me if i am wrong.

[@paulomisadhukhan2774]

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