6.4- What Is Functional Dependency In DBMS | Functional Dependency And Normalization | Dbms Course

Описание: 6.4- What Is Functional Dependency In DBMS | Functional Dependency And Normalization | Dbms 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

functional dependency in dbms in hindi
functional dependency
functional dependency in dbms
functional dependency in hindi
functional dependency numericals
functional dependency numericals 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,

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

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

Functional dependencies are the result of interrelationship between attributes or in between tuples in any relation.
Definition : In relation R, X and Y are the two subsets of the set of attributes, Y is
said to be functionally dependent on X if a given value of X (all attributes in X) uniquely
determines the value of Y (all attributes in Y).
It is denoted by X → Y(Y depends upon X).
Determinant : Here X is known as determinant of functional dependency.
Consider the example of Employee relation:

In Employee relation, EID is primary key. Suppose you want to know the name and salary
of any employee. If you have EID of that employee, then you can easily find information
of that employee. So, Name and Salary attributes depend upon EID attribute.
Here, X is (EID) and Y is (Name, Salary)
X (EID) : Y (Name, Salary)
The determinant is EID
Suppose X has value 5 then Y has value (Manoj, 9,000)
6.3.1 Functional Dependency Chart/Diagram
It is the graphical representation of function dependencies among attributes in any relation.
The following four steps are followed to draw FD chart.
1. Find out the primary key attributes.
2. Make a rectangle and write all primary key attributes inside it.
3. Write all non-prime key attributes outside the rectangle.
4. Use arrows to show functional dependency among attributes.
igure 6.2.
Name
Salary
EID
Employee
FIGURE 6.2. Functional dependency chart of employee relation.
It is easier to remember all dependencies by making FD charts.
Example. Consider the following relation:
Professor (Pfcode, Dept, Head, Time) It is assumed that
(i) A professor can work in more than one dept.
(ii) The time he spends in each dept is given.
(iii) Each dept has only one head.
Draw the dependency diagram for the given relation by identifying the dependencies.

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...   Notes Link:
http://www.tutorialsspace.com/Downloa...