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?
❌
✅
❌
❌
Want instant access to all verified answers on eclass.yorku.ca?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!