Question

If all the domains are atomic then the relational schema is in ________ normal form

(a) 1

(b) 2

(c) 3

(d) 4

The question was asked in an internship interview.

I want to ask this question from Features of Good Relational Design topic in portion Relational Database Design of RDBMS

Answer 1

Correct answer is (a) 1

To explain I would say: If all the domains are atomic then the relational schema is in first (1) normal form. That is, the domains must be indivisible.