Relational Database Design and Modeling for Software Engineers

0% completed

Previous
Next
Exercise 1

Problem Statement

A company maintains a table to track employee projects. The table is as follows:

Employee_IDEmployee_NameProject_IDProject_NameProject_Manager
101AliceP1AlphaJohn
101AliceP2BetaSarah
102BobP1AlphaJohn
103CharlieP3GammaAlice

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.

.....

.....

.....

Like the course? Get enrolled and start learning!
Previous
Next