Which of the following statements is true about the Emp table?

You work as a Database Administrator for Softech Inc.The company has a database that contains a
table named Emp. The Emp table has the EmpId, Name, Department, and Designation attributes.
Recently, the table was modified by adding the Phone attribute. Some employees have more than
one phone number.

Which of the following statements is true about the Emp table?

A.
It violates 1NF.

B.
It violates 2NF.

C.
It violates 3NF.

D.
It does not violate any normal form.

Explanation:
The table violates 1NF, as 1NF states that each column in a row must hold a single value. But in this
case, the phone attribute at some places
is having more than one value. Therefore, in order to make it in 1NF, you will have to create a
separate table with Name, Phone1, and Phone2
as the attributes.