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
1
Design
A
Macwell
2
Coding
B
Vintech
1
Design
B
Vintech
2
Coding
Is the table given above in normalized form? If not, then which normal form (NF) is violated?
A.
The table is in normal form, as each cell contains only one value.
B.
3NF
C.
1NF
D.
2NF
Explanation:
and The table given above violates 2NF, as TaskID and TaskName are not functionally dependent on
the primary key attribute, i.e. ProjectID. TaskID functionally determines TaskName. Therefore, in
order to make it in 2NF, you should split the
parent table Project and create a table named Task with TaskID as the primary key attribute and
migrate ProjectID to the Task table as the
foreign key. The table is not in 2NF. Therefore, it is also not in 3NF.
Answer is incorrect. The table is in 1NF, as each row contains atomic
values, i.e. each cell contains a single value. Reference: Database Management Systems, Contents:
“Database Normalization”