Functional dependency definition in DBMS Theory - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the sentence to define functional dependency: In a relation, attribute B is functionally dependent on attribute A if each value of A is associated with exactly {{BLANK_1}} value of B.

DBMS Theory

In a relation, attribute B is functionally dependent on attribute A if each value of A is associated with exactly [1] value of B.

Drag options to blanks, or click blank then click option'

Amultiple

Bmany

Czero

Done

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'many' or 'multiple' which implies multiple B values for one A.

Functional dependency means for each value of attribute A, there is exactly one corresponding value of attribute B.

2fill in blank

medium

Complete the statement: If attribute A functionally determines attribute B, it is denoted as A {{BLANK_1}} B.

DBMS Theory

If attribute A functionally determines attribute B, it is denoted as A [1] B.

Drag options to blanks, or click blank then click option'

A=

B<-

C->

D=>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<-' or '=' which are incorrect notations for functional dependency.

The notation for functional dependency is A -> B, meaning A determines B.

3fill in blank

hard

Fix the error in this definition: 'A functional dependency A {{BLANK_1}} B means B uniquely determines A.'

DBMS Theory

A functional dependency A [1] B means B uniquely determines A.

Drag options to blanks, or click blank then click option'

A<-

B=

C->

D=>

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing the direction of functional dependency arrows.

The statement is reversed. If B uniquely determines A, the correct notation is B -> A, so A <- B.

4fill in blank

hard

Fill both blanks to complete the functional dependency definition: Attribute B is functionally dependent on attribute A if for every {{BLANK_1}} of A, there is exactly {{BLANK_2}} value of B.

DBMS Theory

Attribute B is functionally dependent on attribute A if for every [1] of A, there is exactly [2] value of B.

Drag options to blanks, or click blank then click option'

Avalue

Bmany

Cone

Dattribute

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'attribute' instead of 'value' for the first blank.

Functional dependency means for every value of A, there is exactly one value of B.

5fill in blank

hard

Fill all three blanks to complete the functional dependency notation: If {{BLANK_1}} functionally determines {{BLANK_2}}, it is written as {{BLANK_3}}.

DBMS Theory

If [1] functionally determines [2], it is written as [3].

Drag options to blanks, or click blank then click option'

Aattribute A

Battribute B

CA -> B

DB -> A

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the attributes or the arrow direction in the notation.

The correct notation is: If attribute A functionally determines attribute B, it is written as A -> B.