The project guidance relation of Exercise 10.8.3 needs further normalization to 5 NF because
1.There are too many multivalued dependencies
2.Multivalued dependency and simple dependency are mixed in the 4 NF relation
3.Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects
4.4 NF relations have composite keys
Posted Date:-2021-12-09 15:12:52