Third Normal Form (3NF) in DBMS Theory - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the sentence to define Third Normal Form (3NF).

DBMS Theory

A table is in Third Normal Form if it is in Second Normal Form and every non-prime attribute is [1] on the primary key.

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

Atransitively dependent

Bdirectly dependent

Cindependent

Dpartially dependent

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing transitive dependency with direct dependency.

Thinking partial dependency is allowed in 3NF.

Third Normal Form requires that all non-prime attributes depend directly on the primary key, not through another attribute.

2fill in blank

medium

Complete the sentence to identify a violation of 3NF.

DBMS Theory

If a non-prime attribute depends on another non-prime attribute, it causes a [1] dependency, violating 3NF.

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

Atransitive

Bpartial

Cdirect

Dfunctional

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up partial and transitive dependencies.

Assuming direct dependency causes 3NF violation.

Transitive dependency occurs when a non-prime attribute depends on another non-prime attribute, which violates 3NF.

3fill in blank

hard

Fix the error in the statement about 3NF.

DBMS Theory

3NF requires that every attribute is [1] on the whole primary key and no transitive dependencies exist.

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

Afully dependent

Bindependent

Ctransitively dependent

Dpartially dependent

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing partial dependency with full dependency.

Ignoring the removal of transitive dependencies.

3NF requires full functional dependency on the primary key and no transitive dependencies.

4fill in blank

hard

Fill both blanks to complete the 3NF condition.

DBMS Theory

A relation is in 3NF if it is in [1] and no non-prime attribute is [2] on another non-prime attribute.

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

A2NF

B1NF

Ctransitively dependent

Dpartially dependent

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 1NF instead of 2NF as the base.

Confusing partial dependency with transitive dependency.

3NF requires the relation to be in Second Normal Form and to have no transitive dependencies among non-prime attributes.

5fill in blank

hard

Fill all three blanks to describe 3NF requirements.

DBMS Theory

To be in 3NF, a table must be in [1], have no [2] dependencies, and every non-prime attribute must depend [3] on the primary key.

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

A2NF

Btransitive

Cdirectly

D1NF

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 1NF instead of 2NF.

Mixing up transitive and partial dependencies.

Thinking non-prime attributes can depend indirectly.

3NF requires the table to be in Second Normal Form, have no transitive dependencies, and all non-prime attributes to depend directly on the primary key.