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

  Рет қаралды 130,615

CS & IT Tutorials by Vrushali 👩‍🎓

CS & IT Tutorials by Vrushali 👩‍🎓

Күн бұрын

Пікірлер: 43
@shanthapriyamanikandan4756
@shanthapriyamanikandan4756 2 жыл бұрын
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
@laxmisarika2338 2 жыл бұрын
Not 7 tables..! 7 rules are there!
@santhoshreddy4464
@santhoshreddy4464 Жыл бұрын
yes I guess u r right at last the final table is wrong I guess Bcz m:n relation have three tables
@santhoshreddy4464
@santhoshreddy4464 Жыл бұрын
may be total 7 tables
@tushar7305
@tushar7305 Жыл бұрын
Also in the subject we should have lecture id and course id
@zainkhanz1
@zainkhanz1 6 ай бұрын
yes you are right
@dipayankanrar1145
@dipayankanrar1145 Жыл бұрын
very simple and easy explanation ,its very easy to understand
@stalinanthony
@stalinanthony 8 ай бұрын
Thank you so much maa'm it was very helpful
@rswm939
@rswm939 Жыл бұрын
Superb 😊👍👍... Clear and simple !! Pls make more !
@Crazy_moments_of_footbal-qz1qr
@Crazy_moments_of_footbal-qz1qr 6 ай бұрын
you made it absolutely easy madam!!!!!!!!!👏👏👏👏👏👏👏👏👏
@csittutorialsbyvrushali
@csittutorialsbyvrushali 3 ай бұрын
Thanks😊. Keep Learning👍
@Banditxam4
@Banditxam4 Жыл бұрын
Tq ma'am back paper test hai kal... This video helped me a lot
@chandlerzhao181
@chandlerzhao181 11 ай бұрын
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?
@vijaykhetre5678
@vijaykhetre5678 2 жыл бұрын
Nice teaching 😊👍
@austineodhiambo4095
@austineodhiambo4095 Жыл бұрын
No questions, superb
@nikhilkamode9090
@nikhilkamode9090 11 ай бұрын
Aabhari aahe 😊
@maryamakbar8772
@maryamakbar8772 Жыл бұрын
How can we solve if we have both maximum and minimum cardinality
@sakshikhangar4819
@sakshikhangar4819 7 ай бұрын
Thank you so much
@csittutorialsbyvrushali
@csittutorialsbyvrushali 3 ай бұрын
Welcome😊. Keep Learning👍
@AnkiitOp
@AnkiitOp 2 жыл бұрын
Case 3 and Case 4 way 01 is Similar ?
@binodsadhikari3878
@binodsadhikari3878 11 ай бұрын
There must be primary for rollno and mobile no both in multivalued attribute
@mangalwagh8694
@mangalwagh8694 Жыл бұрын
Very nice video 👍👍
@Umais_Rasheed
@Umais_Rasheed 24 күн бұрын
6:00 Mam so we ignore the remaning attributes ?
@BluePaneTechnologies-nu4hh
@BluePaneTechnologies-nu4hh 7 ай бұрын
great...thnx
@csittutorialsbyvrushali
@csittutorialsbyvrushali 3 ай бұрын
Welcome😊. Keep Learning👍
@LiyaGahnug
@LiyaGahnug 9 ай бұрын
thank you
@bablutadikonda1812
@bablutadikonda1812 Жыл бұрын
Here we need to check data redundancy also know then how to check it ?
@isuruanuranga
@isuruanuranga Жыл бұрын
thanks
@subhashthakur7352
@subhashthakur7352 Жыл бұрын
Firstly , the relationship is not possible between the entities if there is not even a single same attribute in each entity.
@Ashitha08
@Ashitha08 4 ай бұрын
7 tables should be there in the last eg
@Islamic_thoughts387
@Islamic_thoughts387 4 ай бұрын
Ma'am Jo ap ny example di table k sth ER diagram ki... Uski statement b bta dein kindly!!???.
@milanstefanovic5090
@milanstefanovic5090 5 ай бұрын
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
@milanstefanovic5090 5 ай бұрын
Instead of 5 we should have 7***
@IsayaOdongo
@IsayaOdongo Жыл бұрын
No 4 Explantion is not clear why leave out emp name,salary dept name
@shivanshusawan423
@shivanshusawan423 7 ай бұрын
How to get slides
@maazsatti8375
@maazsatti8375 Жыл бұрын
What if there is no primary key?
@nikhilkamode9090
@nikhilkamode9090 11 ай бұрын
+1
@MJ.bucketlist_
@MJ.bucketlist_ 10 ай бұрын
Mam..you left age?
@itsecurity2423
@itsecurity2423 8 ай бұрын
mam you are confusing the students in explaining rule No4, you are not explaining completely. kindly avoid confusion in your videos plz
@sakshiarya2991
@sakshiarya2991 3 ай бұрын
@@itsecurity2423 bhai confuse ki baat kya dono trike he represent krne ke
@harishwarreddy7628
@harishwarreddy7628 Жыл бұрын
worst explanation
@Bright-Plans
@Bright-Plans Жыл бұрын
💝
@amirhosein5677y
@amirhosein5677y 27 күн бұрын
Thanks
DBMS 9:  ER Diagram of Library Management System | Bus Ticketing System | Online Shopping System
9:10
CS & IT Tutorials by Vrushali 👩‍🎓
Рет қаралды 17 М.
Example 1: Transforming ER Diagrams to a Relational Schema
21:48
OrangeOutputs
Рет қаралды 448 М.
Players push long pins through a cardboard box attempting to pop the balloon!
00:31
Миллионер | 3 - серия
36:09
Million Show
Рет қаралды 2,1 МЛН
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,6 МЛН
DBMS 17: Normalization in DBMS | 1NF 2NF 3NF 4NF BCNF | DBMS / SQL Tutorial for Beginners
15:50
CS & IT Tutorials by Vrushali 👩‍🎓
Рет қаралды 8 М.
Converting an ER Diagram to a Relational Table (or Schema)
7:41
Ritu Kapur Classes
Рет қаралды 637 М.
How to convert an ER diagram to the Relational Data Model
11:39
Søren Spangsberg Jørgensen
Рет қаралды 660 М.
Converting ER Diagrams to Schemas | SQL | Tutorial 23
12:25
Giraffe Academy
Рет қаралды 193 М.
DBMS 7: ER Model | Components of ER Model | Entity | Attributes | Relations with Examples
9:55
CS & IT Tutorials by Vrushali 👩‍🎓
Рет қаралды 9 М.
Players push long pins through a cardboard box attempting to pop the balloon!
00:31