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 t₁ and t₂ in r like t1 [α] =t2 [α], and also t₁ [β] =t₂ [β].

 

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

Ask an Expert

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

Write your message here..

Related Questions

What is a view, What is a view?  Make a view of EMP table named DEPT 20, to... What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist

What is business intelligence, Question A What is operational intelligence... Question A What is operational intelligence? Question B What is Business Intelligence? Explain the components of BI architecture Question C Differentiate between databas

Dataset, The dataset " CFOLYMPICS.XLS " contains the observations used in t... The dataset " CFOLYMPICS.XLS " contains the observations used in the above article.  The definitions of the variables are also included in this spreadsheet.  However, for the purpo

CMIS 420 Homework Assignment 2, describe all the tables you have created. ... describe all the tables you have created. ?get table_name, status, num_rows, user_stats in user_tables system view ?get table_name, constraint_name, constraint_type in user_constr

User error-database errors, User error :  This contains errors in the progr... User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa... Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Dataware house(job scheduling strategy), Define a job scheduling strategy t... Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

The result of the union operation between r1 and r2, The result of the UNIO... The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c

What database management system, Company XYZ is an advertising company. It... Company XYZ is an advertising company. It has its own website but the search facilities offered are not reliable. The company is willing to invest to acquire new machines and sof

Define the unique constraints for the table client, Define the following co... Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1