Exercise 2

Relational Database Design and Modeling for Software Engineers

0% completed

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

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.

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!