Relational Database Design

A functional dependency is denoted by ….... symbol

• &
• *
• →
• %

A functional dependency is a relationship between or among …….

• Tables
• Rows
• Relations
• Attributes

Which of the following is not Armstrong’s Axiom?

• Reflexivity rule
• Transitivity rule
• None of these
• Augmentation rule

We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

• Axioms
• Armstrong’s axioms
• Armstrong
• Closure

There are two functional dependencies with the same set of attributes on the left side of the arrow: A→BC A→B This can be combined as

• A→BC
• A→B
• B→C
• None of the mentioned

Which of the following is a trivial functional dependency?

• A->A
• A->B, if B is a subset of A
• B->B
• All of these

For a relation R(X, Y, Z, W) with primary key(X, Y) a functional dependency XY→Z is said to be ___________.

• Full Dependency
• Partial Dependency
• Trivial Dependency
• None of these

If F is a set of functional dependencies, then the closure of F is denoted by?

• F+
• Fo
• F
• F*

If K → L then ___ → LM.

• KM
• LM
• KL
• NONE

If a functional dependency is reflexive, Y is a subset of X and X is the set of attributes, then

• Y→X holds
• XY→Z holds
• X→Y holds
• None of these