Microsoft
98-364 · Question #8
You work as a Database Designer for Netwell Inc. The database has a table named Project, which is depicted below: - ProjectID - ProjectName - TaskID - TaskName - A - Macwell - Design - A - Macwell…
The correct answer is B. 3NF D. 2NF. See the full explanation below for the reasoning.
Question
You work as a Database Designer for Netwell Inc. The database has a table named Project, which is depicted below:
- ProjectID
- ProjectName
- TaskID
- TaskName
- A
- Macwell
- Design
- A
- Macwell
- Coding
- B
- Vintech
- Design
- B
- Vintech
- Coding
Is the table given above in normalized form? If not, then which normal form (NF) is violated?
Options
- AThe table is in normal form, as each cell contains only one value.
- B3NF
- C1NF
- D2NF
How the community answered
(30 responses)- A10% (3)
- B73% (22)
- C17% (5)
Community Discussion
No community discussion yet for this question.