Hamish Burke | 2025-05-29
Related to: #databases
Synthesis Algorithm
- compute a lossless transformation into a set of 3NF relation schemas using the Synthesis algorithm
- Compute a Minimal Cover
of original set of - For each distinct left hand side
in , let be the union of all attributes such that . Form a relation schema - Let
be any candidate key of the original schema. If no contain , add one more schema - Eliminate any
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.