id: 06013577
dt: a
an: 06013577
au: Makowsky, Johann A.; Ravve, Elena V.
ti: BCNF via attribute splitting.
so: Düsterhöft, Antje (ed.) et al., Conceptual modelling and its theoretical
    foundations. Essays dedicated to Bernhard Thalheim on the occasion of
    his 60th birthday. Berlin: Springer (ISBN 978-3-642-28278-2/pbk).
    Lecture Notes in Computer Science 7260, 73-84 (2012).
py: 2012
pu: Berlin: Springer
la: EN
cc: 
ut: 
ci: 
li: doi:10.1007/978-3-642-28279-9_7
ab: Summary: Boyce-Codd-Heath introduced criteria for good database design,
    which can be formulated in terms of FD’s only. Classical design
    decomposes relations iteratively using projections. BCNF can not be
    always achieved using projections alone. 3NF was introduced as a
    compromise. In this paper we summarize all the known characterizations
    of BCNF and formulate a new one. In [MR96], attribute splitting was
    suggested as a heuristics to achieve BCNF in case projections do not do
    the job. Here we show how attribute splitting can be used to
    restructure a database scheme iteratively such that the result will be
    in BCNF, is information preserving and preserves the functional
    dependencies.
rv: