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...