6.11 Transitive And Non Transitive Functional dependency | Functional Dependency And Normalization

PLAYLIST:
DBMS Data Base Management System Tutorials In Hindi | GATE NET DBMS Lectures in Hindi
   • DBMS Complete Syllabus All Universit...  

   • DBMS Relational Database Design & Fu...  
Relational Database Design Functional Dependencies And Normalization

transitive and non transitive dependency,
transitive functional dependency in dbms,
non transitive dependency in dbms 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,

ugc net dbms tutorials in hindi,
gate dbms tutorials,
ugc net dbms tutorials,

#gatedbmslecturesinhindi
#ugcnetdbmslecturesinhindi
#gatedbmslectures
#ugcnetdbmslectures
#dbmsLectures
#dbmsTutorials
#NormalizationInDbms

Types of Functional Dependencies
There are four major types of FD’s.
1. Partial Dependency and Fully Functional Dependency
Partial dependency : Suppose you have more than one attributes in primary key. Let A be the nonprime key attribute. If A is not dependent upon all prime key attributes then partial dependency exists.

Functional Dependency is when one attribute determines another attribute in a DBMS system.
Axiom, Decomposition, Dependent, Determinant, Union are key terms for functional dependency Four types of functional dependency are 1) Multivalued 2) Trivial 3) Nontrivial 4) Transitive Multivalued dependency occurs in the situation where there are multiple independent multivalued attributes in a single table The Trivial dependency occurs when a set of attributes which are called a trivial if the set of attributes are included in that attribute Nontrivial dependency occurs when AB holds true where B is not a subset of A. A transitive is a type of functional dependency which happens when it is indirectly formed by two functional dependencies
Normalization is a method of organizing the data in the database which helps you to avoid data redundancy

Notes:
http://www.tutorialsspace.com/Downloa...