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
Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

A well-maintained relational DBMS has a high level of data integrity. What features of a relational DBMS contribute towards this level of integrity? Relational DBMS gives high

Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes

Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)

What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

A relationship set is a set of relationships of the similar type. For example, let consider the relationship among two entities sets course and student. Collection of all the in

Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which