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
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

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? 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 ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.

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

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

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? The two types of serializability is a)      Conflict serializability b)      View serializability

WHAT IS MEANT BY E-R MODEL

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