First Normal Form (1NF) in DBMS Theory - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define First Normal Form (1NF) in database normalization.

DBMS Theory

1NF requires that each column in a table contains [1] values only.

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

Aduplicate

Bmultiple

Catomic

Dnull

Attempts:

3 left

💡 Hint

Common Mistakes

Thinking 1NF allows multiple values in a single column.

Confusing 1NF with higher normal forms.

First Normal Form (1NF) means each column must have atomic (indivisible) values, no sets or lists.

2fill in blank

medium

Complete the statement about 1NF regarding table structure.

DBMS Theory

A table is in 1NF if it has no [1] groups or arrays in any column.

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

Aredundant

Bindexed

Cempty

Dnested

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing nested groups with empty or redundant data.

Thinking indexes affect 1NF.

1NF requires no nested groups or arrays in columns; each field must be atomic.

3fill in blank

hard

Fix the error in the definition of 1NF.

DBMS Theory

1NF means each column can have [1] values, including lists or sets.

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

Aatomic

Bduplicate

Cnull

Dmultiple

Attempts:

3 left

💡 Hint

Common Mistakes

Believing 1NF allows lists or sets in columns.

Mixing 1NF rules with those of higher normal forms.

The error is that 1NF does NOT allow multiple values like lists or sets; it requires atomic values.

4fill in blank

hard

Fill both blanks to complete the 1NF condition for table columns.

DBMS Theory

Each column must contain [1] values and must not have [2] groups.

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

Aatomic

Bnull

Crepeating

Dindexed

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing null or indexed instead of repeating groups.

Confusing atomic with null values.

1NF requires atomic values and no repeating groups in columns.

5fill in blank

hard

Fill all three blanks to describe the 1NF rule for table columns.

DBMS Theory

In 1NF, each column must have [1] values, no [2] groups, and each record must be uniquely [3].

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

Aatomic

Brepeating

Cidentified

Dindexed

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing indexed with identified.

Thinking repeating groups are allowed.

1NF requires atomic values, no repeating groups, and unique identification of records.