Relational Database Design and Modeling for Software Engineers
Ask Author
Back to course home

0% completed

Vote For New Content
Exercise 2
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Problem Statement

A company maintains the following table to track employee information, which is already in Second Normal Form (2NF):

Emp_IDEmp_NameDOBAreaCityStateZip
101Alice1990-05-01DowntownNew YorkNY10001
102Bob1988-08-12MidtownNew YorkNY10002
103Charlie1992-11-23CentralLos AngelesCA90001
104David1985-03-15West EndChicagoIL60601

Task:

  1. Analyze whether the given table is in Third Normal Form (3NF).
  2. 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