Crowdly
Add to Chrome
Consider the following relation: Project ( ProjectID , ProjectName, ManagerID, ...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Consider the following relation: Project (ProjectID, ProjectName, ManagerID, ManagerName, DepartmentID, DepartmentName). The following dependencies exist:
- ProjectID → ProjectName, ManagerID, DepartmentID
- ManagerID → ManagerName
- DepartmentID → DepartmentName
Note: The underlined column/attribute is PK.
What is the minimum number of tables required to normalize this relation to 3NF?
0%
0%
0%
0%