Re: Normalization question from newbie
From: Jason <pmorrison_at_4lpi.com>
Date: 13 Dec 2002 08:00:59 -0800
Message-ID: <cf188409.0212130800.364e6c7b_at_posting.google.com>
Date: 13 Dec 2002 08:00:59 -0800
Message-ID: <cf188409.0212130800.364e6c7b_at_posting.google.com>
dchou1108_at_hotmail.com (Dave) 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
Shouldn't you at least rephrase this to pretend it's not a homework assignment? Received on Fri Dec 13 2002 - 17:00:59 CET