What is meant by functional dependencies, Database Management System

What is meant by functional dependencies?

Consider a relation schema R and α C R and β C R. The functional dependency α ->β  holds on relational schema R if in any legal relation r(R), for all pairs of tuples t1 and t2 in r like t1 [α] =t2 [α], and also t1 [β] =t2 [β].


Posted Date: 6/1/2013 5:39:07 AM | Location : United States

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

Write discussion on What is meant by functional dependencies
Your posts are moderated
Related Questions
Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

Analyzing Association Traversal Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application,

Explain how you can define an object model of a system. A list of terms that shall be used by end users to describe state and behaviour of objects in system.   Different use

One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

Explain the cartesian product in Database Management System