6.12- Second Normal Form in dbms | 2nf in normalization in dbms | Normalization | dbms online course

6.12- Second Normal Form in dbms | 2nf in normalization in dbms | Normalization | dbms online course PLAYLIST: DBMS - Data Base Management System Tutorials In Hindi | GATE- NET- DBMS Lectures in Hindi    • DBMS Complete Syllabus- All University exa...      • DBMS- Relational Database Design & Functio...   Relational Database Design- Functional Dependencies And Normalization second normal form database management system 2nf 2nd normal form second normal form in dbms 2nd normal form in dbms 2nd normal form explained 2nd normal form in hindi what is normalization in dbms dbms gate lectures, dbms ugc net lectures,2nd normal form in normalization,second normal form in normalization in hindi,2nf in normalization,what is 2nd normal form in normalization in dbms 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 Second Normal Form (2NF) A relation is in second normal form if it is in 1NF and all non-primary key attributes must be fully functionally dependent upon primary key attributes. Consider the relation Student as shown in Figure 6.10(a) : Student RollNo. Game Name Fee Grade 1 Cricket Amit 200 A 2 Badminton Dheeraj 150 B 3 Cricket Lalit 200 A 4 Badminton Parul 150 C 5 Hockey Jack 100 A 6 Cricket John 200 C (a) Roll No Game Name Fee Grade Dependency Chart (b) FIGURE 6.10. Student relation with anomalies. The Primary Key is (RollNo., Game). Each Student can participate in more than one game. Relation Student is in 1NF but still contains anomalies. 1. Deletion anomaly : Suppose you want to delete student Jack. Here you loose information about game Hockey because he is the only player participated in hockey. 2. Insertion anomaly : Suppose you want to add a new game Basket Ball having no student participated in it. You cannot add this information unless there is a player for it. 3. Updation anomaly : Suppose you want to change Fee of Cricket. Here, you have to search all the students participated in cricket and update fee individually otherwise it produces inconsistency. The solution of this problem is to separate Partial dependencies and Fully functional dependencies. So, divide Student relation into three relations Student(RollNo., Name), Games 6.1- Features Of Relational Database Design DBMS | relational database design | database design    • 6.1- Features Of Relational Database Desig...   6.2- Anomalies in Relational Database Design | insertion anomaly | deletion & Updation anomaly    • 6.2- Anomalies in Relational Database Desi...   6.3- Normalization In DBMS | Functional Dependency And Normalization | Introduction To Normalization    • 6.3- Normalization In DBMS | Functional De...   6.4- What Is Functional Dependency In DBMS | Functional Dependency And Normalization | Dbms Course    • 6.4- What Is Functional Dependency In DBMS...   6.5- First Normal Form in dbms With Example | 1NF in dbms | Normalization in Dbms | normal forms    • 6.5- First Normal Form in dbms With Exampl...   6.6- Prime And Non Prime Attributes In DBMS | Key Attributes In DBMS Normalization In DBMS | DBMS    • 6.6- Prime And Non Prime Attributes In DBM...   6.7- Fully Functional Dependency In DBMS | Types Of Dependencies in dbms | Normalization in dbms    • 6.7- Fully Functional Dependency In DBMS |...   6.8- Partial Functional Dependency In DBMS | Types Of Dependencies in dbms | Normalization in dbms    • 6.8- Partial Functional Dependency In DBMS...   6.9- Fully And Partial Functional Dependency | Functional Dependency And Normalization | Normal Form    • 6.9- Fully And Partial Functional Dependen...   6.10- Trival And Non Trival Functional Dependency | Functional Dependency And Normalization | DBMS    • 6.10- Trival And Non Trival Functional Dep...   6.11- Transitive And Non Transitive Functional dependency | Functional Dependency And Normalization    • 6.11- Transitive And Non Transitive Functi...   Notes Link: http://www.tutorialsspace.com/Downloa...