3NF || THIRD NORMAL FORM IN DBMS WITH EXAMPLE
Вставка
- Опубліковано 13 жов 2024
- 3NF || THIRD NORMAL FORM IN DBMS WITH EXAMPLE
✨Work related mails can be sent on:
work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadi...
Sorry to say but I didn't understand why you are using exam Id and even though u create a new table, total marks still depends on the type of exam right. So there still exists transitive dependency.
Oh yes, you're right. I'm sorry.
There shouldn't be exam_id.
So
Score table (score_id, stud_id, sub_id, marks, exam_name)
Exam table (exam_name, total_marks)
Now transitive dependency is removed, right?
@@crackconcepts but in exam table, total marks still depends on exam name, then transitive dependency still exists in that table.? I am sorry if I am wrong but I didn't get u. I mean how u r removing transitive dependency.?
@@naveenshagala3136 yes, you're right but in exam table, exam_name becomes a primary key.
So the other columns are dependent on only one primary key and transitive dependency is removed.
@@naveenshagala3136 I'll make another video if it's still not clear
@@crackconcepts now I have understood. Exam name wil become primary key and total marks depends on primary key, so transitive dependency is removed. Thank you for clarifying my doubt. I got confused with exam Id. But now it's clear.
Legends studies this on exam morning🤣🤣🤣
It's me
Yes
Im a legend
Bhai tuu pakka topper hye aur you are trying to act normal 😂
You know
you are such an amazing teacher and your voice is soo soothing
Hey Sadia, great videos on SQL and DBMS, I watched all of it. Amazing way of teaching. It helped me a lot.
Best video on Internet today for DBMS..
Hatsoff!
i was really getting distracted while studying, but then came ur video , i must really say what a soothing voice u have!! really pleasing !
me watching this 2 hours before my end sem can't thank you more 🙌🏻
after a 1 year im doing the same 🥲
@@sahanirandula3527This is on loop 😢
YOU EXPLAIN 100 TIMES BETTER THAN MY TEACHER , TY : )
:)
Wowww what an explanation girl🔥🔥🔥 one day to go for my exam and this video helps me to understand most complicated topic with in just 6mins 😍
4 min ka hai bhai
@@kartikeysingh1298 1 hour 🙂
Great Explanation! This really helps me to understand the difference between 2NF and 3NF :)
thank you so much u have no Idea how much i have been searching for a video where i can understand normal forms , this video made me understand it better now it's all coming together of what my sir has been trying to tell me all this time and i couldn't understand a thing 😂
I UNDERSTOOD 3NF. THANKYOU !
Third term watching this and it does not fail me 😂😂exams in 3hrs
Short and sweet as well as informative
Thank you so much I have exam today afternoon very good explanation 😀
Thankyou for the videos, they're very helpful
2 Thumbs up and 5 stars to the lady and this channel
And most important thing, these are by far the best explanations on DBMS.
Your explanation just made it so simple for me to understand and that spellbounding voice of yours just made me so stress free, extremely thankful to you for your hardwork, keep it up .
Lecture 10/10
And the voice also 😍
Please make video on bcnf
nicely described . all doubts gone.... thanks a lot ..
mam this video really help full for me and after 3 days my DBMS exam😁😁😁😁😁😁 Thanks mam
BCNF is not there in the playlist.
Can u recommend any channel where i can understand the concept of BCNF.
Ma Shaa Allah great explanation sister.
Such an amzaing expalaination sadia
Although this is 4 years old, I do appreciate your method of explanation. But please can you make another one for this 3NF saying that the new table has only two columns. Because for a new person(Like ME), until they do not go through the comments, they have no idea why a new column was created
From where we get the exam id.... Which is not mention in the question?? Can u Plz elaborate???
Super now i got understood after many days but missing bcnf 4nf and 5nf
thank you so much made everything so simple to understand😅
Oh Thanku sis🤧👍🏻👍🏻👍🏻
Tqsm it helped me in my exam
amazing explanation! well done
Great explanation keep making videos
Hi mam, Can you please upload video on BCNF as well.
I never skip an AD , thats the only way I can return the help whatever u have thought us
That’s really kind of you
You are such a wonderful explainer...🤗i really appreciate it
nice explanation
Best teacher
Wow, best video
Lovely explanation tqsm 🥰
God Bless You Mam, very well explained 😊
Thank you for the video!
✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
The way you write 20 looks like 10 in Bengali numerals.
simply super
Ur vidios all are awesome🥰
Excellent work 👍
Thanks 👍
best explanantion
Thank you...where is BCNF
Good job dear, make more videos on dbms
Thanks a lot mam💥
Short and best
Very yuse full one😇
thank you for this video
okay...😊
Yr aapne 5 nf k upr bnai h video?
Don't you think 2nf is more restrictive than 3nf .. in 3nf we are removing all columns which are dependent on non-prime keys . But in 2nf we are removing all columns which are dependent only a part of primary key. Let's discuss more in comments please
Kisiko itna gyann hota to basic dekhne aata yaha
@@kartikeysingh1298 thanks for talking in hindi , now everybody in the universe will understand not just humans !
@@HarishAmarnath hope u understand too... Becoz humans are enough intelligent to understand their mother tongue
Mam ur explanation is superb..Can u make videos in BCNF,4NF,5NF also mam
maam can u do vdo about BCNF PLZZZ😢❤
Really usefull
I am here before 5 hours of exam 😂😂
Great
thank you di😊
noiceeeee
Can u pls make a video on bcnf..??
Nii
Thanks for saving mi results 🔥
2 after hours is my exam..😂
Great explanation ❤️...by the way ur voice is very nyc 💥❣️
explain BCNF .
4nf and 5nf upload madam
What happens if exam name have null values then how you make it primary key.
You make an optional relation between the entities
Mashallah
Super
well explained.
🙇🏻❤️
Excellent
please add bcnf
Please keep BCNF video
Noice
⁰p
Thank you