What is functional dependency, Database Management System

 

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation state r of R. The constraint is for any two tuples t2 and t1 in r if t1[X] = t2[X] then they have t1[Y] = t2[Y]. This seems the value of X element of a tuple uniquely calculates the value of element Y.

 

 

1458_Functional Dependency.png

Posted Date: 7/30/2012 2:07:19 AM | Location : United States







Related Discussions:- What is functional dependency, Assignment Help, Ask Question on What is functional dependency, Get Answer, Expert's Help, What is functional dependency Discussions

Write discussion on What is functional dependency
Your posts are moderated
Related Questions
Find out the names of all employees who work for first Bank Corporation from database. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANYNAME = ‘First Bank Corporation';

What is foreign key? Foreign Key - Let there are two relations in tables R and S. Any candidate key of the relation R that is referred in the relation S is known as the forei

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

how many hourse have been spent on a certain project

Define upgrade and downgrade? It gives a mechanism for conversion from shared lock to exclusive lock is called as upgrade. It gives a mechanism for conversion from exclusive

Discuss the methods for a hash file to expand and shrink dynamically. What are the advantages and disadvantages of each? The hashing methods that permit dyanamic file expansi

it can be possible to create any table without primary key

Candidate Key:  In a relation R, a candidate key for R is a subset of the set of attributes of R, which have the differnt two properties: (1)        Uniqueness:                N


SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail: