Problem Statement
A company maintains a table to track employee projects. The table is as follows:
| Employee_ID | Employee_Name | Project_ID | Project_Name | Project_Manager |
|---|---|---|---|---|
| 101 | Alice | P1 | Alpha | John |
| 101 | Alice | P2 | Beta | Sarah |
| 102 | Bob | P1 | Alpha | John |
| 103 | Charlie | P3 | Gamma | Alice |
Analyze whether this table is in Second Normal Form (2NF). If it is not, provide a solution by converting the table into 2NF.
Hint
- Identify the primary key of the table.
- Check for any attributes that depend only on a part of the primary key.
We will discuss the solution in the next lesson.
Last updated on