Relational Database Design and Modeling for Software Engineers
0% completed
Exercise 1
A company tracks which employees work on which projects. Everything sits in one table.
| Employee_ID | Employee_Name | Project_ID | Project_Name | Project_Manager |
|---|---|---|---|---|
| 101 | Anita | P1 | Alpha | Rohit |
| 101 | Anita | P2 | Beta | Sarita |
| 102 | Bala | P1 | Alpha | Rohit |
| 103 | Chandra | P3 | Gamma | Anita |
An employee can work on several projects. A project can have several employees on it. Each project has exactly one manager.
Your task
Decide whether this table is in second normal form. If it is not, convert it.
.....
.....
.....
Like the course? Get enrolled and start learning!
Reading Progress
0%