6.10- Trival And Non Trival Functional Dependency In DBMS | Functional Dependency And Normalization

6.10- Trivial And Non Trivial Functional Dependency | Functional Dependency And Normalization | DBMS 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 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 functional dependencies in dbms types of functional dependency in dbms functional dependency in dbms in hindi trivial dependency in dbms trivial and nontrivial functional dependency in dbms 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 non-prime key attribute. If A is not dependent upon all prime key attributes then partial dependency exists. Fully functional dependency : Let A be the non-prime key attribute and value of A is dependent upon all prime key attributes. Then A is said to be fully functional dependent. Consider a relation student having prime key attributes (RollNo and Game) and non-prime key attributes (Grade, Name and Fee). fully functional dependency of student relation. As shown in Figure 6.4, Name and Fee are partially dependent because you can find the name of student by his RollNo. and fee of any game by name of the game. Grade is fully functionally dependent because you can find the grade of any student in a particular game if you know RollNo. and Game of that student. Partial dependency is due to more than one prime key attribute. 2. Transitive Dependency and Non-transitive Dependency  Transitive dependency : Transitive dependency is due to dependency between non-prime key attributes. Suppose in a relation R, X → Y (Y depen upon X), Y → Z (Z depends upon Y), then X → Z (Z depends upon X). Therefore, Z is said to be transitively dependent upon X.  Non-transitive dependency : Any functional dependency which is not transitive is known as Non-transitive dependency. Non-transitive dependency exists if there is no dependency between non-prime key attributes. non-transitive dependency on relation student. For each semester there is different hostel Here Hostel is transitively dependent upon RollNo. Semester of any student can be find by his RollNo. Hostel can be find out by semester of student. Here, Name is non-transitively dependent upon RollNo. 198 Introduction to Database Management System 3. Single Valued Dependency and Multivalued Dependency  Single valued dependency : In any relation R, if for a particular value of X, Y has single value then it is known as single valued dependency.  Multivalued dependency (MVD) : In any relation R, if for a particular value of X, Y has more then one value, then it is known as multivalued dependency. It is denoted by X →→ Y. http://www.tutorialsspace.com/Downloa...