DBMS 8: Converting ER Diagrams into Tables with Example | ER Model | DBMS Tutorial for Beginners

Connect with me by:
LIKE & SHARE Videos with your friends.
SUBSCRIBE ‪@csittutorialsbyvrushali‬
Instagram: / cs_and_it_tutorial_by_...
Facebook: / cs-it-tutorials-by-vru...
DATABASE MANAGEMENT SYSTEM:
• Database Management Sy...
MACHINE LEARNING USING PYTHON:
• Machine Learning Using...
DATA STRUCTURE & ALGORITHMS:
• Data Structure (FDS / ...
HUMAN COMPUTER INTERACTION :
• Human Computer Interac...
SYSTEM PROGRAMMING / COMPILER DESIGNING:
• System Programming / C...
PROCESSOR ARCHITECTURE & INTERFACE:
• Processor Architecture...
EXAM / INTERVIEW PREPARATION:
• Exam / Interview Prepa...
PROJECT/ PRESENTATION & FREE CERTIFICATION IDEAS:
• Project, Presentation ...
Keep Watching..!
Keep Learning..!
Thank You..!
#ermodel #dbmstutorials #dbms #dbmslectures #erdiagramintotable #sql #sqlcommands #sqlserver #sqltutorial #sqltutorialforbeginners #trending #vrushali

[@milanstefanovic5090]

Last table is not good, we have 2 M to N relationships, so we should have 2more Junction tables so instead of 4tables we should have 6

[@milanstefanovic5090]

Instead of 5 we should have 7***

[@shanthapriyamanikandan4756]

totally 7 tables should be there isn't it, bcuz acc to the rule many to many relationship has to have a seperate table for relationship as well ryt ?

[@laxmisarika2338]

Not 7 tables..! 7 rules are there!

[@santhoshreddy4464]

yes I guess u r right at last the final table is wrong I guess
Bcz m:n relation have three tables

[@santhoshreddy4464]

may be total 7 tables

[@tushar7305]

Also in the subject we should have lecture id and course id

[@zainkhanz1]

yes you are right

[@Ashitha08]

7 tables should be there in the last eg

[@itsecurity2423]

mam you are confusing the students in explaining rule No4, you are not explaining completely. kindly avoid confusion in your videos plz

[@sakshiarya2991]

@@itsecurity2423 bhai confuse ki baat kya dono trike he represent krne ke

[@maryamakbar8772]

How can we solve if we have both maximum and minimum cardinality

[@stalinanthony]

Thank you so much maa'm it was very helpful

[@chandlerzhao181]

Very good video and easy to understand! 👍 ！ I got a question about the last example, the M:N relationship between the students and lectures, also between the students and courses, but the logical model diagram does not present this. Do we need to present both the M:N relationship when we modling the data?

[@rswm939]

Superb 😊👍👍... Clear and simple !! Pls make more !

[@vijaykhetre5678]

Nice teaching 😊👍

[@dipayankanrar1145]

very simple and easy explanation ,its very easy to understand

[@MJ.bucketlist_]

Mam..you left age?

[@AnkiitOp]

Case 3 and Case 4 way 01 is Similar ?

[@Banditxam4]

Tq ma'am back paper test hai kal...
This video helped me a lot

[@Islamic_thoughts387]

Ma'am Jo ap ny example di table k sth ER diagram ki... Uski statement b bta dein kindly!!???.

[@nikhilkamode9090]

Aabhari aahe 😊

[@IsayaOdongo]

No 4 Explantion is not clear why leave out emp name,salary dept name

[@Crazy_moments_of_footbal-qz1qr]

you made it absolutely easy madam!!!!!!!!!👏👏👏👏👏👏👏👏👏

[@csittutorialsbyvrushali]

Thanks😊. Keep Learning👍

[@isuruanuranga]

thanks

[@binodsadhikari3878]

There must be primary for rollno and mobile no both in multivalued attribute

[@subhashthakur7352]

Firstly , the relationship is not possible between the entities if there is not even a single same attribute in each entity.

[@shivanshusawan423]

How to get slides

[@sakshikhangar4819]

Thank you so much

[@csittutorialsbyvrushali]

Welcome😊. Keep Learning👍

[@mangalwagh8694]

Very nice video 👍👍

[@bablutadikonda1812]

Here we need to check data redundancy also know then how to check it ?

[@harishwarreddy7628]

worst explanation

[@BluePaneTechnologies-nu4hh]

great...thnx

[@csittutorialsbyvrushali]

Welcome😊. Keep Learning👍

[@LiyaGahnug]

thank you

[@maazsatti8375]

What if there is no primary key?

[@nikhilkamode9090]

+1

[@austineodhiambo4095]

No questions, superb

[@Bright-Plans]

💝