loadingb)
c)
Again from Augmentation rule of Functional Dependency, given BM -> D then
BMN -> D
Thus we can just add an arrow entering Doctors to fig 4.15. Below figure represents more accurate information however.
4.2.6 a)
b) Transitivity and Augmentation rules of Functional Dependency allow arrow entering Mothers from Births. However, a new relationship in below figure represents more accurate information.
c)
Design flaws in abc above 1. As suggested above, using Transitivity and
Augmentation rules of Functional Dependency, much simpler design is possible.
4.2.7
In below figure there exists a many-to-one relationship between Babies and Births and another many-to-one relationship between Births and Mothers. From transitivity of relationships, there is a many-to-one relationship between Babies and Mothers. Hence a baby has a unique mother while a birth can allow more than one baby.
4.3.1 a)