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 theEmp 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.