Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Normalization question from newbie

Normalization question from newbie

From: Dave <dchou1108_at_hotmail.com>
Date: 12 Dec 2002 20:40:49 -0800
Message-ID: <8f19196e.0212122040.600606f3@posting.google.com> 





    
  
  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



Received on Thu Dec 12 2002 - 22:40:49 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US