Re: Normalization question from newbie
From: stu <smcgouga_at_nospam.co.uk>
Date: Mon, 16 Dec 2002 16:28:48 -0000
Message-ID: <atkv1q$fdf$1$8300dec7_at_news.demon.co.uk>
Date: Mon, 16 Dec 2002 16:28:48 -0000
Message-ID: <atkv1q$fdf$1$8300dec7_at_news.demon.co.uk>
You forgot to take the marks allocated to the question out. Whoops!
Stu
"Dave" <dchou1108_at_hotmail.com> wrote in message
news:8f19196e.0212122040.600606f3_at_posting.google.com...
> 1. 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
Received on Mon Dec 16 2002 - 17:28:48 CET