Exercise 19.14 JDs are motivated by the fact that sometimes a relation that cannot be decomposed into two smaller relations in a lossless-join manner can be so decomposed into three or more relations. An example is a relation with attributes supplier, part, and project, denoted SPJ, with no FDs or MVDs. The JD ⋈ {SP, PJ, JS} holds.
From the JD, the set of relation schemes SP, PJ, and JSis a lossless-join decomposition of SPJ. Construct an instance of SPJ to illustrate that no two of these schemes suffice.
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.