Lecture 3: ER Model Explained || ER Diagram Notations || DBMS for Placements

[@narutodihargo]

02:02=What is Entity ? , 08:33= Primary key, 10:21=Entity set, 11:30=Attribute, 12:24= Relationship between Entities, 16:13= Customer-Loan ER Model, 21:55=Types of Attributes, 29:10 - What does NULL specifies in Database? 31:58 - What are Strong and Weak Relationships? 37:53 - Degree of Relationship (Unary/Binary/Ternary Relationships) 41:00 - Mapping Cardinality (1:1, 1:N, N:1, N:M) 47:40 - Participation Constraints (Partial & Total Participation)

[@shantanuhallur6825]

Best Course found on DBMS till now ... Lakshay Bhaiyya Really thank you sooo much for your efforts ... !!! Please keep us teaching like this... and we promise you we will definitely complete this course and attend the lectures till the last one ! OP Teaching ++

[@lakshaykumar7518]

Keep learning buddy!

[@KeigoEdits]

Bro ek doubt h, 49:05 m why the relationship is strong and not weak when we have a weak entity

[@surajitroy2624]

abhi tk jo bhi paraya hai youtube me sbse accha laga aapka lecture itna accha concept samjhana koi aapse sikhe, love you bhaiya 💕😊 carry on 💯❣️

[@VishalGupta-xw2rp]

You are a Savior for this and all upcoming Generations. This channel will go down in the history as one of the Best life-changing channel 🔥♥️🤩

[@moazzammajid5949]

Best course , I am following this playlist with my whole heart. Love the way he teaches, he makes the topics so simple to understand. Plz continue teaching like this . Love u sir.

[@priyanshpatel2078]

So now i complete this lecture i know about this all things but i learn from this lecture lot of 🔥 I give me for this lecture 2:30hour and prepare notes of 7.5 pages 💓

[@bijayanayak1032]

Keep growing 👍

[@Amankumar_Raone]

Send notes

[@basitkhan6121]

I have watched three lectures, and after watching each lecturer my level of interest is increasing.

[@ashwinikadam4914]

15 jan. 2024 First lecture's revision done. 👍 Second lecture's revision done. 👍 Third lecture understood. 👍 Third lecture's revision done. 👍 Thank you bhaiyya ❤

[@jaydeeppatidar4189]

The way you are explaining this things easily is much appreciated! Thank you!

[@tmhd48_abhishekbade78]

Brother your teaching method is ingenious.

[@Jai-xq5hi]

Amazing video bhaiya Ek hi video me Er model ke sab topic karwa diye wo bhi itne aasani se 💥

[@sanchiagarwal4909]

DBMS ER Diagram Understood ..Thank you for the efforts🙌🏻🔥

[@amanahirwar9236]

thank you lakshay bhaiyya, I am working hard for about 7 months consecutively, and without your content that would be impossible. I will get a stable well-paid job considering my skillset, thank you wish you and love bhaiyya all the luck.

[@sandhyakamurti]

Waiting for your CN series also🔥

[@parthsalat]

I'm waiting for Avatar 2 to release 🙃

[@bartosz3667]

I am waiting for my girlfriend since my childhood

[@userharsh9710]

System analysis and design too

[@devendrabhuarya4917]

I am waiting for Loki s2

[@shivamkumar-nk5vv]

Waiting for kgf3

[@NishaSharma-gr9vu]

Best teacher

[@poojamarmat9920]

the best DBMS series I have ever seen! 🙌

[@vaibhavnayak3416]

You explained every topic very well. No wonder why you were promoted. Thanks, Lakshay bhayya and Babber bhayya for this course.

[@ayushchoubey707]

3rd lecture done successfully clear hoo gaye saare doubts ER diagrams ke Maza aa gaya bhaiya!!

[@zeeshan1019]

Are lallantop video🔥 Bht aache s btaya aapne bhaiya

[@sudarshan3901]

Notes ke sath padhne me maja aa raha hai ... Thank you for this series....

[@anshikadubey2729]

46:17 there is a small error course taken by professor is a many-to-many relationship not many to one because a professor can teach many courses, and a course can be taught by many professors.

[@kanhadehury7316]

I knew about ER model but now It's crystal clear #completed_Lecture_3_DBMS

[@suvadipkhanra2245]

completed sucessfully

[@nikhilbatra3671]

Thank you for breaking down such a complex topic in such an understandable way.

[@KeigoEdits]

Bro ek doubt h, 49:05 m why the relationship is strong and not weak when we have a weak entity

[@AyushPatel-fv2wc]

this series is awesome... please start series of *computer network*

[@peterpace3379]

Pehle isko complete ho jane do

[@Polymath1729]

Thanks a lot sir you are one of the best teacher to teach everything in such depth ....keep teaching like this🦁🦁🐯🐅🐆🦁🦁🦁🦁🦁🦁🦁

[@jatinkalra322]

Awesome Lecture🔥🔥...thank you so much bhaiya❤

[@spravalika6668]

such a friendly and amazing way of explantion . i really loved it.

[@divyanshubse]

Nice explanation clear all points in easy way with no boring feeling pata hi nahi video kab complete ho jati hai all points explain with realtime and good example but sir I have requested to you make such series on computer network and system design also. ❤❤ Thanku

[@soumyaranjansamalkiit]

This is the perfect video on ER Model !

[@hirenparkar7480]

understood complete lecture very clearly, thanks for the real life examples it helps to remember the concept very well 😍

[@suyashjain3223]

Crystal Clear Explanation!! Thanks❣

[@Dexter.317]

the way you say bhot he badiya after explaining that kicks me and says that wow it isnt so difficult

[@YashJaiswal-e6w]

Done..Well Explained each and everything👍

[@amansamal8233]

Thank you for your wonderful lectures!!

[@HEMANTPORWAL-t7d]

I guess professors are sir's favorite He used to embed professor in his every example

[@lalitbisht8381]

Understood almost everything about ER MODEL❤

[@AnkitKumar-ql8gh]

KZbin----[Love Babbar]------DBMS Course is the best example of ER Model

[@summaiyas3312]

Best Course found on DBMS 💫

[@piyushupreti8079]

I'm preparing for IT officer- Banking. These videos are tremendously helpful for understanding the concept from a really practical POV. Grateful to you Lakshay Bhaiyya and Love bhaiyya.

[@priyam6496]

UCO Bank?

[@sakshisah3130]

really enjoyed the video .Very nicely explained

[@saikatraj]

4th video completed. Thank You.

[@anandshinde0358]

Thank you so much❤❤❤

[@ankitpathak9334]

Superbb explaination. Appreciatable💯💯

[@UECAshutoshKumar]

Thank you

[@codingculture6166]

bhaiya one suggestion , when you start a topic please try to finish it there only. Like for example you started attributes and then there you didn't discussed the types there. then you started Relationship there also types were discussed later. Main problem in this is when i'm making notes then starting one topic has to be finished there so that notes end up sequentially . rest everything is fabulous .

[@0708Sunshine]

Thanks a tonne for all the effort, it is highly appreciated

[@anishborse1924]

Great Course!!!

[@arunyadav7467]

Please complete this series fast it already took 2 months

[@syworld7]

Thank you so much for this wonderful course i appreciate both of you 🙏🙏🙏

[@jigyasayadav6658]

best videos for dbms i cam upon.

[@rumiNITPatna]

thank u so much ! amazing video!

[@GyaanGrave]

Hi! I and my 10 friends decided to watch this series! Thanks for the quality content!

[@kirtirattan161]

Thank you for explaining it briefly.

[@deepanshuraj5847]

thankyou it was fast paced with good explanation combination we rarely get

[@JARVI832]

discussion on these topics with a person who work in industry is very different then any class video ex. in one to one relation their is no need because no redundancy i can be wrong sooooooooooooo. these videos are very help full

[@nischayagrawalVlogs]

Students to Lakshay sir - Careful! he is a hero!

[@gauravdev5884]

Amazing series so far bhaiya ❤️🔥 CN ka bhi daal hi do bhaiya series 🫡

[@laughternights]

Thank you❤❤❤ bhaiya

[@ayushmansharma3293]

The explanation was really good!

[@jagmohanraijagmohanrai4882]

Nyc video for making us confident.

[@Abhishekpandey2000]

Nice One bhaiya

[@iranjansharma12]

00:00 Introduction 02:02 What is Entity ? 08:33 Primary key 10:21 Entity set 11:30 Attribute 12:24 Relationship between Entities 16:13 Customer-Loan ER Model 21:55 Types of Attributes 29:10 What does NULL specifies in Database? 31:58 What are Strong and Weak Relationships? 37:53 Degree of Relationship (Unary/Binary/Ternary Relationships) 41:00 Mapping Cardinality (1:1, 1:N, N:1, N:M) 47:40 Participation Constraints (Partial & Total Participation)

[@saketsabane908]

Day 3 of learning DBMS! Consistency++

[@dvaderaws]

I am here on Day 3. Amazing as always. :D

[@ankushkashyap931]

Day 3 of starting this course for my placement preparation.

[@prathamgoel3386]

Day 1 successfully completed

[@amrutadange7276]

Bhaiya please start series on cn too 🙏

[@faheemazmi9659]

Enjoying the DBMS series

[@rohit_ojha]

Thanks bhaiya

[@rajeevraushan2049]

Maza Aaya Bhaiya padhne me. Thanks bhaiya

[@priyanshpatel2078]

After 2 Lecture We here to clear ER Model 🔥

[@dhruvsaboo7719]

lec 3 done bhaiyaa

[@naman2_3]

SUPER + AMAZING ❤❤❤❤

[@ganeshmula4508]

Great lecture,thank you sir

[@yashwantptl7]

bohot hi badhiya

[@TusharArora-b7i]

Great Content😀😀😀😀

[@sanketgoel6453]

keep giving these real life engaging examples🔥

[@balmukundkanodia6776]

Completed lecture 3 😃❤

[@LuckyRathod20]

Thank you! very easy Explaination ✨

[@andrewbeef8758]

is channel ko jyada se jyada subscribe karo bhailog please ,

[@ankushladani496]

Thank you sirji... Maja aa gaya.. .🚀

[@rohitborse7782]

🙇♥️se dhnywad sir 💯🥰

[@surakshitkapoormathsc1910]

Bhaiya, computer networks ki bhi playlist bna do. It's really helpful.

[@alheraahmad5481]

amazing work!

[@adityavamsi12]

Attendance Marked Bhaiya ❤️🔥

[@056ankitchauhan4]

Great Teaching

[@ganagour_gurjar_community]

Bhaiya upload lecture on daily basis.

[@SUNILKUMAR-ll1bq]

awesome lecture.......thank you so much bhaiya

[@Ankit.yt_885]

Great Explanation Again!

[@nidhisaidhi]

Lecture 3 completed 💯

[@lalitmehra1631]

Amazing lacture

[@mobilepointzone5565]

00:03 ER Model is a powerful data model 02:20 The ER model is a high-level model of relationships and attributes in a database. 07:10 Unique identification of entities in a database 10:04 ER Model Explained: Understanding Attributes in the context of Student 14:43 ER Model is a high level model that represents relationships between objects. 17:44 ER model diagrams serve as blueprints for designing a database 21:37 Understanding the concept of dividing data into parts 23:24 The ER model allows for the separate storage of address components 27:11 Address system has four parts: street, city, state, and zip code. 29:13 The 'Handle' attribute in the ER Model has three meanings - note, narbali, and null 33:19 Understanding the relationship between loans and payments in a banking system 35:26 The payment and loan are connected through a strong entity in the ER model. 39:25 ER model relationship types and examples 41:44 Understanding the association between two entities in an ER diagram 46:24 Total participation in a relationship means all entries are mandatory 48:46 Understanding participation constraints in ER model 53:20 ER Diagram Notations Crafted by Merlin AI.

[@fazerugbrug439]

superb

[@kuntalbanerjee6903]

Great Lecture!

[@DoubleL_Leo]

THANK YOU BHAIYA

[@Satscool786]

Bhot hi badhiya👍😜😜

[@surajkumarsahoo1565]

mast samja aya bhiya

[@devbhattacharya153]

Thanks a lot bhaiya!!!

[@sanket3236]

One more example of Ternary relationship is : booking a movie in particular theatre by particular user :)