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.

 

 

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

Ask an Expert

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

Write your message here..

Related Questions

Higher normal forms, Higher Normal Forms Is there more normal forms beyond... Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if

Entity identifier key attributes, An entity type usually has an attribute w... An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Explain record based logical models, Explain Record Based Logical Models? ... Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall

Explain data dictonary on oracle, Explain data dictonary on oracle ? Da... Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.

What is abstraction, What is abstraction? Abstraction in the object ori... What is abstraction? Abstraction in the object orientation is a idea that provide opportunity to express necessary properties of object without providing much details of the im

Recovery management component, Ask question #Minim 100 words accepted#what ... Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

Computer, 1. Will you advise that your organization uses open source softwa... 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

What are the two types of serializability, What are the two types of serial... What are the two types of serializability? The two types of serializability is a)      Conflict serializability b)      View serializability

E-R MODEL, WHAT IS MEANT BY E-R MODEL WHAT IS MEANT BY E-R MODEL

Explain strict two-phase locking, Explain Strict Two-Phase locking A tr... Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact