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

0% completed

Vote For New Content
Exercise 1
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 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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible