InterviewUp – Job Interview Questions and Answers – When is a functional dependency F said to be...

When is a functional dependency F said to be minimal?

Comments (0) |

Inappropriate

Asked By: mariann

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

Ø Every dependency in F has a single attribute for its right hand side.

Ø We cannot replace any dependency X A in F with a dependency Y A where Y is a proper subset of X and still have a set of dependency that is equivalent to F.

Ø We cannot remove any dependency from F and still have set of dependency that is equivalent to F.

Tags

Edit

database, RDBMS, Data Warehousing

Asked At

Edit

None

Job Titles

Edit

Comments (0) :

Your Name:

Add your comment text

Tags

database, RDBMS, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

If WinRunner and QTP both are functional testing tools from the same company. Why a separate tool QTP came in to picture?

Add or view comments about this interview question

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: shadesong |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

QTP has some additional functionality which is not present in WinRunner. For example,you can test(Functionality and Regression testing) an application developed in .Net technology with QTP,which is not possible to test in WinRunner

Create Date

Tuesday, May 13, 2008

Tags

Software Testing

Asked At

None

Job Positions

Software Engineer

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

What is normalization?

Inappropriate

Asked By: mariann |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties

Ø Minimizing redundancy

Ø Minimizing insertion, deletion and update anomalies.

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

What is Functional Dependency?

Inappropriate

Asked By: mariann |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

A Functional dependency is denoted by X Y between two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple that can form a relation state r of R. The constraint is for any two tuples t1 and t2 in r if t1[X] = t2[X] then they have t1[Y] = t2[Y]. This means the value of X component of a tuple uniquely determines the value of component Y.

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

What is Multivalued dependency?

Inappropriate

Asked By: mariann |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Multivalued dependency denoted by X Y specified on relation schema R, where X and Y are both subsets of R, specifies the following constraint on any relation r of R: if two tuples t1 and t2 exist in r such that t1[X] = t2[X] then t3 and t4 should also exist in r with the following properties

Ø t3[x] = t4[X] = t1[X] = t2[X]

Ø t3[Y] = t1[Y] and t4[Y] = t2[Y]

Ø t3[Z] = t2[Z] and t4[Z] = t1[Z]

where [Z = (R-(X U Y)) ]

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions