THIRD NORMAL FORM (3NF) IN NORMALIZATION || NORMAL FORMS || 1NF, 2NF, 3NF, BCNF, 4NF & 5NF || DBMS
Рет қаралды 30,096
INTRODUCTION TO NORMALIZATION
1. 1NF - FIRST NORMAL FORM
2. 2NF - SECOND NORMAL FORM
3. 3NF - THIRD NORMAL FORM
4. BCNF - BOYCE CODD NORMAL FORM
5. 4NF - FOURTH NORMAL FORM
6. 5NF - FIFTH NORMAL FORM
-------------------------------------------------------------------------------------
DATABASE MANAGEMENT SYSTEM
kzfaq.info/sun/PLLOxZwkBK52B6FqMOu6FfU4_5Id2cBStN
HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10
kzfaq.info/get/bejne/bMpzY9ubya-0imQ.html
PYTHON PROGRAMS
kzfaq.info/sun/PLLOxZwkBK52BC-U5nWzUm6dBsFIFRtQuO
C PROGRAMMING
kzfaq.info/get/bejne/l7uhgpCVzOCxp2g.html
CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
kzfaq.info/get/bejne/kKyehdmh3dbSf5c.html
HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
kzfaq.info/get/bejne/l56HbJhjs6i-hXk.html
LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
kzfaq.info/get/bejne/lZOkhZiAtrmZk30.html
JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
kzfaq.info/get/bejne/eLqldt2Xy7HMaHk.html
PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
kzfaq.info/get/bejne/b86Grah8v7fdfYk.html
PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
kzfaq.info/get/bejne/eJOCntug2dSdf58.html
PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
kzfaq.info/get/bejne/ppibkpx6mbyriac.html
PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
kzfaq.info/get/bejne/mNiXrbd73K6te30.html
MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
kzfaq.info/sun/PLLOxZwkBK52BQjsMFcnOB0wjzAUneSNfI
PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
kzfaq.info/sun/PLLOxZwkBK52CIfeg1YISebeYu2Cfc_6Pl
DATA STRUCTURES USING PYTHON (ENGLISH)
kzfaq.info/sun/PLLOxZwkBK52Apt7hZ--6D5q1QY6uQ6vgt
----------------------------------------------------------------------------------------------
Instagram : sundeepsaradhikanthety
@adventure_6043 Жыл бұрын
Me too believe you for my semester. You are an excellent teacher
@amannmahapatra6118 Жыл бұрын
i always trust you for my semester subjects
@jeevankumar659 7 ай бұрын
We have to really appreciate the hard work and dedication you have put on these videos for students. Keep going sir, hopefully you will reach your goal.
@hiteshperni4157 Жыл бұрын
Sir,it was amazing.i can understand ur lectures.......
@doggcript3949 10 ай бұрын
Thank you sir, you help me a lot!
@amishadas3958 Жыл бұрын
Thank u very much 💖🥰
@amannmahapatra6118 Жыл бұрын
Hello sir thank you for your contribution
@smithagv6296 Жыл бұрын
Please share BCNF 4NF and 5NF
@fog2640 10 ай бұрын
finished watching
@anishkumarmishra9620 8 ай бұрын
All about your teaching good sir . But in last u didn't explained how transitive dependency is removed after decomposing. Same as for 2nf and for this too !!
@yon1623 10 ай бұрын
is FEE > Course also, the example is not a good one. also 2nf is not complete
@bokinalavijay6876 Жыл бұрын
Sir we always supports u sir
@sivakrishna8550 11 ай бұрын
dom properties meedha cheyyandi sir
@malugurashmitha5241 7 ай бұрын
Sir explain 4nf and 5bf sir
@rayagirihemanthkumar4797 Жыл бұрын
Sir the table which you have considered, I guess it's not in 2NF because I found Partial Functional Dependency in it (St_id , Course) ---> (Fee) {Its FD } Now breaking it:- (St_id) --> Fee is "FD" (Course) ---> Fee is also "FD" So the table is having partial Dependency then how can we solve it to get 3NF ???????
@anvinalias5259 Жыл бұрын
May be too late😅 You are right about the partial dependency. I guess, even though proceeded with 3nf, with out the condition for 2nf satisfied, the decomposition of the table satisfied both condition for 2nf as-well-as 3nf.
@raghulgunasekar2422 Жыл бұрын
Yes you are right!
@nagarajubattini2215 Жыл бұрын
Yes iam having the same doubt
@feliciazuko 11 ай бұрын
that is not partial dependency because St_id itself is a candidate key (it can uniquely identify the tuples) so (St_id,course) can't be a candidate key as CK is supposed to be minimal super key. And for partial dependency you need prime attribute -> non prime attribute. In this case, Std-id-> fee is not PD as Std_id is itself CK and not part of CK. And in course-> fee , course is not a prime attribute, it is a non prime attribute. So, this is transitive dependency and not partial dependency. This prolly is a bad explanation but I had the same doubt and after researching a bit I figured it out. Hope it helps
@pavankumarpadavala6369 Жыл бұрын
Thanks🙏🙏🙏