Back to course home
0% completed
Vote For New Content
Exercise 2
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.
.....
.....
.....
Like the course? Get enrolled and start learning!
Table of Contents
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible