Problem Statement
A company maintains the following table to track employee information, which is already in Second Normal Form (2NF):
| Emp_ID | Emp_Name | DOB | Area | City | State | Zip |
|---|---|---|---|---|---|---|
| 101 | Alice | 1990-05-01 | Downtown | New York | NY | 10001 |
| 102 | Bob | 1988-08-12 | Midtown | New York | NY | 10002 |
| 103 | Charlie | 1992-11-23 | Central | Los Angeles | CA | 90001 |
| 104 | David | 1985-03-15 | West End | Chicago | IL | 60601 |
Task:
- Analyze whether the given table is in Third Normal Form (3NF).
- If the table is not in 3NF, convert it to 3NF by eliminating transitive dependencies.
Hint:
- Identify the primary key of the table.
- Determine if table is in the 2NF or not.
- Check for transitive dependencies:
- Attributes like Area, City, and State depend on Zip rather than directly on Emp_ID.
- Remove transitive dependencies by splitting the table into smaller tables.
In the next lesson, we will provide the solution to this problem.
Last updated on