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?
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 tomake 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, itis also not in 3NF. Answer is incorrect. The tableis in 1NF, as
each row contains atomic values, i.e. each cell contains a single value. Reference: Database Management
Systems, Contents:
“Database Normalization”