Sign up now
to enroll in courses, follow best educators, interact with the community and track your progress.
Download
Concept of 1NF, 2NF, 3NF and BCNF With Examples (in Hindi)
1,210 plays

More
This course will cover Normalization in Databases with 25 Previous Year Questions plus some practice questions from beginning level to expert.

Sweta Kumari is teaching live on Unacademy Plus

Sweta Kumari
YouTuber (channel : GATE NoteBook) | Verified Educator | 2+ year Online Teaching Experience

Comments
(11)
U
Unacademy user
awesome lessons .. :)
PR
Hello Miss, Still I have confusion to understand 1NF, 2NF , 3NF Please help
Jk
there should not be transitive dependency in 3nf right? but in tricks you have written that there should ..i am confused
these are really useful mam... thanku🙂
mam i have a doubt... E fully dependent kaise hai? bcz E is determined by D and D is a non prime attribute..then E fully dependent q hai? then non prime attribute koi non prime attribute ko determine karnese v fully dependency preserve hoti hai?
Sweta Kumari
8 months ago
Are you mixing the examples of 2 NF and 3NF...IN which example, you are having confusion?
Debasree Samadder
8 months ago
2 NF example mam.
Sweta Kumari
8 months ago
in full Dependency your non prime attribute should be dependent on either full C.K or no C.K .....
Debasree Samadder
8 months ago
ok mam
Sweta Kumari
8 months ago
clear or not ?
Debasree Samadder
8 months ago
clear mam
Sweta Kumari
8 months ago
great
my day 1 of month 1...thanks mam for creating this course ... life has become so easy for u mam... before i watched ur videos pure din bit jatete proper study resources dhundne..thank u mam
Sweta Kumari
8 months ago
Great 👍👍👍👍👍
View More