Exercise 19.18 Consider a relation R with attributes ABCDE. Let the following FDs be given: A → BC, BC → E, and E → DA. Similarly, let Sbe a relation with attributes ABCDE and let the following FDs be given: A → BC, B → E, and E → DA. (Only the second dependency differs from those that hold over R.) You do not know whether or which other (join) dependencies hold.
1. Is R in BCNF?
2. Is R in 4NF?
3. Is R in 5NF?
4. Is S in BCNF?
5. Is S in 4NF?
6. Is S in 5NF?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.