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
Define a relation ? Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a lis

What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.

Foreign Keys and NULL Let us take the relation:                 DEPT DEPT ID DNAME BUDGET D1 M

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?  How many levels of SP nesting is possible? Recursion is method of proble

Question: (a) What is ODBC and what is its function? (b) What is Web application server, and how does it work from a database perspective? (c) What does e-commerce mean

Lock Based Protocol A lock is nothing but a mechanism that tells the DBMS whether a particular data item is being used by any transaction for read/write purpose. As there are t

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o

Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi