Normalization question from newbie
From: Dave <dchou1108_at_hotmail.com>
Date: 12 Dec 2002 20:40:49 -0800
Message-ID: <8f19196e.0212122040.600606f3_at_posting.google.com>
Date: 12 Dec 2002 20:40:49 -0800
Message-ID: <8f19196e.0212122040.600606f3_at_posting.google.com>
- Suppose that we have a schema R(A, B, C, D, E) with FDs, F =
{A→BC, CD→E, B→D, E→A} [20]
(a) Show that the decomposition into R1(A, B, C) and R2(A, D, E) is a
lossless-join decomposition.
(b) Show that the decomposition R1(A, B, C) and R2(A, D, E) is not a
dependency-preserving decomposition.
(c) Give a lossless-join, dependency-preserving decomposition into 3NF
of the schema