Back to course home
0% completed
Vote For New Content
Exercise 1
Problem Statement
A company maintains a table to track employee projects. The table is as follows:
Employee_ID | Employee_Name | Project_ID | Project_Name | Project_Manager |
---|---|---|---|---|
101 | Alice | P1 | Alpha | John |
101 | Alice | P2 | Beta | Sarah |
102 | Bob | P1 | Alpha | John |
103 | Charlie | P3 | Gamma | Alice |
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