Microsoft
98-364 · Question #71
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 correct answer is A. It violates 1NF. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AIt violates 1NF.
- BIt violates 2NF.
- CIt violates 3NF.
- DIt does not violate any normal form.
How the community answered
(27 responses)- A85% (23)
- B4% (1)
- C4% (1)
- D7% (2)
Community Discussion
No community discussion yet for this question.
