Decomposing a relation into BCNF
Although the question is old, the other questions/answers don’t seem to provide a very clear step-by-step general answer on determining and decomposing relations to BCNF. 1. Determine BCNF: For relation R to be in BCNF, all the functional dependencies (FDs) that hold in R need to satisfy property that the determinants X are all superkeys … Read more