6.19- Numerical Convert A Relation Into 3nf | Convert relation in third normal form | normalization

6.19- Numerical Convert A Relation Into 3nf | Convert relation in third normal form | normalization PLAYLIST: DBMS - Data Base Management System Tutorials In Hindi | GATE- NET- DBMS Lectures in Hindi https://www.youtube.com/playlist?list=PLL8qj6F8dGlSZrqH37DY_4rsfeOkieH54 https://www.youtube.com/playlist?list=PLL8qj6F8dGlTPwehYtDHELNFZ5sguolL9 Relational Database Design- Functional Dependencies And Normalization dbms tutorials, database management system tutorial, database tutorials, relational database design, dbms lectures, normalization in dbms, what is normalization in dbms, dbms gate lectures in hindi, dbms gate lectures, dbms gate lectures in hindi, dbms ugc net lectures, #gatedbmslecturesinhindi #ugcnetdbmslecturesinhindi #gatedbmslectures #ugcnetdbmslectures #dbmsLectures #dbmsTutorials #NormalizationInDbms Third Normal Form (3NF) A relation is in Third Normal Form if it is in 2NF and non-primary key attributes must be non-transitively dependent upon primary key attributes. In other words a relation is in 3NF if it is in 2NF and having no transitive dependency. Consider the relation StudentStudent RollNo. Name Semester Hostel 1 Lalit 1 H1 2 Gaurav 2 H2 3 Vishal 1 H1 4 Neha 4 H4 5 John 3 H3 (a) Functional Dependency and Normalisation 219 RollNo Name Semester Hostel The Primary Key is (RollNo.). The condition is different Hostel is allotted for different semester. Student relation is in 2NF but still contains anomalies. 1. Deletion anomaly : If you want to delete student Gaurav. You loose information about Hostel H2 because he is the only student staying in hostel H2. 2. Insertion anomaly : If you want to add a new Hostel H8 and this is not allotted to any student. You cannot add this information. 3. Updation anomaly : If you want to change hostel of all students of first semester. You have to search all the students of first semester and update them individually otherwise it causes inconsistency. The solution of this problem is to divide relation Student into two relations Student(RollNo. Name, Semester) and Hostels(Semester, Hostel) 6.14- How To Find The Closure Set Of Functional Dependencies With Example | Normal Forms | dbms https://youtu.be/4nVBR_zM69k 6.15- Finding Candidate Key of a Relation By Closure | closure of attributes | Normalization https://youtu.be/V3xdAFhpfDY 6.16- Numerical Of Finding Candidate Key Of a Relations By Closure Functional Dependency https://youtu.be/FP1bryOJgyI 6.17- Convert a relation into 2nf | Second Normal Form | Functional Dependency And Normalization https://youtu.be/FxvQFx1l4F8 6.18- Third normal form In DBMS With Easy Example | 3nf in dbms | Normalization in dbms https://youtu.be/2q-22j2QmrM Notes Link: http://www.tutorialsspace.com/Download-Pdf-Notes/DBMS-Notes.aspx