Re: Normalization question from newbie

From: Jason <>
Date: 13 Dec 2002 08:00:59 -0800
Message-ID: <> (Dave) wrote in message news:<>...
> 1. Suppose that we have a schema R(A, B, C, D, E) with FDs, F =
> {A&#8594;BC, CD&#8594;E, B&#8594;D, E&#8594;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

Original text of this message