Hamish Burke | 2025-05-29

Related to: #databases


Synthesis Algorithm

  1. Compute a Minimal Cover Fc of original set of F
  2. For each distinct left hand side X in Fc, let Y be the union of all attributes A such that XAFc. Form a relation schema RX=XY
  3. Let K be any candidate key of the original schema. If no RX contain K, add one more schema RK=K
  4. Eliminate any RX that is a strict subset of another schema

Result: A collection of relation schemas in 3NF that preservers FD's and guarantees a lossless join.